Analyzing data with Python, Copilot and Excel

Recording & downloads

• A recording will be made available after the event.
• All files used in the session will be shared at the time of the event.

In this webinar, we'll explore how to combine Python, Excel, and Copilot to tackle exploratory data analysi:

• Create and visualize frequencies of variables
• Profile data for missing values and outliers
• Create and modify our descriptive statistics
• Visualize relationships, distributions, and trends in the data with a variety of plots, some not available in basic Excel
• Lower the learning curve by using Copilot to generate Python code for us
• Learn some tips and tricks to get the most out of Copilot for Python in Excel

Prerequisites

• Learn about Copilot in Excel availability and how to get it by visiting this page.
• Learn about Python in Excel availability and how to get it by visiting this page.
• To make the most of this workshop you should be familiar with Python concepts such as installing and importing packages, how functions work, and how to work with Pandas DataFrames. You can learn more about these topics by reading my book Advancing into Analytics: From Excel to Python and R.
• No other preparation is needed. The workshop materials will be shared with you at the time of the event.

About your instructor

George Mount is the founder of Stringfest Analytics. He has over 10 years of experience in data analytics and holds master’s degrees in both finance and information systems from Case Western Reserve University. George is the author of Advancing into Analytics: From Excel to Python and R (O’Reilly, 2021) and Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics (O'Reilly, 2024). He is a recipient of the Most Valuable Professional (MVP) award from Microsoft for technical excellence & community advocacy.

I look forward to seeing you at the event!

If your team is looking for custom training in Modern Excel, check out my corporate workshops.