Avantix Learning Blog

Recent Articles

View related training courses >

How to Create 3D References in Microsoft Excel

How to Create 3D References in Microsoft Excel

You can use 3D references in Excel formulas to calculate across multiple worksheets that are structured in the same way. A 3D reference refers to the same cell or range of cells on multiple worksheets.

How to Change the Measurement System in Microsoft Word

How to Change the Measurement System in Microsoft Word

You can easily change the measurement system units in Microsoft Word for all of your documents. If you’d prefer to work in inches rather than centimeters (or vice versa), simply change the measurement system in Word’s Options.

How to Freeze Row and Column Headings in Microsoft Excel

How to Freeze Row and Column Headings in Microsoft Excel

As many Excel worksheets can become quite large, it can be useful to freeze row and column headings so that they are locked in place when you scroll through your worksheet. In Excel, you can freeze both row headings and column headings or just one.

How to Add Notes in PowerPoint Files

How to Add Notes in PowerPoint Files

You can add notes or speaker notes in your PowerPoint files using the Notes pane in Normal view. Notes may be viewed by a presenter during a presentation and may be printed as well. When you create your PowerPoint slides, you can add, edit and format notes.

How to Export PowerPoint Speaker Notes to Microsoft Word

How to Export PowerPoint Speaker Notes to Microsoft Word

During a Microsoft PowerPoint training course, students often ask how to send speaker notes from a PowerPoint presentation to a Word document. The best option is to send the notes to Word with the notes next to the slides. After you’ve exported to Word, a table will be created with 3 columns – slide number, slide images and notes on the right.

How to Convert a Microsoft Access Report to PDF [3 Ways]

How to Convert a Microsoft Access Report to PDF [3 Ways]

If you have Microsoft Access 2010 or a later version, you can easily convert your Access reports to PDF without using Adobe Acrobat Pro. Use the File tab or the External Data tab on the Ribbon or you can customize the Quick Access Toolbar.

How to Copy Styles Between Microsoft Word Documents Using the Organizer

How to Copy Styles Between Microsoft Word Documents Using the Organizer

Styles are one of the most useful features in Microsoft Word to automate formatting. If you’re using styles (and hopefully you are), you’ll likely want to copy styles between Microsoft Word documents. One way to copy or import styles is to use Word’s Organizer but the Organizer is a bit difficult to find in newer versions.

10 Hidden Microsoft Word Features Every User Should Know

10 Hidden Microsoft Word Features Every User Should Know

Here’s a list of 10 extremely useful hidden features in Microsoft Word. You can quickly remove and replace formatting, remove hidden text, change Word’s measurement system and perform many other useful tasks using these hidden tools.

10 More Excel Pivot Table Shortcuts

10 More Excel Pivot Table Shortcuts

Since pivot tables are one of the most powerful tools in Microsoft Excel for summarizing data, we’ve compiled a list of 10 more keyboard shortcuts for pivot table users.

8 Excel Tips for Entering Formulas

8 Excel Tips for Entering Formulas

Check out these 8 Excel tips and tricks for entering formulas. You’ll save a lot of time and even help reduce errors in your formulas.

10 Great Excel Pivot Table Shortcuts

10 Great Excel Pivot Table Shortcuts

Check out these 10 great Excel pivot table keyboard shortcuts. You can use standard shortcuts using the Control key or use Alt to access the Ribbon and create pivot tables in different ways.

10 Ways to Save Time Selecting in Excel using the Name Box

10 Ways to Save Time Selecting in Excel using the Name Box

You can save a lot of time selecting in Microsoft Excel using the Name Box. The Name Box is located to the left of the Formula Bar in Microsoft Excel. You can enter directly in the Name Box to quickly select cells or even objects.

How to Highlight Text in PowerPoint [5 Ways]

How to Highlight Text in PowerPoint [5 Ways]

You can highlight text in PowerPoint in many different ways. If you’re an Office 365 subscriber, Text Highlight Color is available on the Home tab in the Ribbon. For everyone else, you’ll need to use other strategies if you want to highlight text …

How to Turn Off Automatic Text Resizing in PowerPoint

How to Turn Off Automatic Text Resizing in PowerPoint

PowerPoint’s Autofit feature is set to automatically resize text in text boxes or placeholders. To stop this, you can turn off Autofit settings for all PowerPoint presentations on your computer or for a specific text box or placeholder.

How to Convert a Microsoft Access Report to PDF [3 Ways]

How to Convert a Microsoft Access Report to PDF [3 Ways]

If you have Microsoft Access 2010 or a later version, you can easily convert your Access reports to PDF without using Adobe Acrobat Pro. Use the File tab or the External Data tab on the Ribbon or you can customize the Quick Access Toolbar.

10 Timesaving Shortcuts in Microsoft Access

10 Timesaving Shortcuts in Microsoft Access

Save time in Microsoft Access using these great keyboard shortcuts. We’re assuming you’re already using standard shortcuts like Ctrll + P to print, Ctrl + S to save and Ctrl + C to copy.

Microsoft Visio Articles

View related training courses >

No Results Found

The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.

To request this page in an alternate format, email our staff at info@avantixlearning.ca

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

Pin It on Pinterest