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 firstname.lastname@example.org to discuss any of our custom training options.
Click the course name to view the full course outline.
Microsoft Excel: Introduction | October 6, 2022 (Virtual classroom or In-person)
Microsoft Excel: Introduction to Power Query to Get and Transform Data | October 17, 2022 (Virtual classroom)
Microsoft Excel: Intermediate / Advanced | October 20/21, 2022 (Virtual classroom or In-person)
Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools | October 27/28, 2022 (Virtual classroom or In-person)
Microsoft Excel: Introduction | November 7, 2022 (Virtual classroom or In-person)
Microsoft Excel: Intermediate / Advanced | November 9/10, 2022 (Virtual classroom or In-person)
Microsoft Excel: Visual Basic for Applications (VBA) Macros | Introduction | November 24/25, 2022 (Virtual classroom)
Microsoft Excel Learning Path
Just getting started? Novice users can start with our Microsoft Excel: Introduction course.
Take your skills to the next level in our Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools course.
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 email@example.com if you'd like to arrange custom instructor-led virtual classroom or onsite training on a date that's convenient for you.
Copyright 2022 Avantix® Learning
You may like
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.
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.
Here are 5 different ways to quickly convert numbers stored as text to numbers in a Microsoft Excel worksheet. You can use a Smart Tag, Paste Special or …
You may also like
You can delete a table in a Word document in 4 simple ways – using the Ribbon, using the context menu, using the Backspace key or by selecting a paragraph and a table and pressing Delete.
You can make columns in Word documents in a few different ways. There are two types of columns you can create – newspaper-style columns where the text flows from column to column or tables with columns and rows. You can create documents that contain two, three or more columns. In this article, we'll review how to set up newspaper-style columns. If you want to create a table, check out How to Create a Table in Word (4 Ways).
You can create a table in a Word document in 4 easy ways using the Ribbon. A table is a grid made up of columns and rows that intersect to form cells. You can insert text, numbers and images in a table. Once you have inserted a table, you can easily add and resize columns and rows and change table formatting.
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 firstname.lastname@example.org