Microsoft Excel Training Courses

Instructor-led Classroom and Virtual Classroom Training

Our live instructor-led Microsoft Excel training courses are held in downtown Toronto, Ontario, Canada. We also offer online courses in virtual classroom format. Our hands-on Excel courses are offered at the introduction, intermediate and advanced levels for 2013, 2016, 2019, 2021 and 365 users. Learn to efficiently enter formulas using common and advanced functions, quickly format worksheets, use IF and Vlookup functions, apply conditional formatting, apply filtering, create tables, generate basic and advanced pivot tables, create dashboards, work with Power Pivot and Power Query business intelligence tools, use What-if analysis tools and learn to program and automate Excel using Visual Basic for Applications (VBA) even if you have never programmed before.

UPCOMING EXCEL COURSES

Our instructor-led training may be delivered as in-person (live classroom) or virtual classroom courses as indicated. Contact us at info@avantixlearning.ca to discuss any of our custom training options.

Click the course name to view the full course outline.

Microsoft Excel: Introduction | February 13, 2023 (Virtual classroom or In-person)

Microsoft Excel: Intermediate / Advanced | February 15/16, 2023 (Virtual classroom or In-person)

Microsoft Excel: Introduction | March 7, 2023 (Virtual classroom or In-person)

Microsoft Excel: Intermediate / Advanced | March 8/9, 2023 (Virtual classroom or In-person)

Microsoft Excel: Introduction to Power Query to Get and Transform Data | March 17, 2023 (Virtual classroom or In-person)

Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools | March 23/24, 2023 (Virtual classroom or In-person)

Microsoft Excel: Visual Basic for Applications (VBA) Macros | Introduction | March 29/30, 2023 (Virtual classroom)

VIEW MORE COURSES AND DATES >  

Register for this training course.

Check out our blog for Excel tips, tricks and shortcuts. If you are looking for information about new features, you may be interested in our Microsoft Excel version overviews.

Microsoft Excel Learning Path

Level 1 training courses.

Just getting started? Novice users can start with our Microsoft Excel: Introduction course.

Level 2 training courses.

Learn core competencies in our Microsoft Excel: Intermediate / Advanced course. You may also want to check out our Microsoft Excel: Visualizing Data with Charts course.

Level 3 training courses.

Take your skills to the next level in our Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools course.

Level 4 training courses at Avantix Learning.

Do you want to learn to automate Excel? Check out our Microsoft Excel: Introduction to VBA (Visual Basic for Applications) Macros  course designed for non-programmers or Microsoft Excel: Visual Basic for Applications (VBA) Macros | Intermediate course if you already know the basics of VBA. Need to work with large data sets? You may benefit from our Microsoft Excel Business Intelligence (BI) courses – Microsoft Excel: Introduction to Power Query to Get and Transform Data and Microsoft Excel: Introduction to Power Pivot and Data Modelling .

Check out our blog for Excel tips, tricks and shortcuts. If you are looking for information about new features, you may be interested in our Microsoft Excel version overviews.

Microsoft Excel Learning Path

Level 1 training courses.

Just getting started? Novice users can start with our Microsoft Excel: Introduction course.

Level 2 training courses.

Learn core competencies in our Microsoft Excel: Intermediate / Advanced course. You may also want to check out our Microsoft Excel: Visualizing Data with Charts course.

Level 3 training courses.

Take your skills to the next level in our Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools course.

Level 4 training courses at Avantix Learning.

Do you want to learn to automate Excel? Check out our Microsoft Excel: Introduction to VBA (Visual Basic for Applications) Macros  course designed for non-programmers or Microsoft Excel: Visual Basic for Applications (VBA) Macros | Intermediate course if you already know the basics of VBA. Need to work with large data sets? You may benefit from our Microsoft Excel Business Intelligence (BI) courses – Microsoft Excel: Introduction to Power Query to Get and Transform Data and Microsoft Excel: Introduction to Power Pivot and Data Modelling .

Our instructor-led courses are delivered in virtual classroom format or at our downtown Toronto location at 18 King Street East, Suite 1400, Toronto, Ontario, Canada (some in-person classroom courses may also be delivered at an alternate downtown Toronto location). Contact us at info@avantixlearning.ca if you'd like to arrange custom instructor-led virtual classroom or onsite training on a date that's convenient for you.

Copyright 2023 Avantix® Learning

You may like

How to Password Protect Your Excel Worksheets and Workbooks

How to Password Protect Your Excel Worksheets and Workbooks

You can password protect worksheets and workbooks in Excel. If you want to prevent other users from opening or modifying an Excel workbook, you can encrypt the file with a password. You can also protect workbook structure where you can prevent users from deleting, renaming, moving or unhiding worksheets. Password protection can be added to your Excel file in several ways.

How to Freeze Row and Column Headings in Excel Worksheets

How to Freeze Row and Column Headings in Excel Worksheets

As many Excel worksheets can become quite large, it can be useful to freeze row and column headings or freeze panes so titles are locked in place when you scroll through your worksheet. In Excel, you can freeze both row headings and column headings or just one.

You may also like

How to View Document Statistics in Microsoft Word

How to View Document Statistics in Microsoft Word

Microsoft Word automatically tracks statistics about your documents. These statistics appear in Word Properties and include the file name, directory, template, author, editing time, last print date and the user who last modified the document.

How to Create a Table Template in Word

How to Create a Table Template in Word

If you insert tables frequently in Word, you may want to create a table template to save time. Keep in mind that tables are affected by themes, styles and table styles so if the table template you insert seems to change formatting, the current document may contain different formatting from the original document when the table template was saved. A table template is saved as a building block and will appear in Quick Tables.

Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.

Avantix Learning |18 King Street East, Suite 1400, Toronto, Ontario, Canada M5C 1C4 | Contact us at info@avantixlearning.ca

Upcoming Training
Course
Microsoft Excel training courses at introduction, intermediate and advanced levels for 2013, 2016, 2019, 2021 and 365 users (Online in virtual classroom format or in-person in Toronto)
Location
Avantix Learning, 18 King Street East, Suite 1400,Toronto, Ontario, Canada,-M5E 1W7
Next course starts
February 13, 2023
Next course ends
February 13, 2023
Description
Microsoft Excel training courses online in virtual classroom format or in Toronto, Ontario, Canada. Instructor-led introduction, intermediate or advanced Excel courses for 365, 2021, 2019, 2016, and 2013. In-person classes are delivered in downtown Toronto or arrange onsite training at your location. Virtual classroom courses are available to our clients in Toronto, Mississauga, London, Calgary, Edmonton, Ottawa, Vancouver, Winnipeg, Halifax and other cities in Canada and the United States.

Pin It on Pinterest