Got a question? Call +632 8244 2098   |   

Office 2016 – Upgrading

  • Length 2 days
Course overview
View dates &
book now
  • Register interest

Why study this course

This course provides skills and knowledge in a wide range of new features, enhancements and changes found in Microsoft Office 2013 and Microsoft Office 2016. It is particularly useful for those upgrading from Microsoft Office 2010 and earlier.

Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.

What you’ll learn

On completion of this course you should be able to:

  • Understand the Office 2016 interface

  • Use the help system tools available to you in Office 2016

  • Work with files in Office 2016

  • Use the new features available for formatting graphics

  • Insert and edit pictures

  • Understand what has changed in Word 2016

  • Understand and work with a number of the new and improved features of Excel 2016

  • Understand and work with new charts and chart tools

  • Understand and work with Power View and Power Pivot

  • Understand and work with Power Pivot

  • Understand and work with Excel Power Map

  • Understand and work with Excel Get & Transform

  • Use the new and enhanced features of PowerPoint 2016

  • Work with many of the new features of Outlook 2016

  • Work with email messages in Outlook 2016

  • Work with the new People and Calendar features in Outlook 2016

Microsoft Office Applications at DDLS

DDLS is your best choice for training and certification in any of Microsoft’s leading technologies and services. We’ve been delivering effective training across all Microsoft products for over 30 years, and are proud to be Australia’s First and largest Microsoft Gold Learning Solutions Partner. All DDLS Microsoft courses follow Microsoft Official Curriculum (MOC) and are led by Microsoft Certified Trainers. Join more than 5,000 students who attend our quality Microsoft courses every year.

Stay ahead of the technology curve

Don’t let your tech outpace the skills of your people

Quality instructors and content

Expert instructors with real world experience and the latest vendor- approved in-depth course content.

Partner-Preferred Supplier

Chosen and awarded by the world’s leading vendors as preferred training partner.

Ahead of the technology curve

No matter your chosen technologies or platforms, we can help you stay one step ahead.

Who is the course for?

This course is for users of versions of Microsoft Office prior to Office 2010 or 2013 who are seeking a comprehensive upgrade experience. It is assumed that users will generally be upgrading from Office 2010 or earlier, so features introduced in Office 2013 are also covered.

We can also deliver and customise this training course for larger groups – saving your organisation time, money and resources. For more information, please contact us via email on


Course subjects

The Office 2016 Interface

  • An Updated Look

  • Understanding the Office 2016 Interface

  • Starting an Office 2016 Application

  • Using Tell Me

  • Understanding the Start Screen

  • Using Smart Lookup

  • Customising the Ribbon With Display Options

  • Working Collaboratively

  • Understanding the Backstage View

  • Accessing the Backstage View

  • Integrating With the Cloud

  • Working With Touch Mode

The Office 2016 Help System

  • Understanding How Help Works

  • Knowing Your Version and Build

  • Accessing the Help Window

The Office 2016 File System

  • The Open Place

  • Opening Files in Office 2016

  • Closing Files in Office 2016

  • Opening Recent Files and Folders

  • Recent Files From the Start Screen

  • Understanding File Saving in Office 2016

  • Saving to OneDrive

  • Saving to a Previous Version

  • Saving as Macro Enabled

  • Creating a PDF File

  • Creating New Files in Office 2016

  • Understanding Templates in Office 2016

  • Saving Custom Templates

  • Setting a Custom Templates Location

  • Understanding Sharing

  • Sharing a Document Using OneDrive

Formatting Graphics in Office 2016

  • Understanding Graphics Formatting

  • Understanding Format Panes

  • Working With the Format Pane

  • Moving the Format Pane

  • Formatting With the Layout Options Button

  • Quickly Formatting Charts

Pictures and Illustrations

  • Inserting a Picture

  • Inserting an Online Picture

  • Applying Picture Styles

  • Repositioning Pictures

  • Applying and Changing Effects

  • Correcting Pictures

  • Changing Picture Colouring

  • Understanding Illustrations

  • Inserting Text Into a Shape

Microsoft Word 2016

  • What’s New in Word 2016

  • The Word 2016 Screen

  • Spell Checking in Word 2016

  • Understanding the Design Tab

  • Applying a Style Set

  • Inserting Online Videos

  • Aligning Graphical Elements

  • Opening and Editing PDFs

  • Inserting Comments in Word 2016

  • Working With Comments

  • Understanding Read Mode

  • Viewing a Document in Read Mode

  • Using Resume Reading

  • Inserting Columns and Rows Into a Table

  • Drawing Table Borders

Microsoft Excel 2016

  • What’s New in Excel 2016

  • New Worksheet Functions in Excel 2013

  • New Worksheet Functions in Excel 2016

  • The ARABIC Function

  • The DAYS Function

  • The IFNA Function

  • Functions That Test Formulas

  • The RRI Function

  • The Worksheet Information Functions

  • Understanding Flash Fill

  • Extracting With Flash Fill

  • More Complex Flash Fill Extractions

  • Extracting Dates and Numbers

  • Recommended Pivot Tables

  • Understanding Slicers

  • Creating Slicers

Excel 2016 Charts and Quick Analysis

  • New Chart Types

  • New Charting Features

  • Using a Recommended Chart

  • Working With the New Chart Tools

  • Working With Chart Elements

  • Working With Chart Styles

  • Filtering the Chart

  • Working With Chart Data

  • Understanding Quick Analysis

  • Quick Formatting

  • Quick Charting

  • Quick Totals

  • Quick Sparklines

  • Quick Tables

Excel Power View

  • Understanding Power View

  • Enabling Power View

  • Adding Power View to the Ribbon

  • Creating a Power View Sheet

  • Working With a Power View Object

  • Working With Power View Fields

  • Rearranging and Sorting Fields

  • Working With Measure Fields

  • Formatting Power View Data

  • Tiling Data in Power View

  • Filtering in Power View

  • Switching Visualisations

  • Adding More Power Views

  • Adding Titles and Images

  • Updating a Power View Report

Excel Power Pivot

  • Understanding Power Pivot

  • Understanding Relational Data

  • Enabling Power Pivot

  • Connecting to a Data Source

  • Working With the Data Model

  • Working With Data Model Fields

  • Changing a Power Pivot View

  • Creating a Data Model PivotTable

  • Using Related Power Pivot Fields

  • Creating a Calculated Field

  • Creating a Concatenated Field

  • Formatting Data Model Fields

  • Using Calculated Fields

  • Creating a Timeline

  • Adding Slicers

Excel Power Map

  • Understanding Power Map

  • Creating a Power Map Tour

  • Working With Location Fields

  • Working With Mapping Confidence

  • Working With Height and Category Fields

  • Filtering Data

  • Navigating a Data Map

  • Changing the Look

  • Working With Layers

  • Working With Scenes

  • Working With Scene Options

  • Working With Time Settings

  • Viewing and Editing a Tour

  • Exporting a Tour as a Video

Excel Get and Transform

  • Understanding Get and Transform

  • Understanding the Navigator Pane

  • Creating a New Query From a File

  • Creating a New Query From the Web

  • Understanding the Query Editor

  • Displaying the Query Editor

  • Managing Data Columns

  • Reducing Data Rows

  • Adding a Data Column

  • Transforming Data

  • Editing Query Steps

  • Merging Queries

  • Working With Merged Queries

  • Saving and Sharing Queries

  • The Advanced Editor

Microsoft PowerPoint 2016

  • What’s New in PowerPoint 2016

  • The PowerPoint 2016 Screen

  • Creating a Presentation

  • Applying Theme Variants

  • Inserting an Online Video

  • Aligning Objects

  • Merging Shapes

  • Selecting Colours Using the Eyedropper

  • Inserting Comments in PowerPoint 2016

  • Looking at Presenter View in Detail

  • Using Presenter View

  • Exporting a Presentation to Video

  • Presenting Online

Microsoft Outlook 2016

  • What’s New in Outlook 2016

  • Common Outlook 2016 Screen Elements

  • Navigating to Outlook Features

  • Sneaking a Peek

  • The Folder Pane

  • The to Do Bar

  • The Mail Screen

  • The Calendar Screen

  • The People Screen

Outlook 2016 Mail

  • Outlook Clutter

  • Opening an Outlook Data File

  • Previewing Messages

  • Showing Unread or All Mail

  • Using Quick Action Commands

  • Responding to Messages Using Inline Replies

  • Sending an Email Without an Attachment

  • Outlook Attachments

  • Understanding Conversation View

Other Outlook 2016 Features

  • Understanding People View

  • Viewing Your Contacts

  • Editing a Contact

  • Pinning a Contact to Your Favourites

  • Contacting a Contact From the People Card

  • Contacting a Contact From the People Peek

  • Understanding the Weather Bar


Experience and knowledge of a version of Microsoft Office prior to Office 2016 is essential for this course, including experience in manipulating Office files and creating documents, workbooks, presentations and emails.

Terms & Conditions

The supply of this course by DDLS is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.