Microsoft Excel Training Courses

Instructor-led Classroom and Virtual Classroom Training

Microsoft Office Series

Our live instructor-led Microsoft Excel training courses are held in downtown Toronto, Ontario, Canada. We also offer courses in virtual classroom format. Our hands-on Excel courses are offered at the introduction, intermediate and advanced levels for 2013, 2016, 2019 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

We are currently offering our public courses in virtual classroom format. Our instructor-led training may be delivered in-person as live classroom or virtual classroom courses. Contact us at info@avantixlearning.ca to discuss any of our custom training options.

Microsoft Excel: Introduction | August 12, 2021 (Virtual classroom)

Microsoft Excel: Intermediate / Advanced | August 17/18, 2021 (Virtual classroom)

Microsoft Excel: Introduction | September 13, 2021 (Virtual classroom)

Microsoft Excel: Intermediate / Advanced | September 16/17, 2021 (Virtual classroom)

Microsoft Excel: Visual Basic for Applications (VBA) Macros | Introduction | September 27/28, 2021 (Virtual classroom)

VIEW MORE COURSES AND DATES >  

Register for this training course.

Looking for custom training? Contact us to arrange custom training at your site or ours.

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 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada (some live 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 training on a date that's convenient for you.

Copyright 2021 Avantix® Learning

You may like

3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells

3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells

You can apply strikethrough to text or values in Excel to cross out or create a line through a cell or part of a cell. There are 3 common ways to apply strikethrough in your Excel worksheets – using a built-in keyboard shortcut, using the Font dialog box, or by adding a command to the Quick Access Toolbar.

How to Lock the Position of a Slicer in Excel

How to Lock the Position of a Slicer in Excel

Slicers are a great tool in Excel to filter tables or pivot tables. You can lock the position of a slicer in an Excel worksheet using a two-step process. First, select the slicer or slicers and Disable resizing and moving in the Format Slicer task pane (and choose other options based on your preferences). Second, protect the sheet using the Review tab in the Ribbon. There are a few important options you’ll need to select to get this to work.

You may also like

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 | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca

Upcoming Training
Course
Microsoft Excel training courses at introduction, intermediate and advanced levels for 2013, 2016, 2019 and 365 users (Online in virtual classroom format or in-person in Toronto)
Location
Avantix Learning, 1 Yonge Street, Suite 1800 (Toronto Star Building),Toronto, Ontario, Canada,-M5E 1W7
Next course starts
August 12, 2021
Next course ends
August 12, 2021
Description
Microsoft Excel training courses online or in Toronto, Ontario, Canada. Instructor-led introduction, intermediate or advanced Excel courses for 365, 2019, 2016, and 2013. In-person classes are delivered in downtown Toronto. 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