Create relationships between tables.
Write formulas exclusive to Power Pivot that simplifies the formula-writing process for L12M, L12M_Avg, YTD and FTYD figures.
[30 min read]Read More
How to write Excel formula that automatically update:
YTD and FYTD figures when “latest month” parameter changes.
Last year’s YTD and FYTD figures when “latest month” parameter changes.
[7 min read]Read More
How to write Excel formula that:
Automatically updates L12M Total and L12M Average figures when “latest month” parameter changes.
Returns accurate summation of figures in the event of insufficient data to sum up.
[20 min read]Read More
Get dates into a readable format that allows for easy referencing further on in the set-up process.
Set-up a date table that automates the updating of time period parameters.
Sum up figures based on specific criteria (i.e. time period / product category).
Manage situations where an error value is returned.
[9 min read]Read More
Wave a DAX wand and your Excel report is ready - Step in through the magic door and discover new reporting powers in this alternate world. Powers you always wished you had but could only fantasize about.
[4 min read]Read More
THE Power Pivot function you need to know. Easily extract a subset of data to do complex calculations with in a jiffy. Say goodbye to random data trawling and hello to top-notch angling!
[6 min read]Read More
Neuroplasticity meets learning powerful Excel add-ins hidden in plain sight.
Think about how much time you spent organising, cleaning, formatting your data and then re-doing everything again when new instructions come. Surely, there must be a better way to make use of your time? And your brain powers?
[2 min read]Read More
Solutions for Data Crunchers and Businesses.