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.
From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs.
Track Record
30 years driving innovative, award-winning learning solutions
More Courses, More Often
When you train with DDLS you get more courses, more often, in more locations and from more vendors.
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.
Train Anywhere
From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs.
Track Record
30 years driving innovative, award-winning learning solutions
More Courses, More Often
When you train with DDLS you get more courses, more often, in more locations and from more vendors.
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.
Train Anywhere
From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs.
Track Record
30 years driving innovative, award-winning learning solutions
More Courses, More Often
When you train with DDLS you get more courses, more often, in more locations and from more vendors.
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 on 1800 U LEARN (1800 853 276).
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
Prerequisites
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.
