Four Microsoft Office Tips

Pamela Smith, an instructor with Spindustry Training, who has been teaching students about Microsoft Office products for 20 years, shares these four tips with you.

Microsoft Outlook

There is a feature in Microsoft Outlook that allows you to see a history of the emails, meetings and attachments you have sent or received from an individual. Rather than looking through a group of emails until you find that particular attachment, you can go to the People Pane of an email message from that person and see a collection of everything related to that person.
Microsoft Outlook Tip

Interested in learning more helpful tips? Check out our Microsoft Outlook classes.


Microsoft Word


Word’s Building Blocks allows you to take text and save it to be used again and again. There may be an introduction paragraph that you often use or an address you look up every time you need to type into your document. By saving it as a Building Block, you can start typing the text and have an AutoComplete message pop up with your content displayed. To use the information, you just press Enter, or you can add AutoText to the Quick Access Toolbar and see a list of all of your AutoText items.

Interested in learning more helpful tips? Check out our Microsoft Word classes.


Microsoft Excel


Excel’s Pivot Tables are very helpful in analyzing data. A Pivot Table can quickly show you the grand total. Let’s say you are looking at products sold. By checking a box, you can see a subtotal of all products sold by Department, Origin or any other grouping that you have in your database. You can rearrange the information to look at your data in different ways. The 2013 version of Excel allows you to bring in data from multiple sources into one Pivot Table.

Interested in learning more helpful tips? Check out our Microsoft Excel classes.


Microsoft PowerPoint


PowerPoint has a feature that allows you to take all of your files in your presentation and collect them in one location. You can save all of the files and links to a USB drive, and then take that USB drive to any computer and be able to walk through your presentation with all of the links, additional files and video clips in tack.

MicrosoftPowerPointTip2_SpindustryTrainingAlso, you can create Custom Shows. There may be times you only need to show a few slides of a presentation. Instead of saving it as a new file, create a Custom Show. This way you can choose the appropriate information to show at your presentation – and all the versions are saved in that one file.

Interested in learning more helpful tips? Check out our Microsoft PowerPoint classes.


In the next three minutes, you can:PamelaSmith_SpindustryTraining