Restart a Pivot Table in one go
If you want to clear all the fields from a Pivot Table you can use the clear all option.
On the PivotTable Analyze or Analyze tab click the Clear drop down and select Clear All.
This removes all the fields and allows you to start again from scratch.
The SEQUENCE function returns sequential numbers. Let’s see how we can use it to create a Calendar matrix.
Financial Modelling with Scenarios
A great webinar recording from Danielle Stein Fairhurst from Plum Solutions and Thomas Paul from BDO.
A flexible technique to handle lots of different variables in a model using data tables.
Macro question – Slicer solution
Slicers are a very flexible filtering option and can control multiple pivots – even power pivots!
Always happy to help.
The SEQUENCE function returns sequential numbers. Let’s see how we can use it with a list of dates.
Many things that were hard or complex are now much simpler. Creating dynamic drop down lists based on previous selections used to be tricky in Excel. Dynamic arrays make it straightforward.
The world is becoming like a lunatic asylum run by lunatics.
David Lloyd George (1863 – 1945)
With the introduction of Dynamic Arrays in all versions of Microsoft 365 (formerly Office 365) it is now a lot easier to use the TRANSPOSE function.
1. If it should exist. It doesn’t.
2. If it does exist, it’s out of date.
Arnold’s First and Second Laws of Documentation.