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
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.