Python in Excel crash course

Now that Python in Excel is heading to general availability, this free one-hour training is designed to help you understand what this exciting integration means and what Python in Excel can do for you. We'll dive into hands-on examples to ensure you can apply what you learn right away.

If you have any questions about the logistics or technical setup for Python in Excel, please consult this Microsoft support page at https://support.microsoft.com/en-us/office/get-started-with-python-in-excel-a33fbcbe-065b-41d3-82cf-23d05397f53d.

Recording & downloads

• A recording will be made available after the event.
• Downloads for this session are available here.

By attending this free online workshop, you will understand:

• When to use native Excel features for data analysis and visualization, and when Python is a better fit.
• How Python can assist in common data preparation and manipulation tasks often done in spreadsheets.
• The differences between how Python and Excel store and operate on data.

And you'll be able to:

• Run Python code directly within your Excel workbook.
• Generate complex data analyses and visualizations with Python that would be difficult or impossible in Excel.
• Import additional Python modules in your Excel workbook for assistance with a variety of data analytics tasks.

Please refer to Microsoft's official post on Python in Excel here for details on product availability and downloads. Due to the limitations of a free online webinar, I'm unable to offer individual support regarding product licensing and availability.

Who this is for

Typical job titles might include:

• Data analysts
• Financial analysts
• Marketing coordinators
• Accountants
• Controllers
• Operations analysts

Prerequisites

• Please have an up-to-date version of Microsoft 365 for desktop installed prior to the workshop.
• If you are new to data analysis in Python, you are welcome to attend although I'd suggest reading a book like Advancing into Analytics later.
• It is recommended to attend this workshop on a Windows machine
• No other preparation is needed.

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