MS Excel Training
We offer more than 12 days of instructor-led Microsoft Excel courses, both in-person and in a virtual classroom environment.
Our Excel courses include the following (click the course name to view the full course details):
Microsoft Excel: Introduction >
Microsoft Excel: Intermediate / Advanced >
Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools >
Microsoft Excel: Visual Basic for Applications (VBA) Macros | Introduction >
Microsoft Excel: Introduction to Power Query to Get and Transform Data >
Microsoft Excel: Essential Features and Functions in Excel 365 >
You may like
10 Word Shortcuts to Select Text Using a Keyboard
10 Timesaving Shortcuts to Select Text in Word Using Only a Keyboard by Avantix Learning Team | Updated March 21, 2024 Applies to: Microsoft® Word® 2013, 2016, 2019, 2021 or 365 (Windows) You can use several shortcuts in Word to select text in your documents using...
How to Replace Zeros (0) with Blanks in Excel
Enter, Return or Display Blanks Instead of Zeros in Excel by Avantix Learning Team | Updated January 4, 2024 Applies to: Microsoft® Excel® 2016, 2019, 2021 and 365 (Windows) There are several strategies to replace zero values (0) with blanks in Excel. If you want to...
What is Power Query in Excel?
What is Power Query in Excel and Why is It So Useful? by Avantix Learning Team | Updated November 18, 2023 Applies to: Microsoft® Excel® 2016, 2019, 2021 and 365 (Windows) Power Query in Excel is a powerful data transformation tool that allows you to import data from...
How to Freeze Rows in Excel (One or Multiple Rows)
Freeze One or More Rows in an Excel Worksheet by Avantix Learning Team | Updated October 25, 2023 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019, 2021 and 365 (Windows) You can freeze one or more rows in an Excel worksheet using the Freeze Panes command. If you...
How to Show or Hide Gridlines in Excel
Show or Hide Gridlines in Excel Worksheets (+ Shortcuts) by Avantix Learning Team | Updated October 15, 2023 Applies to: Microsoft® Excel® 2013, 2016, 2019, 2021 and 365 (Windows) You can remove or hide gridlines in Excel worksheets to simplify worksheet design. By...
How to Insert or Type E with an Accent Mark in PowerPoint (È, É, Ê, Ë, è, é, ê, or ë)
3 Ways to Insert E with an Accent in PowerPoint Presentations by Avantix Learning Team | Updated October 4, 2023 Applies to: Microsoft® PowerPoint® 2013, 2016, 2019, 2021 and 365 (Windows) You can insert or type e with an accent mark in PowerPoint using built-in tools...
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca