Event Details

Course Title: Excel Advanced

Meeting Date: This course will meet on 11/18 from 9:00AM to 3:30PM.

Course Description: 

This advanced Excel course is designed for professionals who want to master automation, integration, and AI-driven analytics. You’ll build on intermediate skills to apply complex formulas, functions, and array calculations, automate workflows with Macros and VBA, and manipulate large sets of text-based data. The course also explores integrating Excel with other Microsoft Office applications and external data sources. With Microsoft Copilot and Python now available in Excel, you’ll learn how to supercharge your analysis with automation, advanced statistical models, and AI-assisted reporting.

Learning Objectives:

• Apply advanced formulas, functions, and array calculations.
• Automate workflows with Macros and VBA.
• Manipulate and transform text-based data.
• Integrate Excel with other Office applications and external data sources.
• Use AI and Python inside Excel for advanced analytics.

Modules (with AI topics):

• Copilot in Excel with Python (automate analysis, statistical models, and advanced reporting).
• Text Insights in Excel (use formulas, Power Query, and Copilot for summarizing and extracting meaning from text data).
• Advanced lookups, security, and workbook protection with AI-assisted troubleshooting.
• Macro and VBA enhancements (build, then let Copilot suggest improvements or generate boilerplate VBA code).
• Office integration with AI (linking Excel to Word/PowerPoint with Copilot summarization and embedding).

Target Audience:

This course is ideal for:

• Experienced Excel users ready to push beyond PivotTables and standard formulas.

• Analysts, data professionals, and technical managers who need advanced automation and reporting capabilities.

• Professionals who want to integrate Excel into larger workflows across Office or external systems.

• Anyone interested in applying AI and Python inside Excel to streamline advanced data analysis.

Why Attend?

• Master advanced formulas, functions, and array calculations to solve complex problems.

• Learn how to automate repetitive workflows with Macros and VBA—with Copilot to assist and optimize.

• Use AI and Power Query tools to clean, manipulate, and extract meaning from text-based datasets.

• Explore integration with Word, PowerPoint, and external data sources to streamline reporting.

• Gain hands-on experience with Python and Copilot inside Excel to build powerful, AI-assisted analysis and models.