Excel remains the undisputed leader among business tools for data analysis, utilized by organizations around the world to inform decision-making processes. Its widespread adoption and versatile …
Copilot for Excel: How to work with Excel tables
Copilot in Excel offers a wealth of opportunities, particularly for new users, to streamline and automate their work. However, there's a somewhat paradoxical requirement that this work must be …
Continue Reading about Copilot for Excel: How to work with Excel tables →
How to understand the rise and fall of Excel add-ins
Like many Excel trainers, I try not to emphasize Excel add-ins too much in my content. The versioning of Excel is already complicated enough, and adding add-ins can fuel the fire. However, I …
Continue Reading about How to understand the rise and fall of Excel add-ins →
Copilot for Excel: How to debug formulas
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 →
Python in Excel: How to find the top N values by group
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 →
How to use Microsoft Copilot as an Excel tutor
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 →