Avantix Learning Blog

Recent Articles

View related training courses >

How to Change the Measurement System in Microsoft Word

You can easily change the measurement system 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

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

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 Add Slide Numbers in PowerPoint (The Complete Guide)

You can add slide numbers in PowerPoint to some or all of your slides using slide layouts. If your slide layouts contain slide number placeholders, you can then apply those layouts to your slides so that your slide numbers will display in Normal view …

10 Excel Tips for Working with the Subtotal Feature

You can insert subtotals in Microsoft Excel data sets or lists using the Subtotal feature. Check out these 10 great tips which include showing and hiding subtotals, formatting subtotals, copying only subtotals and grand totals and more …

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 …

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.

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.

10 Microsoft Excel Magic Tricks with Flash Fill

Flash Fill is a great new tool that you can use to quickly clean or format data in your Excel workbooks. It can automatically extract, combine and format data without using a formula. It does seem like magic.

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 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.

10 Excel Tips for Working with the Subtotal Feature

You can insert subtotals in Microsoft Excel data sets or lists using the Subtotal feature. Check out these 10 great tips which include showing and hiding subtotals, formatting subtotals, copying only subtotals and grand totals and more …

5 Awesome Excel Chart Shortcuts

If you create a lot of charts in Excel, you’re probably looking for shortcuts to speed up creation and formatting. Here are 5 useful shortcuts you can use with your Excel charts.

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

In Excel, there are all kinds of tips, tricks and shortcuts you can use when entering formulas. In this article, we’ll review some common as well as little known tips for entering formulas quickly and easily in Microsoft Excel.

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.

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 Add Slide Numbers in PowerPoint (The Complete Guide)

You can add slide numbers in PowerPoint to some or all of your slides using slide layouts. If your slide layouts contain slide number placeholders, you can then apply those layouts to your slides so that your slide numbers will display in Normal view …

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 Change the Measurement System in Microsoft Word

You can easily change the measurement system 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.

Microsoft Access Articles

View related training courses >

How to Easily Export Microsoft Access Data to Excel

Microsoft Access includes an export wizard that can be used to export tables, queries, forms or reports easily to Excel. It’s common to have many users in an organization using Excel so data in Excel format can work well.

10 Techniques for Designing Forms in Microsoft Access

Simple Strategies for Access Form Designers Posted by: Avantix Learning Team Published: February 8, 2016 Applies to: Microsoft® Access® 2010 (also applies to 2013 and 2016) Objects on a form or report in Microsoft Access are called controls. You’ll save a lot of time...

Auto vs Manual Scheduling in Microsoft Project

In newer versions of Microsoft Project, you have the option of scheduling tasks using manual or auto scheduling. In earlier versions, Microsoft Project used auto scheduling which takes advantage of Project’s scheduling engine to schedule tasks.

How to Create a Timeline in Microsoft Project

Timelines are a great way to view key tasks and milestones in a project. You can add tasks to a timeline and then format it any way you’d like. Copy a timeline into an email or Word or PowerPoint file to present the timeline.

Microsoft Visio Articles

View related training courses >

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