On this page:

Overview

Learn how to advance your Excel skills using tools to forecast, optimize and automate repetitive tasks like a pro.

This course is designed for individuals who have working intermediate knowledge of Excel and are looking to elevate their Excel skills and drive efficiency through hands-on, practical applications. This advanced course strongly emphasizes leveraging Excel for modern data analysis. You'll explore essential topics like PivotTables, dynamic array functions, forecasting and optimization techniques that are vital in today's data-driven environment.

You'll gain valuable experience creating visually engaging dashboards and impactful data summaries using PivotTables. In addition, you'll discover how to enhance your PivotTables with calculated fields and the powerful features of Power Pivot. You'll also hone your ability to write sophisticated Excel formulas, enabling you to tap into dynamic array functions and uncover insights through forecasting and simulation modelling. A key highlight includes utilizing Excel Solver to effectively model product mix decisions and address distribution challenges.

This course is led by an experienced instructor and combines interactive lectures with practical exercises and take-home assignments. You’ll also gain access to up-to-date guided course materials through your online learning portal.

By the end of the course, you'll be able to use Excel as a strategic tool for identifying market trends and uncovering lucrative business opportunities. Additionally, you'll learn to optimize operational savings in areas such as inventory management and supply chain processes.

  • are a business professional or analyst seeking to enhance your data analysis skills and streamline decision-making using Excel's advanced features
  • want to improve operational efficiency by optimizing business processes such as inventory management, supply chain operations or resource allocation
  • aspire to create professional dashboards and visualizations that effectively communicate complex data insights to stakeholders.

You must complete DIGI 030 - Excel for Reporting before you can register for this course.

Alternatively, successful completion within the past five years of the Microsoft Office Specialist (MOS) associate-level certification exam for Excel is accepted, specifically:

  • Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps), or
  • Microsoft Office Specialist: Excel Associate (Office 2019)

Advanced-level Excel certifications are also acceptable.

Upon successful completion of this course, you’ll be able to:

  • optimize Excel PivotTable options for users using data summary, PivotCharts and formulas
  • create dynamic dashboards using design, slicer connections and applications
  • write advanced Excel formulas for data analytics using nested functions, lookup functions and 2023 dynamic array functions
  • create data trend predictions using correlation, hypothesis testing and Exponential Triple Smoothing (ETS) forecasting 
  • conduct data simulations and optimization using data tables, Goal Seek and Solver.

Upcoming dates

Select an available section and add it to your cart. When you're ready, proceed to check out to sign into your student account and complete your registration.

Don't have a student account? Let's set one up!

Registration for this course closes seven days prior to the start date.

After you've completed this course

Upon successful completion of this course, you'll be able to self-print a proof of completion document from your Continuing Education student account.

Micro-Credential

Aligned to current industry standards, SAIT’s micro-credentials develop practical, real-world skills and include competency-based testing. Earning a SAIT micro-credential demonstrates to employers you have the required competencies — both skills and knowledge — to get the job done.

Micro-credential Badge

Students who successfully complete this course with a final grade of A- (80%) or higher will earn a micro-credential and receive a shareable digital badge.

Costs

Textbook and reading list

All required course materials are included in your tuition fees.

Technology

To be successful in this course, you'll need:

Aldred building

Financial support

Financial opportunities are available to help pay for your course fees. Learn more about how to reduce your education or training costs with available awards, bursaries, loans and grants including the Canada Alberta Job Grant. 

Learn more

Train your team

Interested in group training opportunities for this course? Tell us about your organization's needs, and one of our training consultants will contact you within one business day.

Contact us

Oki, Âba wathtech, Danit'ada, Tawnshi, Hello.

SAIT is located on the traditional territories of the Niitsitapi (Blackfoot) and the people of Treaty 7 which includes the Siksika, the Piikani, the Kainai, the Tsuut’ina and the Îyârhe Nakoda of Bearspaw, Chiniki and Goodstoney.

We are situated in an area the Blackfoot tribes traditionally called Moh’kinsstis, where the Bow River meets the Elbow River. We now call it the city of Calgary, which is also home to the Métis Nation of Alberta.

Visit Natoysopoyiis Resource Centre