Analytics & AI for Modern Excel
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 →
As a professional analytics author, trainer and consultant it's only natural that I'd get frequent questions on starting or switching to a career path in analytics. Due to time constraints, I …
Continue Reading about My general advice on getting an analytics job →
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 →