Modern Excel Magic in a Week

What you'll get:

• Five sixty-minute live sessions of live Excel training with Microsoft MVP
• Free ebook copy of Modern Data Analytics in Excel: Using Power Query, Power Pivot and More for Enhanced Data Analytics
• Demo notes and handouts
• Workshop recordings
• Certificate of attendance

Description:

If you haven’t modernized your data cleaning & reporting processes in Microsoft Excel, you’re missing out on big productivity gains. And if you’re looking to conduct rigorous data analysis, more can be done in Excel than you think. This five-part webinar series serves as an introduction to the “Modern Excel” suite of features, along with other powerful tools for analytics.

First, you’ll learn how to build repeatable data cleaning workflows with Power Query. Next, you’ll build relational data models and dashboards straight from Excel with Power Pivot. Finally, you’ll look at new Excel features like dynamic array functions, artificial intelligence-powered insights, and Python integration to accomplish even more with your data.

By the end of this course, you’ll be able to build reports and analyses that were previously difficult or impossible to do in Excel.

Schedule:

Each workshop is held at 12 PM Eastern daily, starting April 28, 2025, through May 2, 2025. All sessions are 60 minutes long.

Session 1: Power Query – Excel’s Ultimate Data Cleaning Tool

Date: Monday, April 28, 2025, 12 PM Eastern

Learning Objectives:

• Understand the purpose and benefits of Power Query for data cleaning and transformation.
• Learn to access and navigate the Power Query Editor in Excel.
• Apply basic transformations (e.g., remove duplicates, split columns) to clean data efficiently.
• Recognize how Power Query automates repetitive tasks to save time and reduce errors.

Session 2: Power Pivot – Powerful Data Models Simplified

Date: Tuesday, April 29, 2025, 12 PM Eastern
Learning Objectives:

• Grasp how Power Pivot enhances Excel’s data analysis capabilities beyond traditional tables.
• Enable and set up Power Pivot in Excel.
• Create relationships between multiple datasets and build a simple PivotTable.
• Appreciate Power Pivot’s role in managing large datasets and creating dynamic reports.

Session 3: Dynamic Arrays – Excel Formulas Reinvented

Date: Wednesday, April 30 2025, 12 PM Eastern
Learning Objectives:

• Understand how dynamic arrays simplify Excel formulas with automatic spill behavior.
• Use key dynamic array functions (e.g., UNIQUE, SORT, FILTER) on sample data.
• Reduce manual formula maintenance and errors in spreadsheets.
• Explore how dynamic arrays integrate with other Excel features.

Session 4: Python in Excel – Programming Meets Spreadsheets

Date: Thursday, May 1 2025, 12 PM Eastern
Learning Objectives:

• Learn the basics of Python in Excel and its advantages for advanced analytics.
• Set up and run a simple Python script using the =PY() function.
• Perform a data transformation or visualization with Python libraries in Excel.
• Understand how Python extends Excel’s capabilities beyond traditional tools.

Session 5: Copilot in Excel – Your AI-Powered Assistant

Date: Friday, May 2, 2025, 12 PM Eastern
Learning Objectives:

• Understand Copilot’s role as an AI assistant for data analysis and task automation.
• Set up Copilot in Excel and prepare data for effective use.
• Use natural language prompts to generate insights or visualizations.
• Reflect on the series and plan next steps for continued Excel mastery.

What makes this workshop different

I know there are lots of places to learn Excel these days. What distinguishes this workshop is that it’s:

• Participative. The quicker you apply what you learn, the more likely you are to retain it. This is literally a hands-on workshop where attendees will have plenty of time on the keyboard to try the concepts out for themselves with demos, activities and more.
• Authoritative. The workshop is designed and led by me, George Mount. I run my own analytics consultancy and am both an author with O’Reilly Media and Microsoft MVP.
• Topical. No fake, boring data sources and examples here. Upon request, I will design the workshop to use data from your own organization or industry. In any case, I’ll use a variety of real world and fun datasets.

Here's what people have to say about our webinars...

• “George has a solid core of knowledge on everything Excel and does excellent webinar training sessions.” – Scot H, Analytics Principal
• “George is a tremendous teacher, Makes the Topics very easy to understand & relatable.” – Jorge C, Senior Operations Analyst
• “Very informative and very to-the-point! Thank you!” – Marcello D., Project Analyst
• “I highly recommend these tutorials. Nicely paced and easy to follow. Great for all experience levels.” – Miranda G., Senior Purchasing Analyst
• “George is super easy to understand: he clearly walks through everything he's showing, and explains with enough detail to replicate but without being overwhelming.” – Steph R., Data Analyst

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

Ideally, attendees will have some familiarity with intermediate Excel topics such as PivotTables or lookup functions such as VLOOKUP() or XLOOKUP(). That said, I’ve had success with learners possessing skills as early as basic formulas and functions.

There is no coding experience required to attend this workshop.

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 widely recognized an expert in the fields of data analysis and Microsoft Excel and is the author of Advancing into Analytics: From Excel to Python and R (O’Reilly Media, 2021) and Modern Data Analytics in Excel: Using Power Query, Power Pivot and More for Enhanced Data Analytics (O’Reilly Media, 2024).. He is also a recipient of Microsoft’s Most Valuable Professional (MVP) award for technical excellence and community contributions in Excel.

George has extensive experience in reporting, analytics, and modeling and is a respected trainer in these fields. He provides training for companies throughout North America and beyond.

Software Required

For best results, please have the desktop version of Excel for Windows 365 installed. Earlier versions of Excel or versions for Mac may not track well with everything in the course. You should also have Python in Excel enabled as well as a Copilot subscription.

After you register:

• Information on all other resources will be provided during the event.
• An ebook copy of the book will be sent to the email used to register upon completion of the class.