Microsoft Excel Training

Courses in Toronto, Mississauga, St. Catharines, and Ottawa

Excel training for your team!
Excel 2016 Level 1
1 day, $275 / participant
More Info
Excel 2016 Level 2
1 day, $275 / participant
More Info
Excel 2016 Level 3 – Data Management
1 day, $275 / participant
More Info
Excel 2016 Level 3 – Spreadsheet Analysis
1 day, $275 / participant
More Info

Training is available for Excel 2010, 2013, and 2016. Discounted pricing offered for groups of 6 or more. Minimum enrollment required. Courses are delivered onsite in Toronto, MississaugaSt. Catharines, and Ottawa.

Request a Quote!

Onsite Excel Training

No travel expenses, no hassle. Just quality Excel training delivered in your company’s meeting room.

Live Instructors

Courses delivered by experienced trainers. Ask questions and get answers. Excel training that’s way better than eLearning!

Focused and Relevant

Courses with an emphasis on the skills you need. “Hands on” exercises with plenty of time to review.

Excel Training for Your Team!

Microsoft Excel has become the de facto spreadsheet application for business. This versatile software package can help you manage virtually any type of data. Track orders, work with budgets, or analyze a database – Excel is the powerful and flexible solution your job requires.

Excel is a registered trademark of Microsoft Corporation. Visit the Office website for more information.

We offer 4 Excel courses:

Excel 2013 Level 1

1 Day Course. $275 / participant plus HST.

Back to Course List Request a Quote!

Minimum enrollment required. Discounted pricing available for groups of 6 or more. Courses offered for Excel 2010, 2013, and 2016. All training delivered onsite, in your company’s meeting room.

Intended Audience

This course is designed for new Excel users or anyone with a need for basic Excel training.

Prerequisites

General proficiency with Microsoft Windows

Agenda

Lesson 1: Getting Started

  • Create new Excel workbooks
  • Perform file management tasks
  • Navigate in Excel worksheets

Lesson 2: Modifying Worksheets

  • Work with columns and rows
  • Edit cells
  • Organize worksheets information

Lesson 3: Using Formulas and Functions

  • Perform calculations using formulas and functions
  • Use relative and absolute cell references

Lesson 4: Formatting and Viewing Worksheets

  • Apply formatting
  • Utilize various settings to manage large worksheets

Lesson 5: Printing Workbooks

  • Explore worksheets using various views
  • Modify page setup
  • Preview / print workbooks

Excel 2013 Level 2

1 Day Course. $275 / participant plus HST.

Back to Course List Request a Quote!

Minimum enrollment required. Discounted pricing available for groups of 6 or more. Courses offered for Excel 2010, 2013, and 2016. All training delivered onsite, in your company’s meeting room.

Intended Audience

This course is intended for participants with basic Excel skills and a desire to build on their knowledge.

Prerequisites

Excel 2013 Level 1

Agenda

Lesson 1: Worksheet Organization

  • Work with named ranges
  • Use various techniques to protect data
  • Utilize outlines

Lesson 2: Advanced Formulas

  • Use the IF function
  • Work with linked formulas

Lesson 3: Using Multiple Workbooks and Worksheets

  • Use multiple worksheets
  • Consolidate data from multiple workbooks

Lesson 4: Working with Charts

  • Create, format, and customize charts to present data visually

Lesson 5: Applying Formatting

  • Utilize styles to format workbooks efficiently
  • Work with annotations and sparklines

Excel 2013 Level 3 Data Management

1 Day Course. $275 / participant plus HST.

Back to Course List Request a Quote!

Minimum enrollment required. Discounted pricing available for groups of 6 or more. Courses offered for Excel 2010, 2013, and 2016. All training delivered onsite, in your company’s meeting room.

Intended Audience

This course is designed for experienced Excel users who need to track and analyze large data sets.

Prerequisites

Excel 2013 Level 2

Agenda

Lesson 1: Maintaining Data

  • Work with Excel tables
  • Manage records using a data form
  • Use VLOOKUP / HLOOKUP functions

Lesson 2: Sorting Lists

  • Sort data lists using various techniques
  • Apply custom sorts as required

Lesson 3: Filtering Lists

  • Extract and work with data using AutoFilter
  • Utilize Advanced Filter

Lesson 4: Summarizing Data

  • Summarize data using Automatic Subtotals
  • Work with database functions

Lesson 5: PivotTables

  • Create, format, and manage PivotTables
  • Work with PivotCharts
  • Use slicers to specify custom data sets

Lesson 6: External Data

  • Import external data in various formats into Excel

Excel 2013 Level 3 Spreadsheet Analysis

1 Day Course. $275 / participant plus HST.

Back to Course List Request a Quote!

Minimum enrollment required. Discounted pricing available for groups of 6 or more. Courses offered for Excel 2010, 2013, and 2016. All training delivered onsite, in your company’s meeting room.

Intended Audience

This course is designed for experienced Excel users who need to manage and analyze financial models.

Prerequisites

Excel 2013 Level 2

Agenda

Lesson 1: Using Functions

  • Use formulas with absolute and mixed cell references
  • Utilize financial functions

Lesson 2: Projecting Figures

  • Leverage Goal Seek and Data Tables to assist in decision making

Lesson 3: What-If Scenarios

  • Examine with scenarios and scenario reports

Lesson 4: Using Solver

  • Analyze and solve complex problems using Solver
  • Utilize Solver reports

Lesson 5: Auditing Concepts

  • Utilize a range of tools to audit and better understand complex workbooks

Clients

We work with government and private sector clients throughout Ontario.

Aecon Logo
CBC Radio Canada Logo
Health Canada Logo
Sobeys Logo
World Vision Logo
Back to Top