by admin | Feb 22, 2022 | Excel Path - Step by Step, Excel | General
Excel has really upped its games around charts in the last couple of editions but there are some charts that are not so well known. In this blog post I am going to introduce you to two of them: The Tree Map and the funnel. You can use this file to practise on and here...
by admin | Feb 12, 2022 | Case Studies - How To
I was recently teaching a class on Vlookups() – what I call one of the “usual suspects” and one of the participants had a question around how to speed up her vlookups – particularly when the headings were the same. If you are not sure how the...
by admin | Feb 7, 2022 | Excel | General
The usual wisdom around pivot tables is that they are generated from a single source of data. That is generally true. However from Excel 2013 onwards you can use the data model feature. The same rules still apply as using a vlookup (or indeed index/match) in that you...
by admin | Jan 31, 2022 | Case Studies - How To
In this video we are going to identify how to use Excel to identify waiting times. Some people have an appointment and others do not – they have a disappointment. I’m sorry but that makes me laugh. EVERY. SINGLE. TIME. Truly sad and pathetic I know…...
by admin | Jan 24, 2022 | Case Studies - How To
Many non-profits use Excel to track their finances. In this blog post I am going to use some sample data to show how you could capture a single payment – that often has to be allocated across multiple projects and/or expenses. You can download the original file...
