Teaching analytics with modern Excel
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 →
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 →
If your voluminous VLOOKUP()s and rickety reports are making you think it's time to retire Excel for good and pick up an expensive analytics tool, not so fast. Power Pivot can help you build quick, …
Continue Reading about How to install Power Pivot and DAX for Excel →
.tsv file in Excel Power QueryThis post will show you how to load .tsv (tab-separated values) files into Excel Power Query. To get started, place the below download file into your Downloads folder. Data source: …
Continue Reading about How to read from a .tsv file in Excel Power Query →