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.
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:
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
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
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
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.