Excel Level 4: Advanced Tools for Data Analysis

Schedule

Fri Nov 27 2026 at 08:30 am to 04:30 pm

UTC-06:00
Location

MicroAge Regina, 10B Hesse Bay, Regina, SK S4R 7Z9, CA | Regina, SK

Advertisement
Organized by: MicroAge Regina — https://www.eventbrite.com/o/83363466853
Master advanced Excel tools including Power Query, Power Pivot, dashboards, lookups, and data modeling for deeper insights.
Take your Excel skills to the next level with advanced data analysis tools used by today's professionals. This hands-on course focuses on transforming, modeling, analyzing, and visualizing data using Excel's most powerful features, including Power Query and Power Pivot.
Learn how to clean and combine data from multiple sources, build interactive dashboards, create data models, and generate meaningful insights that support better business decisions.
Duration: 1 Day (8:30 AM - 4:30 PM CST)
Format: Online or In-Person (Regina)
Cost: $695 + GST
Learning Outcomes
By the end of this course, participants will be able to:
� Analyze data using date, time, and text functions
� Implement data validation and lookup functions
� Create interactive dashboards with PivotCharts, slicers, and timelines
� Import, clean, combine, and transform data using Power Query
� Build and manage data models with Power Pivot
� Create calculations, KPIs, and advanced visualizations
� Perform advanced data analysis and reporting
Course Topics
Date, Time & Text Functions
Working with date and time functions
Using text functions for data analysis
Data Validation & Lookup Functions
Data validation techniques
Forms and controls
Lookup functions
Excel Dashboards
PivotCharts
Slicers and timelines
Dashboard creation
Power Query
Connecting to data sources
Cleaning and combining data
Data transformation techniques
Power Pivot
Managing data relationships
Creating calculations
Building KPIs
Data modeling and analysis
Advanced visualization
Who Should Attend?
This course is ideal for Excel users who regularly work with large datasets, reports, dashboards, or business intelligence tools and want to improve their data analysis capabilities.
Upcoming Session
� November 27
� 8:30 AM – 4:30 PM CST
Available Online or In Person
$695 + GST
Prerequisites
Participants should have intermediate to advanced Excel knowledge. Completion of Excel Level 3 or equivalent experience is recommended.
Cancellation & Refund Policy
If you need to cancel your registration, request a refund, or discuss transfer options, please contact a MicroAge Training Specialist directly.
� [email protected]
Our team will be happy to assist with cancellations, refunds, and registration changes.
Advertisement

Where is it happening?

MicroAge Regina, 10B Hesse Bay, Regina, SK S4R 7Z9, CA, Canada

Event Location & Nearby Stays:

Know what’s Happening Next — before everyone else does.
Eventbrite
Host or PublisherEventbrite

Ask AI if this event suits you