Course Description
This course will instruct students on the new features that have rolled out in Microsoft Office 2016. Office 2016 includes many new features, as well as enhancements offered in Office 2013. New elements will appear either as common changes across all offerings or within the individual applications. Students will review the common changes across the suite of products such as Tell Me, ink equations, new chart types, version history, and themes and review individual feature enhancements in Microsoft Word, Excel, PowerPoint, Outlook, and Access.
Instructor: Heather Walsh, Ed McCrae
Student data files are available under Downloads in the course dashboard.
What am I going to get from this course?
- Learn about the new features of Office 2016
- Use Co-authoring in Word
- Explore the new features in Excel
- Create a screen recording in PowerPoint
- Be more productive with Outlook
- Explore the new features of Access
Prerequisites and Target Audience
What will students need to know or do before starting this course?
Basic understanding of existing Microsoft Office features and functionality
Who should take this course? Who should not?
Students moving to Office 2016 and interested in the new features
Curriculum
Resource 1
Student Data Files
Module 2: Overview of Common Changes
Lecture 2
Using the Tell Me Feature
Lecture 3
Using Smart Lookup
Lecture 4
Applying the New Colorful Theme
Lecture 5
Working with Version History
Lecture 6
Working with New Chart Types
Lecture 7
Using Ink Equations
Module 3: New Features in Word
Lecture 8
Using Co-Authoring
Module 4: New Features in Excel
Lecture 9
Using the One-Click Forecast
Lecture 10
Searching in the PivotTable Field List
Lecture 11
Using Multi-Select with a PivotTable Slicer
Lecture 13
Using Get and Transform Power Queries
Lecture 14
Publishing and Sharing in Power BI
Lecture 15
Using Power View
Lecture 16
Working with PowerPivot Improvements
Module 5: New Features in PowerPoint
Lecture 17
Using Preset Styles for Shapes
Lecture 18
Creating a Screen Recording
Module 6: New Features in Outlook
Lecture 19
Working with Groups
Lecture 20
Working with Clutter
Lecture 21
Searching with Keywords and People Suggestions
Lecture 22
Working with Email Attachments
Module 7: New Features in Access
Lecture 23
Exploring the New Environment
Lecture 24
Exploring New Templates
Lecture 25
Exporting Linked Information to Excel
Lecture 26
Integrating with SharePoint 2016