Analytics & AI for Modern 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 →
Sampling rows from a table is common for analyzing subsets of large datasets, enabling quicker insights or testing without processing the entire dataset. In Excel, this is difficult because it lacks …
Continue Reading about Python in Excel: How to sample rows →
PivotTables in Excel are a fast, user-friendly way to summarize data and gain quick insights. However, they’re not formula-driven, which can limit control and flexibility compared to dynamic options …
Continue Reading about Python in Excel: How to create PivotTables with Copilot →
One of the most exciting skills to learn in BI tools like Power BI or Tableau is how to create dynamic measures. The idea is that since dashboard space is limited, using dynamic controls—such as …
Continue Reading about How to create dynamic measures in Excel with Python in Excel →
In a previous blog post I showed how to get over limitations of creating dummy datasets directly in Microsoft 365 Copilot by asking for a Python script instead, particularly the faker …
Continue Reading about Python in Excel: How to generate fake data with Faker →
Whether you're a seasoned financial analyst or a data-proficient professional, understanding the calculation of investment returns can help assess the profitability and risks of various assets. This …
Continue Reading about Python in Excel: How to calculate investment returns →
