Microsoft Office Articles | Avantix Learning
How to Create a Calculated Field in a Microsoft Access Query
You can create calculated fields in select queries in Microsoft Access in the QBE (Query by Example) grid. You'll need to learn a few syntax rules and then you can create simple to more complex calculations.
How to Print a PowerPoint Presentation with Notes
You can print PowerPoint presentations with notes with or without slide thumbnails. You can control the way notes or speaker notes are printed in three ways – by editing the Notes Master which affects all slides, by editing single notes pages in Notes Page view or by changing formatting in the Notes pane in Normal View.
How to Change the Measurement System Units in Microsoft Word (from Inches to Cm and Vice Versa)
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 cm (centimeters) or vice versa, simply change the measurement system in Word's Options. You can choose inches, centimeters, millimeters, points or picas. Changes in the measurement system will affect Word's Ruler as well as various dialog boxes (including the Paragraph dialog where you can change paragraph indents).
How to Add Speaker Notes in PowerPoint
You can add speaker notes in your PowerPoint decks using the Notes pane in Normal View. Speaker notes may be viewed by a presenter during a slide show and may be printed as well. When you create your PowerPoint slides, you can add, edit and format notes. If you'd like to view notes during your presentation, you'll need to keep them short because there is a limited amount of space to view them in Presenter View. You can also format notes and they can be distributed as a standalone document as an alternative to traditional PowerPoint handouts.
10 Microsoft Word Tips, Tricks and Shortcuts for Selecting in Tables
Check out these Word tips, tricks and shortcuts to select an entire table, a single cell, an entire row or column or even multiple rows or columns in tables.
How to Enter Data in an Excel Filtered List into Visible Cells (2 Ways)
It's a common issue for Microsoft Excel users to attempt to use AutoFill to fill data in a filtered list and it doesn't work as expected. The fill data is entered into all cells, including the hidden or invisible cells. The solution is to enter data into visible cells only …
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 Turn Off Snap to Grid in PowerPoint (3 Ways)
In PowerPoint, you can temporarily turn off or disable the snap to grid behaviour or turn off snap to grid permanently. Check out these 3 easy ways to control snap to grid.
How to Add or Remove Page Breaks in Microsoft Word
You can add or remove page breaks in Microsoft Word in a number of ways. You can delete manual page breaks by selecting them and deleting them …
10 Timesaving Excel Tricks and Shortcuts for Copying and Pasting
It's surprising how much time you can save with a few tricks and shortcuts for copying and pasting in Microsoft Excel. Here are 10 useful copy paste shortcuts for Excel users …
How to Make a Picture Transparent in PowerPoint (3 Ways)
You can make a picture transparent in PowerPoint in 3 ways. In newer versions of PowerPoint, you can use the Transparency command in the Ribbon or the Format Picture task pane to apply transparency. In older versions, you'll need to fill a shape with a picture and then make the shape transparent.
PowerPoint Trick to Cut, Copy and Store Objects in a Temporary Library
There's a hidden tool in PowerPoint that is extremely useful for copying and storing images, shapes or other objects much like a temporary library …
3 Easy Shortcuts to Copy Formatting in PowerPoint
Check out these three easy ways to copy shape, picture or text formatting quickly and easily in PowerPoint using buttons or keyboard shortcuts.
Create Dynamic Microsoft Word Documents Using Fields (Insert, Format and Update Fields)
You can create dynamic components in your Microsoft Word documents by inserting and updating fields. Update your fields and the document updates automatically!
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
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.
Microsoft Word Trick for Supercharged Cut, Copy and Paste
Here's a useful Microsoft Word trick if you do a lot of cutting, copying and pasting in Word. There's a hidden tool that can save you a lot of time …
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 Extract All Video or Audio Files from a PowerPoint Deck
If you want to extract embedded video or audio files from a Microsoft PowerPoint deck, you can extract them by converting the presentation to a zip file type.
How to Keep Text Together in Word (Paragraphs, Lines or Words)
You can keep text together in several ways in Word. If you want to keep words or characters together, you can use nonbreaking spaces or nonbreaking hyphens or dashes and insert them using a dialog box or a keyboard shortcut. If you want to keep lines or paragraphs together on the same page, you can apply settings in the Paragraph dialog box (which can be built into styles if you use styles).
How to Fill or Replace Blank Cells in Excel with a Value from a Cell Above
You can fill or replace blank cells in Excel with a value from a cell above using a few great Excel tricks. The data may have been imported from an external source or formatted this way by a client or colleague for readability but the blank cells are a problem if you want to sort, filter or summarize the data.
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 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 Export PowerPoint Handouts to Microsoft Word
It's easy to export handouts from Microsoft PowerPoint presentations to Word. If you decide to export handouts to Word, you'll be able to edit the handouts and add other information.
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