Modern Excel Magic with Python and Copilot

What you'll get:

• 2 x 2.5-hour live sessions of advanced Excel training with Microsoft MVP
• Free copies of Python in Excel Crash Course and Python in Excel: Quick Wins supplemental video training
• Demo notes and handouts
• Workshop recordings
• Certificate of attendance

Description:

Excel has long been the cornerstone tool for professionals working with data, but the future of Excel is here, and it's powered by Python and AI-driven Copilot.

If you're still relying solely on traditional Excel methods, you're missing out on game-changing opportunities to modernize your workflows and supercharge your analytical capabilities.

In this two-part, hands-on interactive workshop, you'll dive deep into the transformative world of Python in Excel and learn how to fully harness the intelligent assistance of Copilot with Python in Excel.

Day 1: Python in Excel Essentials

Date: Mon 6/23, 10am-12:30pm Eastern

Learning objectives:

• Get thoroughly acquainted with Python integration in Excel, confidently navigating this powerful new environment.
• Understand and apply fundamental Python syntax specifically designed to complement Excel user needs.
• Quickly and efficiently import, clean, and manipulate data directly within Excel using Python, eliminating manual and repetitive tasks.
• Experience immediate productivity boosts through practical, hands-on "quick win" examples and live demonstrations.
• Build and customize an interactive moving average chart, enhancing your data visualization capabilities for dynamic insights.

Day 2: Excel AI Magic with Copilot

Date: Tues 6/24, 10am-12:30pm Eastern

Learning objectives:

• Discover how Microsoft Copilot revolutionizes Python scripting in Excel, dramatically accelerating your analytics workflow.
• Master the art of crafting effective prompts to effortlessly generate Python code for advanced analyses, including time series forecasting and text analytics.
• Design and build compelling, interactive dashboards that seamlessly combine the best of Excel and Python, all powered by intelligent Copilot assistance.
• Gain the skills and confidence needed to integrate AI-driven guidance into your everyday Excel tasks, setting yourself apart as a forward-thinking professional.

By the end of this engaging and practical workshop series, you'll possess the hands-on expertise and confidence to leverage the combined power of Python and AI-driven Copilot, transforming your Excel capabilities and significantly enhancing your analytical productivity.

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 an author with O’Reilly Media, Microsoft MVP, and LinkedIn Learning Instructor who has taught Excel to tens of thousands of learners.
• 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 courses...

• “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.
• Supplemental video training will be sent to the email used to register upon completion of the class.