Let's Get Started
  • This field is for validation purposes and should be left unchanged.

Request info

Microsoft Excel from Beginner to Advanced to Expert Certificate

Continuing Education Excel Classes – The Best Excel Training Courses

Academy of Learning offers three Microsoft Excel training levels for every one from pure beginners, to those needing an Excel refresher, to those who need to upgrade their skills to an expert level. Each course includes everything you need for success.

  • Online access through the ILS (Integrated Learning System) to all materials including text, audio files, videos, and interactive Excel training
  • Comprehensive textbooks that include all course material. Plenty of images and screen shots along with room for your own notes
  • One-on-one support from our Learning Coaches who are there to help you over whatever hurdles you may encounter

Jump to Level 1 for Beginners, Level 2 for Intermediate Excel training, and Level 3 for the Advanced MS Excel course.

Each level of our MS Excel course is available at the following campuses:

Microsoft Excel Course Level 1 Basics to Beginner Excel Course

Excel Level 1 – MS Excel Training for Beginners

In this course, you will learn to create and manage worksheets and workbook files; enter data and create basic formulas to perform calculations. Learn to edit and manipulate cell content, modify worksheet structure, view and format worksheets, and use Microsoft Excel’s predefined functions. You will use the Find and Replace feature, use themes to format workbooks and practice preparing, previewing, and printing worksheets. View PDF of Excel Level 1 – Microsoft Excel Training for Beginners.

Module 1: MS Excel Files

Closing, and Saving Files; Entering Data; Using Data Entry Time-Saving Features; Getting Help While You Work

Module 2: Finding Your Way Around Microsoft Excel

Viewing a Worksheet; Splitting a Window; Hiding Rows, Columns, and Worksheets; Viewing Multiple Worksheets and Saving a Workspace or Custom View; Navigating and Selecting in Worksheets and Workbooks; Using Find, Go To, and Go To Special to Navigate to Specific Information in a Worksheet and Workbook; Working with Multiple Workbooks; Organizing Worksheets in a Workbook; Managing Workbook Files

Module 3: Excel Beginner Calculations, Formulas & Spreadsheet Layout

Using AutoCalculate; Creating a Basic Formula; Using Cell References in a Formula; Techniques for Entering Cell References; Troubleshooting a Formula; Editing Cell Content; Moving and Copying Cell Content; Inserting, Deleting, Merging, and Splitting Cells; Inserting and Modifying Rows and Columns

Module 4: Microsoft Excel Functions

Understanding Functions; Inserting Functions; Nesting Functions; Using Math & Trig Functions; Using Statistical Functions; Using Date and Time Functions

Module 5: Formatting Your MS Excel Spreadsheet

Formatting Cells with Styles and Color; Applying Borders; Changing Cell Alignment; Formatting Text; Converting Text to Columns; Formatting Values; Applying Themes; Changing Sheet Tab Colors; Changing Sheet Background

Module 6: Find, Print, SpellCheck and More

Using Find and Replace; Using Spell Checker; Setting the Print Area; Adjusting Page Setup Options; Using Print Preview; Using Page Break Preview; Using the Print Section in Backstage View; Displaying and Printing Formulas

Microsoft Excel Course Level 2 Intermediate Excel Course

Excel Level 2 – Microsoft Excel Intermediate Training (Intermediate to Advanced Excel Skills)

In this course, you will learn to customize Microsoft Excel and streamline workflow. Learn to use named references, use links and hyperlinks and use data validation to ensure data integrity. You will master themes, conditional formatting, styles, and templates. Also learn how to create and organize data in a table and how to sort, filter, group, and outline data. Apply conditional logic to a formula, use functions to look up data, modify or format text, and perform financial calculations. Lastly you will practice working with charts, graphics, and diagrams. View PDF of Excel Level 2 – Intermediate to Advanced Microsoft Excel Course.

Module 1: Customize MS Excel Themes and Formatting

Creating Custom Themes; Working with Cell Styles; Using Conditional Formatting; Creating Custom Conditional Formatting Rules; Working with Conditional Formatting Rules; Creating a Custom Number Format

Module 2: Manipulating Data in Microsoft Excel

Referencing Data; Naming Cells and Cell Ranges; Ensuring Data Integrity; Referencing Data Review; Managing Named Ranges; Using Hyperlinks; Ensuring Data Integrity; Removing Duplicate Rows

Module 3: Excel Tables and Sorting Data

Creating Tables; Adjusting Table Size; Modifying Tables; Sorting Data; Filtering Data; Special Sorting and Filtering; Grouping and Outlining

Module 4: Charts for MS Excel

Creating Charts; Adding, Removing, and Repositioning Chart Elements; Modifying Charts; Formatting Charts; Creating Sparklines

Module 5: Specialty Functions

Using Conditional Logic in Formulas; Using Functions to Look Up Data; Using Functions to Modify or Format Text; Using Financial Functions for Loan and Investment Calculations; Using Financial Functions to Calculate Depreciation; Using Arrays

Module 6: Objects and SmartArt in Microsoft Excel

Inserting SmartArt; Modifying and Formatting SmartArt; Inserting Graphic objects; Modifying and Formatting Graphic objects

Microsoft Excel Course Level 3 Advanced Excel Course to Expert Excel Course

Excel Level 3 – Microsoft Excel Advanced to Expert Training

In this Excel course you will examine some of Microsoft’s tools for data analysis and projection. Learn to create, modify, and format PivotTables and PivotCharts, examine various aspects of worksheet auditing, and customization of workbooks. You will also learn about the various features of Excel that facilitate collaboration with others, and explore some common ways that Excel data can be used with other programs and on the Web. View PDF of Excel Level 3 – Advanced to Expert Microsoft Excel Course.

Module 1: Projection and Analysis in Excel

Using Formulas to Project Values; Using the Analysis ToolPak to Perform Regression; Analyzing Rank and Percentile; Using Goal Seek; Using Solver; Using Scenario Manager

Module 2: PivotTables and PivotCharts

Understanding PivotTable and PivotChart Reports; Creating PivotTable Reports; Sorting, Filtering, and Grouping Fields and Items; Using Slicers; Adding Totals and Formulas, and Changing the Layout; Formatting a PivotTable Report; Creating a PivotChart Report

Module 3: Macros and Modifying Formulas in Excel

Using the Formula Auditing Tools; Correcting Errors in Formulas and Functions; Evaluating a Formula; Tracing Cell References; Automating Tasks with Macros; Editing Macros

Module 4: Advanced Excel Customization

Modifying Workbook Properties; Customizing the Quick Access Toolbar; Customizing the Ribbon; Customizing the Excel Environment; Adding Form Controls

Module 5: Protecting and Sharing Excel Spreadsheets

Protecting a Workbook; Setting Password Protection; Using Digital Signatures; Inserting a Visible
Signature Line; Preparing a Workbook for Sharing; Creating a Shared Workbook; Sending a Workbook for Review; Tracking Changes and Resolving Conflicts; Working with Comments; Merging and Consolidating

Module 6: Beyond MS Excel – Importing and Exporting

Using Excel Data and Charts in Word Documents; Using Excel Data and Charts in PowerPoint Presentations; Importing Access Data into Excel; Importing Data and Managing Connections; Using Excel Data on the Web

AOLCC’s Integrated Learning System™

All courses in our programs are delivered through our unique Integrated Learning System™ (ILS). Through ILS, you will develop a true proficiency in each topic, no matter your age or skill level upon enrolment. Our learning coaches are with you every step of the way to provide individualized assistance and encouragement in a supportive and non-competitive learning environment. Here’s how it works:

  • You only advance to the next course when you are confident that you have mastered one topic and are ready to move on to the next
  • You participate in hands-on exercises, tasks and practice exams that test your knowledge and give you confidence
Learn More

Each level of Microsoft Excel includes online/digital resources, interactive practice, remote access for safety, one-on-one Learning Coach assistance, and comprehensive textbooks. These courses are recognized across the province and country. They are also eligible for third party funding including Worksafe, insurance, employer, WorkBC organizations and many more.

Students accomplish the learning objectives for each module through a series of hands-on tasks, for which they are given step-by-step instructions and desired result checkpoints. The tasks provide ample opportunity for students to practice, apply, and develop the skills covered in the course.

A practice exercise and review questions are included at the end of each module to measure progress and reinforce the skills learned. There is also a lab exercise at the end of the course to provide further practice and review to reinforce the topics learned throughout the course, and to help prepare students for the exam.

Duration

Each level 1 - 3 Weeks
Let's Get Started
  • This field is for validation purposes and should be left unchanged.

Kamloops

Kelowna

Victoria

Nanaimo

Accreditations

B.C. Private Training Institutions Branch Logo

B.C. Private Training Institutions Branch

B.C. Education Quality Assurance Logo

B.C. Education Quality Assurance

Receive More Information, With No Obligation!

CONTACT US TODAY