Teaching analytics with modern Excel
One of the first practices I encourage Excel users to pick up is to store all their data in tables. Tables can take some getting used to, especially for those used to the traditional relative and …
Continue Reading about Table time! Reasons to start using Excel tables now →
RELATED() function in Excel Power PivotPower Pivot is a fantastic tool that lets you build relational models right from Excel. This negates the "death by VLOOKUP()" that many large workbooks face -- defining relationships across multiple …
Continue Reading about How to understand the RELATED() function in Excel Power Pivot →
ALL() function in Excel Power PivotIn Excel, filters make it easy to exclude data from PivotTables. You can check off the desired categories, and watch the numbers change throughout: The fancy word for this property is filter …
Continue Reading about How to use the ALL() function in Excel Power Pivot →
xlwings add-in for ExcelA bit of Excel heresy: the LAMBDA() function is great. But rather than write my own, really complex function to perform a task, I'd rather borrow from an established Python function. …
Continue Reading about How to get started with the xlwings add-in for Excel →
These courses are now available for viewing on LinkedIn Learning and can be accessed here. Happy viewing and thanks again to Madecraft for partnering on the production! In January 2023, I traveled …
Continue Reading about What it’s like recording analytics courses at a professional studio →
xlwings add-in for ExcelMany packages exist for working with Python and Excel, but xlwings may be the most powerful all-around due to its many reading and writing features. This versatility, however, comes at the cost of …
Continue Reading about How to install the xlwings add-in for Excel →