For decades, Excel training meant formulas, charts, and PivotTables. Now, learners open Excel and see a Copilot icon in the ribbon, a Python cell, or an automated workflow running in the background. …
Python in Excel: How to do feature engineering with Copilot
Feature engineering involves transforming raw data into meaningful variables to enhance machine learning models. It includes creating new features, encoding categorical data, and scaling or …
Continue Reading about Python in Excel: How to do feature engineering with Copilot →
How to teach Power BI to Excel users quickly
If you’re responsible for leading Power BI adoption and training at your organization, you know the challenge: users deeply comfortable with Excel may resist adopting new tools, feeling overwhelmed by …
Continue Reading about How to teach Power BI to Excel users quickly →
How to understand the difference between Power Query and Python in Excel
As Excel increasingly integrates powerful tools ranging from Power Query to Python, analysts often wonder: When should I use one over the other? Knowing the strengths and limitations of Python in …
Continue Reading about How to understand the difference between Power Query and Python in Excel →
How Excel users can evaluate and mitigate the risks of generative AI
In my Copilot workshops tailored specifically for Excel users, particularly those in finance and accounting, two recurring concerns stand out: the accuracy of AI-generated outputs and the potential …
Continue Reading about How Excel users can evaluate and mitigate the risks of generative AI →
Here are some Excel features you should know to get the most of Python in Excel
When introducing newcomers to Python in Excel, I typically recommend that they have some basic Python knowledge beforehand. This helps reduce the mental effort required to grasp the Python in Excel …