Microsoft Office 2016 Tips and Tricks

Have you upgraded to a tablet or Windows 10 and upgraded to Office 2016? Our customised courses in Office 2016 can guide you to make the most of the new features of Office 2016

Show Excel Formulas

There is a button in Excel that let's you show all your formulas at once. This is great for finding errors or just trying to work out what is going on with someone else's spreadsheet.

In the Formulas Toolbar, click the Show Formulas button. When you are finished analysing your spreadsheet, press the Show Formulas button again to turn it off.

Modernise Boring Bullets

Make your Power Point slides more attractive with Smart Art Shapes. Instead of boring bullet points, these colourful, 3D shapes will visually explain your topic.

power point smart art

To create a Smart Art graphic click the Insert Toolbar and click the Smart Art button

Publisher Drop Caps

A drop cap is a large capital letter at the beginning of a text block that has the depth of two or more lines of regular text. It is a creative way to draw attention to a featured section of text.

Highlight text inside a text box and in the Text Box Tools Toolbar click the Drop Cap button

publisher drop caps

Remove Duplicates in Excel

Tidy up your data and remove duplicates

On the Home Toolbar, click Conditional Formatting -> Highlight -> Duplicate Values

excel find duplicates

Explanation of Excel Cursors

Understanding the Excel Cursors will save you a lot of time and frustration

The Select Cursor will highlight cells and is the most common cursor you see
excel select cursor

The Move Cursor will move the highlighted cells to another location. It is a quick version of cut and paste
excel move cursor

The Auto Fill Cursor will copy formulas and repeat series such as dates and days
excel auto fill

Excel Input Restriction

excel input restriction

Are people entering in the incorrect data in your spreadsheets?

Make sure the data is valid by using Data Validation.

Go to Data Toolbar-> Data Validation and restrict what can be entered

Power Point 2016 Screen Recordings

Power Point 2016 Training

Perfect for demonstrations, you can now include screen recordings in your PowerPoint presentations with just a few clicks. Just set up whatever you'd like to record on your screen, then go to Insert > Screen recording, and you'll be able to select a portion of your screen to record, capture what you need, and insert it directly into your presentation in one seamless process.

Smart Lookup

Office 2016 Upgrade Training

Smart lookup lets you fact-check and research a phrase with results appearing in a sidebar.

Highlight a phrase, click on Review -> Smart Lookup to see results in the sidebar

Outlook attachments made easy

Outlook 2016 Training Courses

In Outlook 2016 you can easily attach documents you most recently worked on to your emails from the Insert tab.

When Inserting an attachment, select one of your recently saved files

Collaborating on Word Documents

When you and your colleagues want to collaborate on a document, use real time co-authoring to see everyone’s changes as they happen.

First you save the document to OneDrive or SharePoint Online, so others can work in it.

Next, you invite people to edit it with you. When they open and work on the document in Word 2016 or Word Online, you'll see each other’s changes as soon as they're made.

Six new chart types in Excel 2016

Get creative and display information in a new way. The new chart types in Excel 2016 are;

  • Treemap Chart
  • A Pareto or sorted histogram chart
  • Histogram
  • Box and whisker chart
  • Sunburst chart