Building Amazing Organizations
Got Questions?
800‑258‑3837
Back to Course List

What's New in Microsoft Office 2016: Working With Excel 2016

Preview video
Preview Video
Course Format
Video on Demand  Video On Demand
Product ID
sonimo16ex_vod
Training Time ?
24 to 33 minutes
Language(s)
English
Video Format
High Definition
Required Plugins
None
Number of Lessons
8
Quiz Questions
9
Closed Captioning
Question Feedback
Wrong Answer Remediation
Lesson Bookmarking
Downloadable Resources
Interactive Producer
Mastery Training Content Network
Original Content Producer
Sonic Performance Support GmbH
Course screen Course screen Course screen
Overview

Microsoft Office Excel 2016 comes with some extremely powerful new features to increase the efficiency and productivity of your work.

This course discusses and demonstrates these new features, such as working with templates, flash fill, data and chart manipulation and formatting, and the timeline slicer.

Use this course among your employees so everyone, especially the number and data gurus, can enjoy the benefits of the Excel 2016 update and create workbooks that are rich with functionality and look good too.

Video on Demand   This course is in the Video On Demand format, to read about Video On Demand features click here.

  • Install on any SCORM LMS
  • Full-screen video presentation
  • Print certificate and wallet card
  • You have 60 days to complete the course
Audience

Excel 2016 users

Topics
The course presents the following topical areas:
  • Introduction
  • Select a Template in Excel
  • Update Data with Flash Fill
  • Insert and Format a Chart
  • Analyze Data
  • Add Conditional Formatting to Data with Quick Analysis
  • Add a Timeline Slicer
  • Drill Deeper into your Data
Intended Performance Outcomes
Upon successful completion of this course you will be better prepared to:
  • Streamline workflow in Excel using templates.
    • Recall the advantages of using Excel templates.
  • Accelerate data entry with Flash Fill.
    • Differentiate between FlashFill and Auto Fill.
  • Incorporate charts.
    • Recall how to create a clustered column chart.
    • Locate the Chart Filters button.
    • Identify the features of the Chart Filters button.
    • Recall formatting options available with the Add Data Callout feature.
  • Add conditional formatting to data with Quick Analysis.
    • Identify the functions of the Quick Analysis button.
  • Add a timeline slicer.
    • Locate the Timeline slicer feature.
  • Drill deeper into your data.
    • Locate the buttons to zoom in and out of various views of data.

© Mastery Technologies, Inc.