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 …
Power Automate for Excel: How to build flows with Copilot
Power Automate offers Excel users exciting new ways to build workflows among various applications, including automating report distribution and automatically updating workbooks based on updates from …
Continue Reading about Power Automate for Excel: How to build flows with Copilot →
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 frame a data analytics problem using Copilot for Microsoft 365
The benefits of generative AI for data analysts are often emphasized in relation to hands-on, daily tasks such as debugging formulas or writing macros. Additionally, AI assists in conceptual tasks …
Continue Reading about How to frame a data analytics problem using Copilot for Microsoft 365 →
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 →
How to understand prompting with Copilot for Microsoft 365
When I was a kid watching Star Wars, do you know what fascinated me the most? It wasn’t the laser guns or hyperdrive, but the robots like C-3PO who seemed to know everything and could be conversed …
Continue Reading about How to understand prompting with Copilot for Microsoft 365 →