Analytics & AI for Modern 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 →
Upsampling time series data involves increasing the frequency of your data points by filling in gaps to transform a lower-frequency dataset into a higher-frequency one. This process is often necessary …
Continue Reading about Python in Excel: How to upsample and interpolate time series data →
