Excel Tips & Tricks

Do you need to generate random numbers to test formulas? Consider using the RANDBETWEEN function. The function can be used to create some random numbers for testing of formulas so that you don’t need to make them up. The RANDBETWEEN

Data Validation enables you to create a drop down list to control the type of data or the values that users enter into a cell. For instance if you have a list of employees and want to assign a department

In last months Excel Financial Functions video tip, we spoke about the PMT Function and its use in calculating the repayment amount on a loan. In this tip we will go a bit more in-depth and introduce you to the

Have you ever needed to change the orientation of a range of cells whilst maintaining links to the source data and had to manually recreate the spreadsheet? Well, there’s a quicker way – the TRANSPOSE function. The TRANSPOSE function returns

When working on a project timeline the end date should always be greater than the start date; however an error can occur when entering the dates manually into a spreadsheet. By using Date Data Validation you can ensure that the

In Excel 2010, there is a way to automatically highlight up-coming and past due dates. For example, if one has expiry dates for stock in a spreadsheet it is possible to highlight the stock that has expired and the stock

Are you looking for an easy and effective method of displaying the period for a given date? Perhaps you have a sales report and you intend to analyse the dates by periods, then the Custom Format option is the answer.

The Excel PMT (payment) Function is a really simple to use but highly useful Financial Function used to calculate the repayment amount on a loan. This function assumes that payments are made consistently (repayment frequency and amount remain constant) at

If you’ve worked with formulas, you’ve probably encountered the dreaded formula error; rather than returning a numeric result, the formula cell displays a strange message such as #VALUE! or #DIV/0!. Most of the time, this means you need to track