Teaching analytics with modern Excel
If you've ever struggled with a malfunctioning Excel formula or tried to adapt a VBA script from a tutorial to fit your needs, you know how challenging debugging can be. Copilot for Excel is designed …
Continue Reading about Copilot for Excel: How to debug formulas →
Recently, I encountered a task in Excel where I needed to identify the top N values within each group. Generally, I've found that working with groups in Excel can be less than user-friendly for many …
Continue Reading about Python in Excel: How to find the top N values by group →
Lately, I've been sharing numerous posts about Copilot in Excel and its potential to enhance your Excel skills and productivity. In this post, I'd like to introduce a companion product: Microsoft …
Continue Reading about How to use Microsoft Copilot as an Excel tutor →
As an Excel trainer and consultant, I've often encountered skepticism about categorizing skills into beginner, intermediate, and advanced levels. It's understandable—Excel is a vast program, and users …
Modern Data Analytics in Excel is a technical book primarily focused on delivering dense technical information, which may not be everyone's cup of tea. However, if you delve into a lot of technical …
Continue Reading about Here are some memorable quotes from <i>Modern Data Analytics in Excel</i> →
I like to say that good data, much like money, doesn't grow on trees. It takes work to obtain. Often, this work involves retrieving and combining data from multiple sources using techniques like …
Continue Reading about Copilot for Excel: How to work with multiple tables →
