Loading...

Course Description

Microsoft Excel is a powerful data analysis, reporting, and decision-making tool in professional environments. This intermediate to advanced-level course is designed for users who are already familiar with Excel basics and want to deepen their skills. Participants will learn to manage complex workbooks, apply advanced formulas and functions, analyze data using pivot tables and charts, and automate tasks using named ranges and conditional formatting.

Workbook examples include dynamic financial models, performance dashboards, advanced data-entry forms, and analytical reports.

Course Details

Upon completion of this course, successful students will be able to:

  • Manage and customize complex workbooks and worksheets
  • Use advanced formulas and functions for data analysis
  • Create and format dynamic tables and pivot tables
  • Visualize data using advanced charting techniques
  • Apply conditional formatting and data validation
  • Import, clean, and manipulate large datasets
  • Prepare workbooks for collaboration and sharing

Topics of Instruction

  • Importing and cleaning data
  • Advanced navigation and workbook management
  • Custom views and workbook protection
  • Formatting techniques for readability and impact
  • Named ranges and structured references
  • Conditional formatting and data validation
  • Creating and customizing pivot tables
  • Advanced charting: combo charts, sparklines, dynamic charts
  • Preparing workbooks for collaboration (comments, protection, sharing)
Loading...

Enrol Now - Select a section to enrol in

Type
Class
Days
T, W
Time
8:30AM to 4:30PM
Dates
Apr 21, 2026 to Apr 22, 2026
Schedule and Location
View Details
Hours
14.0
Campus
Delivery Options
Class  
Course Fees
Flat Fee non-credit $0.00

Section Notes

This corporate course is open to ARC Resources enrollments only.

You must register for a course at least 5 Business Days before the course start date. If you wish to enroll after this cut-off, please get in touch with your learning and development Team at LearningandDevelopment@arcresources.com

The deadline to register for this course is April 14, 2026.

If you are traveling to Calgary to attend a session, it is your responsibility to book your charter flight and accommodation.

For more details and access to the links above, see the ARC Resources Develop@ARC Program Overview.

Required fields are indicated by .