Microsoft Excel Training OnLine

We Make OnLine Training as Good as In-Person Training
Microsoft Excel is one of the most widely used application in the world. Almost all organizations, businesses, and government ministries have Excel users. You will find Excel intensive tasks in finance, accounting, sales, operations, administration, inventory, shipping, HR, projects, reporting, forecasting, data analysis, managing programs, and contracts. We offer several Excel courses that cover critical tasks from these fields and professions.

Please Click on a Course for More Details

Excel Level-1
Version 2013/2016/2019/365
Online

Microsoft Excel is a spreadsheet application used all over the world in commercial and industrial applications where numbers are involved. This includes analysis, payroll, inventory, finance, accounting, charting, data listing and complex calculations of any kind.

Our Excel Level-1 course is designed for office users or those planning to work in an office. It is a foundation course that prepares you to take an intermediate course. It is recommended for those who are self-taught as it fills the holes and gaps in their learning. Please refer to the detailed course outline below to learn what is covered in the course.

Prerequisites: At least six months of work experience in Windows environment. Good mouse skills.
Platform: Microsoft Windows
Course Duration: One Day
Class Times-1: 9:00 AM to 5:00 PM Pacific Time (Vancouver)
Class Times-2: 9:00 AM to 5:00 PM Eastern Time (Toronto)
Course Dates: Several available. Displayed on the course registration page.
Course Pace and Style: Medium-to-Fast; Hands-on, Intensive, Interactive.
Course Delivery Format: OnLine and In-Person 
(In-Person training is currently not available due to COVID-19 pandemic)
Course Fee: CAD $285 + Tax Per Attendee. Includes Course Material cost.
Course Outline: Excel_Level_1
Cancellation & Date Change Policy: Cancellation Policy
Technical Requirements for Taking OnLine Courses: OnLine Tech Requirements

Excel Level-2
Version 2013/2016/2019/365
Online

Microsoft Excel is a spreadsheet application used all over the world in commercial and industrial applications where numbers are involved. This could include analysis, payroll, inventory, finance, accounting, charting, data listing and complex calculations of any kind.

Our Excel Level-2 course is designed for office users or those planning to work in an office. It is an intermediate course that covers mastering intermediate functions and formulas, charting, Data Listing, filtration and sorting and introduction to PivotTable reporting. Please refer to the detailed course outline below to learn what is covered in the course.

Prerequisites: Working experience with Microsoft Excel or skills learnt in our Excel Level-1 course. At least six months of experience working in Windows environment. Some keyboard skills also required.
Platform: Microsoft Windows
Course Duration: 
One Day
Class Times-1: 9:00 AM to 5:00 PM Pacific Time (Vancouver)
Class Times-2: 9:00 AM to 5:00 PM Eastern Time (Toronto)
Course Dates: Several available. Displayed on the course registration page.
Course Pace and Style: Medium-to-Fast; Hands-on, Intensive, Interactive.
Course Delivery Format: OnLine and In-Person 
(In-Person training is currently not available due to COVID-19 pandemic)
Course Fee: CAD $310 + Tax Per Attendee. Includes Course Material cost.
Course Outline: Excel_Level_2
Cancellation & Date Change Policy: Cancellation Policy
Technical Requirements for Taking OnLine Courses: OnLine Tech Requirement

Excel Level-3
Version 2013/2016/2019/365
Online

Microsoft Excel is a spreadsheet application used all over the world in commercial and industrial applications where numbers are involved. This could include analysis, payroll, inventory, finance, accounting, charting, data listing and complex calculations of any kind.

Our Excel Level-3 course is designed for office users or those planning to work in an office. It is an advanced course that prepares you to work with data validation, macros, formula auditing, conditional formatting and tools related to data analysis. Please refer to the detailed course outline below to learn what is covered in the course.

Prerequisites: Substantial working experience with Microsoft Excel or skills learnt in our Excel Level-1 and 2 courses. At least six months of experience working in Windows environment with mouse. Some keyboard skills also required.
Platform: Microsoft Windows
Course Duration: 
One Day
Class Times-1: 9:00 AM to 5:00 PM Pacific Time (Vancouver)
Class Times-2: 9:00 AM to 5:00 PM Eastern Time (Toronto)
Course Dates: Several available. Displayed on the course registration page.
Course Pace and Style: Medium-to-Fast; Hands-on, Intensive, Interactive.
Course Delivery Format: OnLine and In-Person 
(In-Person training is currently not available due to COVID-19 pandemic)
Course Fee: CAD $310 + Tax Per Attendee. Includes Course Material cost.
Course Outline: Excel_Level_3
Cancellation & Date Change Policy: Cancellation Policy
Technical Requirements for Taking OnLine Courses: OnLine Tech Requirements

Excel Formulas and Functions for HR Professionals
Version 2013/2016/2019/365
Online

This course focuses on learning Excel formulas and functions and their application in various HR scenarios. With the help of several skills covered, you will be able to perform many calculations with ease, speed and a great level of confidence. Let Excel time savers save you manual labour and time. Learn how to use logical functions for automating tasks. Create and manage budgets, metrics and projections with ease. Create business charts and a dashboard to display key HR indicators. After the course, you will be able to use Excel as a system with far-reaching capabilities. For more details, please click the link below to view the course outline in PDF.

Prerequisites: Proficiency in Windows environment with excellent mouse skills. Some hands-on work experience of Microsoft Excel with simple formulas and functions is highly desirable.
Software Version: Microsoft Excel 2013/2016/2019/365
Platform:
Microsoft Windows
Course Duration: One Day
Class Times-1: 9:00 AM to 5:00 PM Pacific Time (Vancouver)
Class Times-2: 9:00 AM to 5:00 PM Eastern Time (Toronto)
Course Dates: Several available. Displayed on the course registration page.
Course Pace and Style: Medium-to-Fast; Hands-on, Intensive, Interactive.
Course Delivery Format: OnLine and In-Person 
(In-Person training is currently not available due to COVID-19 pandemic)
Course Fee: CAD $385 + Tax Per Attendee. Includes Course Material cost.
Course Outline: Excel Formulas and Functions for HR
Cancellation & Date Change Policy: Cancellation Policy
Technical Requirements for Taking OnLine Courses: OnLine Tech Requirements

 

Course Pre-approved for 6.5 CPD hours by CPHR-BC &Yukon, CPHR-Alberta and CPHR-Manitoba.

Excel Data Analysis for HR Professionals
Version 2013/2016/2019/365
Online

HR data is either entered manually or downloaded in Excel from HRIS. Gleaning action-ready information from a large dataset could be overwhelming for many users. For an evidence based approach, the voluminous data must be analyzed and summarized to display key indicators or metrics in a meaningful way. Learn to query an Excel data list with complex criteria. This course focuses on many Excel tools, including PivotTables, to analyze HR Data and create complex, well formatted reports in an effortless manner. You will be able to perform many analytical tasks with ease, speed and a great level of confidence. For more details, please click the link below to view the course outline in PDF.

Prerequisites: Successful completion of our Formulas and Functions for HR course OR must have some experience of working with Excel formulas and functions. Proficiency in Windows environment with excellent mouse skills.
Software Version: Microsoft Excel 2013/2016/2019/365
Course Duration: One Day
Class Times-1: 9:00 AM to 5:00 PM Pacific Time (Vancouver)
Class Times-2: 9:00 AM to 5:00 PM Eastern Time (Toronto)
Course Dates: Several availableDisplayed on the course registration page.
Course Pace and Style: Medium-to-Fast; Hands-on, Intensive, Interactive
Course Delivery Format: OnLine and In-Person
(In-Person training is currently not available due to COVID-19 pandemic)
Course Fee: CAD $385 + Tax Per Attendee. Includes Course Material cost.
Course Outline: Excel Data Analysis for HR
Cancellation & Date Change Policy: Cancellation Policy
Technical Requirements for Taking OnLine Courses: OnLine Tech Requirements

Course Pre-approved for 6.5 CPD hours by CPHR-BC & Yukon, CPHR-Alberta and CPHR-Manitoba.

Excel PivotTable Reports
Version 2013/2016/2019/365
Online

The PivotTable tool in Excel is widely used for creating complex reports from a large Excel dataset. It is easy to use but has several hidden functionalities. It is capable of producing a variety of summaries useful for business decision-making. This course will teach you several powerful features of PivotTable via hands-on exercises.

Prerequisites: Skills learned in our Excel Level-1 & Level-2 courses or equivalent everyday work experience of using MS Excel. Proficiency in Windows environment with excellent mouse skills. Some keyboard skills also required.
Platform: Microsoft Windows
Course Duration: Half Day
Class Times-1: 9:00 AM to 2:00 PM Pacific Time (Vancouver)
Class Times-2: 9:00 AM to 2:00 PM Eastern Time (Toronto)
Course Dates: Several available. Displayed on the course registration page.
Course Pace and Style: Medium-to-Fast; Hands-on, Intensive, Interactive.
Course Delivery Format: OnLine and In-Person 
(In-Person training is currently not available due to COVID-19 pandemic)
Course Fee: CAD $285 + Tax Per Attendee. Includes Course Material cost.
Course Outline: Excel PivotTable Reports
Cancellation & Date Change Policy: Cancellation Policy
Technical Requirements for Taking OnLine Courses: OnLine Tech Requirements

Excel Lookup Functions
Version 2013/2016/2019/365
Online

Lookup Functions in Excel such as VLOOKUP, INDEX and MATCH are very powerful. They save you enormous time and labour and provide a great deal of accuracy and automation. Many office workers find these functions a bit tricky to use however. This course is designed for persons who would like to get a good grip on LOOKUP functions. A variety of examples and hands-on exercises will help you master these functions easily.

Prerequisites: Skills learned in our Excel Level-1 & Level-2 courses or equivalent everyday work experience of using MS Excel. Proficiency in Windows environment with excellent mouse skills. Some keyboard skills also required.
Platform: Microsoft Windows
Course Duration: Half Day
Class Times-1: 9:00 AM to 1:00 PM Pacific Time (Vancouver)
Class Times-2: 9:00 AM to 1:00 PM Eastern Time (Toronto)
Course Dates: Several available. Displayed on the course registration page.
Course Pace and Style: Medium-to-Fast; Hands-on, Intensive, Interactive.
Course Delivery Format: OnLine and In-Person 
(In-Person training is currently not available due to COVID-19 pandemic)
Course Fee: CAD $285 + Tax Per Attendee. Includes Course Material cost.
Course Outline: Excel Lookup Functions
Cancellation & Date Change Policy: Cancellation Policy
Technical Requirements for Taking OnLine Courses: OnLine Tech Requirements

Excel Data Management
Version 2013/2016/2019/365
Online

This course is designed for office users who work with or are likely to work with extensive data stored in Excel. The course will give you the tools to maintain a list database and massage and manipulate the data to obtain desirable results. Get a good handle on advanced sorting and filtering of data by taking this course. You should have a good working understanding of Excel. Those who are totally new to Excel should take our Excel Level-1 or Level-2 course first.

Prerequisites: Skills learned in our Excel Level-1 or Level-2 course or equivalent everyday work experience of using MS Excel. Proficiency in Windows environment with excellent mouse skills. Some keyboard skills also required.
Platform: Microsoft Windows
Course Duration: Half Day
Class Times-1: 9:00 AM to 1:00 PM Pacific Time (Vancouver)
Class Times-2: 9:00 AM to 1:00 PM Eastern Time (Toronto)
Course Dates: Several available. Displayed on the course registration page.
Course Pace and Style: Medium-to-Fast; Hands-on, Intensive, Interactive.
Course Delivery Format: OnLine and In-Person 
(In-Person training is currently not available due to COVID-19 pandemic)
Course Fee: CAD $285 + Tax Per Attendee. Includes Course Material cost.
Course Outline: Excel Data Management
Cancellation & Date Change Policy: Cancellation Policy
Technical Requirements for Taking OnLine Courses: OnLine Tech Requirements

Excel Advanced Functions and Formulas
Version 2013/2016/2019/365
Online

This course is designed for office users who would like to focus on advanced Excel functions and formulas for intricate calculations or setup. If you have a good working experience of Excel but wish to set up a more complex worksheet, this course is for you. Those who are totally new to Excel should take our Excel Level-1 & Level-2 courses first.

Prerequisites: Skills learned in our Excel Level-1 & Level-2 courses or equivalent everyday work experience of using MS Excel. Proficiency in Windows environment with excellent mouse skills. Some keyboard skills also required.
Platform: Microsoft Windows
Course Duration: Half Day
Class Times-1: 9:00 AM to 1:00 PM Pacific Time (Vancouver)
Class Times-2: 9:00 AM to 1:00 PM Eastern Time (Toronto)
Course Dates: Several available. Displayed on the course registration page.
Course Pace and Style: Medium-to-Fast; Hands-on, Intensive, Interactive.
Course Delivery Format: OnLine and In-Person 
(In-Person training is currently not available due to COVID-19 pandemic)
Course Fee: CAD $285 + Tax Per Attendee. Includes Course Material cost.
Course Outline: Advanced Functions and Formulas
Cancellation & Date Change Policy: Cancellation Policy
Technical Requirements for Taking OnLine Courses: OnLine Tech Requirements

Our Upcoming Popular Microsoft Excel Courses-OnLine

CourseStart DateLocationPrice-CAD
Microsoft Excel Level-1 (Introductory)20-Oct-2021OnLine285.00
Microsoft Excel Level-2 (Intermediate)22-Oct-2021OnLine310.00
Excel Formulas and Functions for HR25-Oct-2021OnLine385.00
Excel Data Analysis for HR27-Oct-2021OnLine385.00
Microsoft Excel Level-1 (Introductory)01-Nov-2021OnLine285.00
Microsoft Excel Level-2 (Intermediate)03-Nov-2021OnLine310.00
Microsoft Excel Level-3 (Advanced)05-Nov-2021OnLine310.00
Excel Lookup Functions08-Nov-2021OnLine285.00
Excel Formulas and Functions for HR09-Nov-2021OnLine385.00
Excel PivotTable Reports10-Nov-2021OnLine285.00

MICROSOFT OFFICE SPECIALIST CERTIFICATION

Our Microsoft Excel online training will help you considerably if you wish to take Microsoft Exams to earn Excel Associate and Excel Expert certifications directly from Microsoft. These certifications are recognized all over the world and have proven to improve career prospects and pay. Microsoft keeps the list of exams up to date by adding new Exams and retiring old ones. Please follow the link(s) below to their site for more information.

Microsoft Office Specialist: All Exams 

Microsoft Office Specialist: Excel Associate Exam

Microsoft Office Specialist: Excel Expert Exam