Menu
Assessment
Do you have the right personality for College?
Start your journey towards a new career today by requesting program details.
Financial Assistance
Career OptionsStart DatesJob OpportunitiesAcademy 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.
Start your journey towards a new career today by requesting program details.
Financial Assistance
Career OptionsStart DatesJob OpportunitiesJump 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:
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:
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.
This quick and easy assessment will provide you with some insight into what to focus on and what you might need to watch out for to best prepare you for your new career and school goals!
B.C. Private Training
Institutions Branch
B.C.
Education
Quality Assurance
Explore the heartfelt testimonials from our satisfied students
Office Clerk
"I came to AOLCC in September 2019 and I am glad I did. I came to here to better my education and enhance my skills. The staff are very friendly and help you whenever you need. I would highly recommend Academy of Learning because it is self-pace – you do it on your own time. Thank you AOL!!"
5.0
Medical & Social Services
"I chose to come attend AOLCC to further my education, to become self-sufficient, self-empowered and to get back into the work force doing what I truly love, to empower others suffering with addictions. I heard about the college from another student who enjoyed the school and her course. It was a good experience and I felt supported, always knowing there were coaches and help when I needed it. I was always supported and encouraged and I really enjoyed my time at AOLCC."
5.0
Medical & Social Services
"If and when I need extra training in any category, I will definitely be coming back to the Academy of Learning Career College. School has never come easy to me, but being here has been an excellent and very rewarding experience for me. Especially the support I received from Helen and Kyle, THEY ARE THE BEST!"
5.0
Administrative Assistant
"I was out of the country for 4 years and when I came back to Canada, I applied for some clerical positions with no luck. I found that most companies wanted certificates. That is when I came to AOLCC and with the help of the facilitators, I made the decision to enrol for the Administrative Assistant Diploma. I feel I learned a lot in every subject that I will take forward into a new career path."
5.0
Technology & Design
"Going to AOLCC has been a very good experience for me. The staff was informative and polite. Courses were taught very well and all my questions were answered. Thanks to the staff for everything."
5.0
For general information, visit our Programs page to see what we offer. The individual program pages will give you more details about their objectives, program length, courses and much more. Our Admissions Representatives are also available to discuss program options with you.
Our Admissions Representatives and campus staff can provide information regarding financing, financial aid and financial assistance for which you may qualify.
Never! Our Integrated Learning System™ (ILS) is designed to ensure that you proceed at your own pace, with qualified facilitators and instructors available for one-on-one assistance and guidance. At AOLCC, you will never be just another anonymous face in the crowd!
Absolutely! We serve adult learners by creating a safe, comfortable and inclusive atmosphere where you can feel at ease while you learn.
Yes! In fact, AOLCC’s scheduling is designed with part-time workers in mind. Our goal is to be flexible so you can achieve the right work/life balance.
Yes! We administer an entrance examination to ensure you can succeed at our campuses, and we provide assistance and guidance to make sure you continue to succeed!
699 Victoria Street
Kamloops, BC V2C 2B3
Phone: (250) 372-5429
Fax: (250) 372-5462
240A - 1640 Leckie Rd.
Kelowna, BC V1X 7C6
Phone: (250) 868-3688
Fax: (250) 868-3511
1551 Estevan Rd #7,
Nanaimo, BC V9S 3Y3
Phone: (250) 753-4220
Fax: (250) 753-4295
#200-754 Goldstream Ave.
Victoria, BC V9B 5T2
Phone: 250-391-6020
Fax: (250) 391-6021
© 2024 AOLCC All Rights Reserved.
Powered by Generation Marketing. 
