Avantix Learning Courses
Instructor-led Classroom and Virtual Classroom Training
Our Toronto training courses are delivered as live, instructor-led classroom courses in downtown Toronto, Ontario, Canada. Some or our public courses are also offered in virtual classroom format. If you’d like to arrange custom virtual classroom training, contact us at info@avantixlearning.ca for more information. Avantix Learning offers an extensive range of courses at the introduction, intermediate and advanced levels for Microsoft Excel, Access, PowerPoint, Project, Word, Visio, Visual Basic for Applications (VBA), Publisher and other Microsoft Office applications for 2010, 2013, 2016, 2019 and 365 users. We also offer courses for the Adobe products and FileMaker Pro. You can also arrange custom training at your site or ours.
We specialize in small, personalized classes where students can interact with our top notch instructors in a comfortable environment. Public courses are offered at our downtown Toronto location at 1 Yonge Street, Suite 1801, Toronto, Ontario, Canada. Some courses may also be delivered at an alternate downtown Toronto location. Check out more information about Avantix Learning courses.
UPCOMING COURSES
As our clients and colleagues continue to practice physical distancing in response to COVID-19, we are offering several of our public courses in virtual classroom format led by a live instructor. If you’d like to arrange custom virtual training, contact us at info@avantixlearning.ca for more information.
Microsoft Access: Introduction | February 3, 2020 (Virtual classroom)
Microsoft PowerPoint: Introduction | February 5, 2021 (Virtual classroom)
Microsoft Excel: Introduction | February 9, 2021 (Virtual classroom)
Microsoft Word: Introduction | February 11, 2021 (Virtual classroom)
Microsoft Excel: Intermediate / Advanced | February 16/17, 2021 (Virtual classroom)
Microsoft PowerPoint: Intermediate / Advanced | February 18/19, 2021 (Virtual classroom)
Microsoft PowerPoint: Design for Non-Designers | February 23, 2021 (Virtual classroom)
Microsoft Word: Intermediate / Advanced | March 4/5, 2021 (Virtual classroom)
Microsoft Word: Styles, Templates and Tables of Contents | March 5, 2021 (Virtual classroom)
COURSE OUTLINES AND FEES
Click on any of the courses below to view a comprehensive course outline and course dates. Course fees are listed on each course outline and vary by application and duration. Register for any of the public scheduled courses or contact us to discuss a custom training solution.
Business Skills
Train the Trainer: Essential Skills for Teaching Adults >
Design and Drawing
Microsoft Publisher
Microsoft Publisher: Introduction >
Adobe InDesign
Adobe InDesign: Introduction >
Adobe InDesign and Acrobat Pro: Accessible Documents >
Microsoft Visio
Microsoft Visio: Introduction >
Microsoft Visio: Intermediate [Professional] >
Productivity
FileMaker Pro
FileMaker Pro: Introduction to Scripting >
Microsoft Access
Microsoft Access: Introduction >
Microsoft Access: Intermediate / Advanced >
Microsoft Access: Designing and Automating Forms >
Microsoft Access: Designing Queries and Reports >
Microsoft Access: Formulas and Functions >
Microsoft Access: Introduction to Macros and the Macro Designer >
Microsoft Access: Visual Basic for Applications (VBA) Macros | Introduction >
Microsoft Excel
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: Visual Basic for Applications (VBA) Macros | Intermediate >
Microsoft Excel: Introduction to Power Query to Get and Transform Data >
Microsoft Excel: Introduction to Power Pivot and Data Modelling >
Microsoft Excel: Visualizing Data with Charts >
Microsoft Outlook
Microsoft Outlook: Introduction >
Microsoft Word
Microsoft Word: Introduction >
Microsoft Word: Intermediate / Advanced >
Microsoft Word: Styles, Templates and Tables of Contents >
Microsoft Word: Designing Dynamic Documents Using Fields >
Microsoft Word: Long Documents Masterclass >
Microsoft Word:: Accessible Word Documents >
Microsoft Word: eBook Design, Publishing and Distribution >
Microsoft Word: Advanced Mail Merge >
Microsoft Word: Visual Basic for Applications (VBA) Macros | Introduction >
Presentations
Microsoft PowerPoint
Microsoft PowerPoint: Introduction >
Microsoft PowerPoint: Intermediate / Advanced >
Microsoft PowerPoint: Design for Non-Designers >
Microsoft PowerPoint: Animations Bootcamp >
Microsoft PowerPoint: Visualizing Data with Charts [2016] >
Microsoft PowerPoint: Accessible PowerPoint Presentations >
Microsoft PowerPoint: Visual Basic for Applications (VBA) Macros | Introduction >
Project Management
Microsoft Project
Microsoft Project: Introduction >
Microsoft Project: Intermediate / Advanced >
Microsoft Project: Generating Reports >
Microsoft Project: Visual Basic for Applications (VBA) Macros | Introduction >
PDF (Portable Document Format) Creation
Adobe Acrobat
Adobe Acrobat Pro: Introduction >
Adobe InDesign and Acrobat Pro: Accessible Documents >
Train the Trainer
Train the Trainer: Essential Skills for Teaching Adults >
Visual Basic for Applications (VBA)
Microsoft Access: Visual Basic for Applications (VBA) Macros | Introduction >
Microsoft Excel: Visual Basic for Applications (VBA) Macros | Introduction >
Microsoft Excel: Visual Basic for Applications (VBA) Macros | Intermediate >
Microsoft PowerPoint: Visual Basic for Applications (VBA) Macros | Introduction >
Microsoft Project: Visual Basic for Applications (VBA) Macros | Introduction >
Microsoft Word: Visual Basic for Applications (VBA) Macros | Introduction >

You may like
How to Compress Video Media in PowerPoint to Reduce File Size
You can compress video (and / or audio) media in a PowerPoint presentation to reduce file size. Since video and audio that is inserted into a PowerPoint file is embedded by default, video and audio media can increase file size significantly.
How to Fill Blank Cells with Zeros, Dashes or Other Values in Excel
You can quickly fill blank cells in a range of data in Excel with dashes, zeros or other number or text values. Blank cells can be problematic if you want to use a data set as the source for a pivot table.
How to Insert a Countdown Timer in PowerPoint
You can insert several types of countdown timers in PowerPoint presentations. In this article, we’ll review the steps to create 3 types of timers in PowerPoint using shapes and animations.
How to Convert Cm to Inches in Excel (or Inches to Cm)
You can convert cm to inches (or inches to cm) using formulas with operators or functions in Excel. This is useful since the regional settings on a computer affect the default measurement system used in Excel and other programs.
How to Hide Comments or Notes in Excel Workbooks
You can hide comments and notes in Excel workbooks. In addition to adding comments in Excel, there is a little known function called the N function that you can use to enter notes directly within a formula. The N function has been around for a long time so you can use it in older versions of Excel.
How to Make an Object Appear and Disappear in PowerPoint Using Animations
You can combine entrance and exit animations in PowerPoint to make an object appear and disappear on a slide during a slide show. This can occur automatically or on click. An object is typically a shape, image, text placeholder or text box.
Free PowerPoint Countdown Timer Templates to Download
You can create PowerPoint presentations with countdown timer slides or you can download free PowerPoint timer slides. Timers can be for minutes or seconds.
Lauren F.
Toronto, Ontario
Course: Microsoft Excel: Intermediate / Advanced
Thank you!
Kathleen
Markham, Ontario
Course: Microsoft Excel: Introduction
Erin L.
Toronto, Ontario
Course: Microsoft Excel: Intermediate / Advanced
You may also like
How to Remove Comments in Word (3+ Ways)
You can remove comments in Word by right-clicking, using the Review tab in the Ribbon or using the Inspector. The problem with comments is that they may be hidden if markup is not displayed. It’s a good idea to display markup and then remove comments.
How to Change Number Formats in Word Mail Merge Fields
You can change or fix the format of a number field in a Microsoft Word mail merge document using switches in field codes. Number formatting issues tend to occur when the source document for the mail merge is an Excel workbook or Access database.
How to Create Labels in Word Using Mail Merge and Excel Source Data
You can create labels in Microsoft Word by running a mail merge. This is typically used to generate and print bulk mailing labels for names and addresses of clients or other contacts. You’ll need to create a main document for the labels in Word and then connect to a data set or list in an Excel worksheet.
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca
Copyright 2021 Avantix® Learning