Advanced Analysis with Python in Copilot for Excel can help with many data analysis tasks that would typically be challenging to execute in Excel. From building predictive models using techniques like …
Python in Excel: How to generate fake data with Faker
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 →
How to generate datasets with Copilot for Microsoft 365
As a trainer and content creator, I regularly generate fake datasets for exercises. This task can be more challenging than it sounds. Creating variables that follow a specific pattern or distribution …
Continue Reading about How to generate datasets with Copilot for Microsoft 365 →
Python in Excel: How to calculate investment returns
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 →
Python in Excel: How to upsample and interpolate time series data
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 →
Python in Excel: How to work with missing values
Data analysts should be proactive about missing values in their data, as these can significantly impact analysis outcomes. First of all, many algorithms such as linear and logistic regression as well …
Continue Reading about Python in Excel: How to work with missing values →