Event Details

Course Title: Excel Intermediate

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

Course Description: 

Take your Excel skills to the next level with this intermediate-level course designed to help you analyze, visualize, and manage data more effectively. Building on your foundational knowledge, you’ll learn to create charts, apply advanced formulas, and manage large datasets with ease. You’ll also explore powerful tools like PivotTables and PivotCharts to summarize and uncover insights. Along the way, you’ll see how Microsoft Copilot can accelerate analysis, automate tasks, and help you better understand complex formulas, so you can focus on decision-making instead of manual work.

Learning Objectives:

• Create and format charts to visualize data.
• Apply formulas and functions for deeper analysis.
• Sort, filter, and manage lists to uncover insights.
• Use PivotTables and PivotCharts for advanced summaries.
• Incorporate AI for data analysis and automation.

Modules (with AI topics):

• Search and import data (manual methods + Copilot data retrieval suggestions)
• Identify insights (trend spotting using formulas, PivotTables, AND Copilot-generated analysis)
• Highlight, sort, and filter your data (manual + AI-driven filtering recommendations)
• Generate formulas (write your own + leverage Copilot to auto-generate complex formulas)
• Understand formulas (troubleshoot manually + explain formulas with Copilot)
• Create PivotTables (traditional method + Copilot for quick summaries and recommendations)

Target Audience:

This course is ideal for:

• Professionals who already know the basics of Excel and want to expand their data analysis skills.

• Supervisors, managers, and analysts who need to work with large datasets to make informed decisions.

• Team leads responsible for creating reports, charts, and dashboards for their teams.

• Anyone interested in using AI tools like Microsoft Copilot to enhance productivity and streamline analysis.

Why Attend?

• Learn how to create polished charts and visuals that bring your data to life.

• Unlock the power of PivotTables and PivotCharts to summarize and analyze information quickly.

• Gain confidence applying formulas and functions for deeper insights.

• Discover AI-driven techniques for retrieving data, generating formulas, and spotting trends faster.

• Leave with practical tools and methods to save time, improve accuracy, and present data clearly to your team.