Random Numbers in Excel

less than 1 minute read

To generate a random number in Excel, use the RAND() function, which returns a random number between 0 and 1. It will return a different random number each t...

Today’s date in Excel

2 minute read

Working with dates is a key task in Excel. This tutorial will show you a few ways to get the current date in Excel 2003, Excel 2007 and Excel 2010.

Colour Cell Borders in Excel

less than 1 minute read

This is quite a simple tutorial, but it can help to make your Excel 2007 or Excel 2010 spreadsheets more attractive if used sparingly. We’ll show you the ste...

Shortcut Key to Paste Values in Excel

less than 1 minute read

If you came here looking for an easy short-cut key to paste values in Excel then it’s bad news I’m afraid - there just isn’t a simple keyboard shortcut in th...

Password Protect Excel Spreadsheets

1 minute read

If you’re using Excel 2007 or later, the option to require a password to open an Excel spreadsheet may be in a different place than you are used to in earlie...

Temperature Conversion in Excel

less than 1 minute read

Excel 2007 and Excel 2010 make it easy to convert between different units, such as temperatures using the CONVERT() function.

Display the Weekday as Text in Excel

1 minute read

I often want to know what day of the week a date is. Excel has a function for this, but unfortunately it only returns an integer, for example the function: