- Why AOLCC
- Contact Us!
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.
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.
Closing, and Saving Files; Entering Data; Using Data Entry Time-Saving Features; Getting Help While You Work
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
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
Understanding Functions; Inserting Functions; Nesting Functions; Using Math & Trig Functions; Using Statistical Functions; Using Date and Time Functions
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
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.
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
Referencing Data; Naming Cells and Cell Ranges; Ensuring Data Integrity; Referencing Data Review; Managing Named Ranges; Using Hyperlinks; Ensuring Data Integrity; Removing Duplicate Rows
Creating Tables; Adjusting Table Size; Modifying Tables; Sorting Data; Filtering Data; Special Sorting and Filtering; Grouping and Outlining
Creating Charts; Adding, Removing, and Repositioning Chart Elements; Modifying Charts; Formatting Charts; Creating Sparklines
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
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.
Using Formulas to Project Values; Using the Analysis ToolPak to Perform Regression; Analyzing Rank and Percentile; Using Goal Seek; Using Solver; Using Scenario Manager
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
Using the Formula Auditing Tools; Correcting Errors in Formulas and Functions; Evaluating a Formula; Tracing Cell References; Automating Tasks with Macros; Editing Macros
Modifying Workbook Properties; Customizing the Quick Access Toolbar; Customizing the Ribbon; Customizing the Excel Environment; Adding Form Controls
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
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
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:
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.
B.C. Private Training Institutions Branch
B.C. Education Quality Assurance