How to Embed a YouTube Video in PowerPoint
Inserting a YouTube Video in PowerPoint Using a Link or Embed Code by Avantix Learning Team | Updated May 1, 2021 Applies to: Microsoft® PowerPoint® 2013, 2016, 2019 and 365 (Windows) You can embed a YouTube video in a PowerPoint presentation and run it during a slide...
Zoom Keyboard Shortcuts (50+ Shortcuts to Save Time During Your Virtual Meetings, Training and Webinars)
Check Out This Great List of Zoom Keyboard Shortcuts by Avantix Learning Team | Updated April 5, 2021 Applies to: Zoom® Desktop App (Windows and Mac) As a tool for virtual calls, meetings and webinars, Zoom has exploded recently with a huge group of users...
Microsoft Teams Keyboard Shortcuts (40+ Shortcuts)
Essential Keyboard Shortcuts for Microsoft Teams by Avantix Learning Team | Updated April 5, 2021 Applies to: Microsoft® Teams® Desktop App (Windows) If you're a Microsoft Teams user, you can save alot of time using your keyboard to access Teams commands. Check out...
Popular Articles
How to Lock Cells in Excel (Protect Formulas and Data)
Easily Lock Cells in Excel by Protecting Worksheets by Avantix Learning Team | Updated May 26, 2022 Applies to: Microsoft® Excel® 2013, 2016, 2019, 2021 or 365 (Windows) It's easy to lock cells in Excel to protect data or formulas. This is typically a two-step...
How to Password Protect Your Excel Worksheets and Workbooks
Protect Worksheets and Workbooks in Excel by Avantix Learning Team | Updated June 10, 2022 Applies to: Microsoft® Excel® 2013, 2016, 2019, 2021 or 365 (Windows) You can password protect worksheets and workbooks in Excel. If you want to prevent other users from opening...
Excel Shortcuts to Zoom In and Out in Your Worksheets (4 Shortcuts)
Save Time in Microsoft Excel using Shortcuts to Zoom In or Out by Avantix Learning Team | Updated May 24, 2022 Applies to: Microsoft® Excel® 2013, 2016, 2019, 2021 and 365 (Windows) There are several mouse and keyboard shortcuts you can use to zoom in and out in Excel...
3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells
Apply or Remove Strikethrough Using Shortcuts in Excel by Avantix Learning Team | Updated July 20, 2021 Applies to: Microsoft® Excel® 2013, 2016, 2019 and 365 (Windows) You can apply strikethrough to text or values in Excel to cross out or create a line through a cell...
How to Expand the Formula Bar in Excel (2 Ways)
Easily Expand or Collapse the Formula Bar in Excel by Avantix Learning Team | Updated May 27, 2021 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019 and 365 (Windows) In Microsoft Excel, the Formula Bar appears below the Ribbon by default. When you enter data or a...
10 Excel Flash Fill Examples (Extract, Combine, Clean and Format Data with Flash Fill)
Check Out These 10 Great Examples using Flash Fill in Excel by Avantix Learning Team | Updated January 25, 2021 Applies to: Microsoft® Excel® 2013, 2016, 2019 or 365 (Windows) Flash Fill is a great tool that you can use to quickly clean or format data in your Excel...
How to Add Slide Numbers in PowerPoint Presentations (Step-by-Step)
Add Slide Numbers in PowerPoint using Slide Layouts by Avantix Learning Team | Updated April 5, 2021 Applies to: Microsoft® PowerPoint® 2013, 2016, 2019, 2021 and 365 (Windows) You can insert slide numbers on some or all of your PowerPoint slides using slide layouts....
How to Replace Blank Cells in Excel with Zeros (0), Dashes (-) or Other Values
Quickly Fill Blanks with Zeros or Other Values in Excel Worksheets (0, -, N/A, Null or Other Text) by Avantix Learning Team | Updated August 7, 2021 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019 and 365 (Windows) You can quickly replace blank cells in Excel...
How to Hide Paragraph Marks in Word (or Show Them)
Hide Paragraph Marks (¶) and Other Nonprinting Symbols in Microsoft Word by Avantix Learning Team | Updated April 5, 2021 Applies to: Microsoft® Word® 2010, 2013, 2016, 2019 and 365 (Windows) You can show or hide paragraph marks (¶) or symbols and other nonprinting...
Free PowerPoint Countdown Timer Templates to Download
Free Countdown Timers You Can Use in PowerPoint by Avantix Learning Team | Updated April 5, 2021 Applies to: Microsoft® PowerPoint® 2010, 2013, 2016, 2019 and 365 (Windows) You can create PowerPoint presentations with countdown timer slides or you can download free...
How to Superscript or Subscript in Word (with Shortcuts)
Apply Superscript or Subscript in Microsoft Word (3 Ways) by Avantix Learning Team | Updated October 9, 2021 Applies to: Microsoft® Word® 2010, 2013, 2016, 2019 and 365 (Windows) You can apply superscript or subscript in Microsoft Word using keyboard shortcuts,...
How to Convert a PDF to Word in Microsoft Word (for Free – No Third Party Programs Needed)
Convert a PDF File Natively in Microsoft Word by Avantix Learning Team | Updated October 9, 2021 Applies to: Microsoft® Word® 2013, 2016, 2019 or 365 (Windows) You can convert a PDF to Word natively in Microsoft Word for free. You don't need to download or use any...
How to Delete Blank Rows in Excel (5 Fast Ways to Remove Empty Rows)
Easy Ways to Remove Blank or Empty Rows in Excel by Avantix Learning Team | Updated April 5, 2021 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019 and 365 (Windows) You can delete blank rows in Excel using several tricks and shortcuts. Check out these 5 fast ways...
Zoom Keyboard Shortcuts (50+ Shortcuts to Save Time During Your Virtual Meetings, Training and Webinars)
Check Out This Great List of Zoom Keyboard Shortcuts by Avantix Learning Team | Updated April 5, 2021 Applies to: Zoom® Desktop App (Windows and Mac) As a tool for virtual calls, meetings and webinars, Zoom has exploded recently with a huge group of users...
Microsoft Teams Keyboard Shortcuts (40+ Shortcuts)
Essential Keyboard Shortcuts for Microsoft Teams by Avantix Learning Team | Updated April 5, 2021 Applies to: Microsoft® Teams® Desktop App (Windows) If you're a Microsoft Teams user, you can save alot of time using your keyboard to access Teams commands. Check out...
How to Get Slide Design Ideas Using PowerPoint Designer
Get Slide Design Ideas with PowerPoint Designer by Avantix Learning Team | Updated April 5, 2021 Applies to: Microsoft® PowerPoint® 365 (Windows) If you are a Microsoft 365 subscriber, you can use PowerPoint Designer to get design ideas for slides. Designer takes...
How to Summarize Multiple Excel Worksheets with 3D Reference Formulas
Summarize Multiple Excel Worksheets Using 3D References in Formulas by Avantix Learning Team | Updated January 24, 2021 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019 and 365 (Windows) You can use 3D references in Excel formulas to summarize multiple worksheets...
How to Print PowerPoint Presentations with Notes
Print PowerPoint Presentations with Speaker Notes by Avantix Learning Team | Updated May 30, 2022 Applies to: Microsoft® PowerPoint® 2010, 2013, 2016, 2019, 2021 and 365 (Windows) You can print PowerPoint presentations with notes with or without slide thumbnails. You...
How to Display a Word Document's File Name and Path (2 Ways)
Display the File Name and Path using Fields or the Quick Access Toolbar in Microsoft Word by Avantix Learning Team | Updated April 5, 2021 Applies to: Microsoft® Word® 2010, 2013, 2016 and 2016 (Windows) In Microsoft Word, you can display a document's file name and...
How to Keep Text Together in Word (Paragraphs, Lines or Words)
3 Ways to Keep Text Together in Microsoft Word Documents by Avantix Learning Team | Updated April 5, 2021 Applies to: Microsoft® Word® 2010, 2013, 2016, 2019 and 365 (Windows) You can keep text together in several ways in Word. If you want to keep words or characters...
How to Fill or Replace Blank Cells in Excel with a Value from a Cell Above
Easily Fill Blank Cells with Values from a Cell Above by Avantix Learning Team | Updated May 26, 2022 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019, 2021 and 365 (Windows) You can fill or replace blank cells in Excel with a value from a cell above using a few...
Productivity Articles
Zoom Keyboard Shortcuts (50+ Shortcuts to Save Time During Your Virtual Meetings, Training and Webinars)
Check Out This Great List of Zoom Keyboard Shortcuts by Avantix Learning Team | Updated April 5, 2021 Applies to: Zoom® Desktop App (Windows and Mac) As a tool for virtual calls, meetings and webinars, Zoom has exploded recently with a huge group of users...
Microsoft Teams Keyboard Shortcuts (40+ Shortcuts)
Essential Keyboard Shortcuts for Microsoft Teams by Avantix Learning Team | Updated April 5, 2021 Applies to: Microsoft® Teams® Desktop App (Windows) If you're a Microsoft Teams user, you can save alot of time using your keyboard to access Teams commands. Check out...
20 Tips for Working from Home (for Newbies)
20 Helpful Tips If You're a Newbie Working from Home in the Era of COVID-19 by Avantix Learning Team | April 1, 2020 As people around the world adjust to working and living in the unprecedented era of Coronavirus (COVID-19), a new group of workers are transitioning to...
How to Password Protect Your Excel Worksheets and Workbooks
Protect Worksheets and Workbooks in Excel by Avantix Learning Team | Updated June 10, 2022 Applies to: Microsoft® Excel® 2013, 2016, 2019, 2021 or 365 (Windows) You can password protect worksheets and workbooks in Excel. If you want to prevent other users from opening...
How to Freeze Row and Column Headings in Excel Worksheets
Easily Freeze Row and Column Titles in Excel by Avantix Learning Team | Updated February 21, 2022 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019, 2021 and 365 (Windows) As many Excel worksheets can become quite large, it can be useful to freeze row and column...
How to Convert Text to Numbers in Excel (5 Ways)
5 Ways to Convert Numbers Stored as Text to Numbers in Microsoft Excel Worksheets by Avantix Learning Team | Updated February 12, 2022 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019, 2021 and 365 (Windows) There are several ways to convert text to numbers in...
How to Add Audio in PowerPoint Presentations
Add Audio in PowerPoint from a File on Your PC or Shared Drive by Avantix Learning Team | Updated April 13, 2021 Applies to: Microsoft® PowerPoint® 2013, 2016, 2019 and 365 (Windows) You can add audio in PowerPoint from a file on your PC or from a shared drive. Audio...
How to Create a Mouse Over or Hover Over Pop-up Effect in PowerPoint
Create a Pop-Up Effect When You Mouse Over an Object in PowerPoint by Avantix Learning Team | Updated March 16, 2021 Applies to: Microsoft® PowerPoint® 2013, 2016, 2019 and 365 (Windows) You can create a pop-up effect in PowerPoint when you hover over or mouse over...
How to Change Slide Size or Dimensions in PowerPoint
Change PowerPoint Slide Size (Widescreen, Standard or Custom) by Avantix Learning Team | Updated October 9, 2021 Applies to: Microsoft® PowerPoint® 2010, 2013, 2016, 2019 and 365 (Windows) You can change the slide size or aspect ratio of a PowerPoint presentation in...
How to Show or Hide White Space in Word Documents
Show or Hide White Space in Microsoft Word Documents by Avantix Learning Team | Updated February 9, 2022 Applies to: Microsoft® Word® 2010, 2013, 2016, 2019 or 365 (Windows) You can show or hide white space at the top and bottom of pages in Microsoft Word documents....
How to Hear a Word Document Using Speak (Text to Speech)
Turn On Speak Selected Text in Microsoft Word (All Versions) by Avantix Learning Team | Updated September 10, 2021 Applies to: Microsoft® Word® 2010, 2013, 2016, 2019 or 365 (Windows) In Microsoft Word, you can have Word speak or read a document to you. You will need...
How to Insert a Nonbreaking Space in Word
Insert a Nonbreaking Space in Word to Keep Words or Characters Together by Avantix Learning Team | Updated October 9, 2021 Applies to: Microsoft® Word® 2010, 2013, 2016, 2019 and 365 (Windows) If you want to keep words or characters together on the same line in a Word...
How to Highlight Records or Values in a Microsoft Access Report Using Conditional Formatting
Apply Conditional Formatting in Microsoft Access Reports by Avantix Learning Team | Updated April 9, 2021 Applies to: Microsoft® Access® 2010, 2013, 2016, 2019 and 365 (Windows) You can highlight values or records in a Microsoft Access report using conditional...
How to Create a Calculated Field in a Microsoft Access Query
Create Calculated Fields in Microsoft Access Select Queries by Avantix Learning Team | Updated April 9, 2021 Applies to: Microsoft® Access® 2010, 2013, 2016, 2019 and 365 (Windows) You can create calculated fields in select queries in Microsoft Access in the QBE...
10 Useful Microsoft Access Shortcuts When You're Working with Controls on Forms and Reports
Try These Shortcuts for Manipulating Controls in Design View in Microsoft Access by Avantix Learning Team | Updated April 9, 2021 Applies to: Microsoft® Access® 2010, 2013, 2016, 2019 and 365 (Windows) Controls are objects that appear in various sections in a form or...
7 Microsoft Project Navigation and Selection Shortcuts in Task Lists
Use These Simple Tricks in Gantt Chart Task Lists by Avantix Learning Team | Updated June 11, 2021 Applies to: Microsoft® Project® 2010, 2013, 2016, 2019 and 365 (Standard and Professional) If you are working in Gantt Chart View, you can use these keyboard shortcuts...
10 Microsoft Project Shortcuts to Zoom and Move Quickly in the Gantt Chart Timescale
Try These Shortcuts to Move and Change the Timescale in Project's Gantt Chart View by Avantix Learning Team | Updated June 11, 2021 Applies to: Microsoft® Project® 2010, 2013, 2016, 2019 and 365 (Standard and Professional) The timescale in the Gantt Chart view appears...
Auto vs Manual Scheduling in Microsoft Project
Scheduling Tasks in Microsoft Project as Manual or Auto Scheduled by Avantix Learning Team | Updated June 11, 2021 Applies to: Microsoft® Project® 2010, 2013, 2016 and 2019 (Standard and Professional) Starting with Microsoft Project 2010, you have the option of...
Microsoft Visio Articles
Visio Shortcuts for Zooming and Panning using Your Mouse and Keyboard
Zoom and Move Pages Around Quickly in Microsoft Visio Drawings by Avantix Learning Team | Updated April 8, 2021 Applies to: Microsoft® Visio® 2010, 2013, 2016, 2019 or 365 (Windows) You can zoom and pan (move the page) in your Microsoft Visio diagrams quickly using...
10 Great Keyboard Shortcuts for Selecting Visio Tools
Keyboard Shortcuts to Select the Pointer, Drawing and Text Tools in Microsoft Visio by Avantix Learning Team | Updated August 30, 2021 Applies to: Microsoft® Visio® 2010, 2013 , 2016, 2019 and 365 (Windows) Check out these 10 great Microsoft Visio shortcuts for...
Microsoft Visio Timesaver – Temporarily Turn Off Snap Behaviour
Override Snap Behaviour in Visio with These Simple Tricks by Avantix Learning Team | Updated September 5, 2021 Applies to: Microsoft® Visio® 2013, 2016, 2019 or 365 (Windows) By default, Visio's dynamic grid is turned on as well as a number of "snap to" settings so...
Google, the Google logo and related Google Drive applications and logos are registered trademarks of Google LLC in Canada, US and other countries. 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