Must-know Excel features for Python in Excel

Python in Excel leverages an impressive set of existing Excel features. This free webinar aims to explore and explain these features.

Recording & downloads

• A recording will be made available after the event.
• All downloads will be shared at the time of the event.

This online training will cover:

• Using Power Query to import data from the web, and then connect Python directly to the connection
• Fetching previews and other attributes of our Python objects with linked data types
• Importing data the dynamic way with tables and structured table references
• Intermingling Python outputs and Excel operations with dynamic arrays and the spill operator
• Creating, resizing and referencing Python plots with Excel's image in cell feature
  

By the end of this session, you'll be better prepared to use Python in Excel for enhanced data analytics and an AI-augmented data landscape.

Who should attend

Really, anyone who wants to make the most of their data using next-generation features. Typical job titles who could particularly benefit include:

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

Prerequisites

• 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 you're looking for similar training and consulting for your organization, please get in touch.