Blog & Excel Tips

A common requirement in Excel is to identify positive and negative numbers. This is usually to apply a different calculation to it e.g. a positive (credit) bank balance earns say 5% but a negative bank balance (debit or overdraft) incurs an interest charge of 10%.

If you are familiar with resizing columns or rows to fit the text in Excel, but do the step to each individual row or column, this is a quick way to resize all columns to fit text in Excel at the same time.

If you already make use of the IF function you may have come across the situation where IF does not seem to work, particularly when you are comparing to True and False answers.

...In earlier versions you could close the workbooks in such a way that you end up with a grey screen (Excel open but no open workbooks) and you could open a new workbook from there. Two ways to achieve the same things in Excel 2013 and up i.e. close the workbook but not Excel...

How can we reverse data in Excel so that it goes from the oldest to the newest. The method used depends on what you are reversing and whether you want it to repeat the process or whether it is a once off.

How to make the cursor start on the same cell in each sheet to avoid you scrolling up, down, left and right each time you are looking for a particular cell.

What is after Excel Level 3? Have you attended Excel 3 (advanced) and been disappointed. You know there is more within Excel but the course didn't show it...

In a previous post we showed how to export a list of filenames from a folder into Excel. But what can you do to export a list of files AND subfolders AND files in these subfolders into an Excel list? Here we are going to use a small trick in PowerQuery to export folder and subfolder list to Excel.