Waterfall charts are a great way to show how a value changes over time, but not everything about them is obvious. In this step-by-step guide we walk you through all you need to know.

...
Read More

In the first part of this tutorial series on writing Excel macros, we created a very simple macro and looked at how to run it from your workbook. In this part, we’ll dig a little more into the anatomy of a macro – looking at what your options are as you create a new macro, at

Read More

Creating a macro is a step towards a more powerful you. With macros you can do almost limitless things to customise, integrate and gain power from Microsoft Office – and more. Take the first step, and create a macro in just 60 seconds

...
Read More

Unleash the hidden power of Microsoft Excel!As you probably know, Excel is packed with useful tools and great features.But did you know that there are so many tools that they deliberately hide some of them away?Many of these tools are tools which used to be available in old versions of Excel, but have been superseded

Read More

10 signs that you need to move your spreadsheets into a databaseIf you’re like most people, you will work with many more spreadsheets than databases. Yes, you may work with 3 or 4 – or maybe half a dozen – different databases for your job, but you probably have a dozen or more spreadsheets that

Read More

Do you use Excel to manage your data? If so, you need to use Data Validation. In this video, we look at how to use it – and when it may let you down!

...
Read More