Teaching analytics with modern Excel
PERCENTOF() functionOne of the more recent additions to Excel which I haven't seen receive much coverage is the PERCENTOF() function. This function calculates the percentage that a subset represents of a given dataset. …
Continue Reading about How to calculate proportions in Excel with the PERCENTOF() function →
After a pandemic-induced hiatus and move to fully virtual, the Global Excel Summit is BACK in hybrid format this February 2024, live from London, UK. I'm super excited to participate in person at …
Continue Reading about Live from London! Global Excel Summit 2024 →
I'm excited to share that "pandas Analytics for Excel users," a course I produced with Madecraft, is now available on LinkedIn Learning. Also be sure to check your local library, …
Continue Reading about Pandas analytics for Excel users (LinkedIn Learning & Madecraft) →
Your organization needs a data-informed workforce, but how do you build one? Hire highly-credentialled data scientists, and they may balk at the spreadsheet-based data pipelines currently in place. …
Continue Reading about Building the data academy: Free getting started worksheet →
Between Power Query and Power Pivot alone, "modern" Excel boasts so many features that it's impossible to learn them all. Add to that Office Scripts, Power BI, LAMBDA() and more and it's easy to get …
Continue Reading about What is the role of Python in modern Excel? →
This post is sponsored by TIBCO. Thank you for supporting the organizations I trust. In the previous post of this series, we questioned whether approaches to analytics have changed to account for …
Continue Reading about This is your dashboard on converged analytics →
