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 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 | Nov 8, 2021 | Excel | General
Often when we get data it’s done in the format as seen below However quite often we need it to be organised differently – for example if I want to set this up to be able to calculate the monthly total for each product in a pivot table – not...
by admin | Jul 31, 2013 | Excel | General
Well, this week I’m going to write specifically about Powerpivot. Powerpivot is the new free add-in you can download free for Excel 2010 and later. However Powerpivot has a diva side – it’s been known to flounce off in a huff and only return when you...
