In our journey to become data ninjas, it’s never a solo thing. Many people from all around the world contribute to our learning and growth. We’ve put together 75 awesome resources that we found helpful along our journey to guide you along yours! Includes Resources that help you make sense of the big picture and influence people to come on-board, Blogs, YouTube Channels, Playlists, and Webinars, Books, eBooks, Online Courses, Offline Courses & Workshops, Forums, List of Power Query M and Power Pivot DAX functions, and Other Resource Lists.Read More
We blog on the Why, What, and Hows of Power Query, Power Pivot, and Excel
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