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.
Get more from your spreadsheets
We've spent many years working with our clients to
- Train staff with the latest Excel skills
- Fix existing issues with business-critical spreadsheets
- Create new systems and templates using Excel
- Integrate Excel with other applications
Now you can learn from us too!
Browse our knowledgebase of Microsoft Excel articles
We're adding to our Excel knowledgebase all the time, so why not sign up at the bottom of this page to be the first to know when we publish new content? Functions, database functionality, VBA and more - delivered straight to your Inbox!
Sign Up Now and Never Miss Out!
Don't miss a thing!
We publish new content regularly, so be the first to hear about it by signing up now!
Creating Excel Macros (part 2)
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
Creating Excel Macros (part 1)
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
Over 100 hidden tools in Microsoft Excel
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
When should you use a database?
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
Excel’s data validation tool is not reliable…
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!
Experience THe Difference - Now!
Want to learn more? Take a look at our online courses!
For the first time ever, our training is now available online.
Now anyone, anywhere can experience the quality of training and the depth of knowledge that makes our courses different.