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

This course takes a look at the new features in Microsoft Office Excel 2016. With some amazing and powerful new features, it is easier than ever to create professional, data-rich workbooks and spreadsheets.

The course examines some of the program’s new features, such as flash fill, the timeline slicer, improved ways of working with data and charts, and formatting those data and charts to better make sense of it all.

Use this course among your organization so employees can become more proficient Excel 2016 users.

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

Anyone switching to Excel 2016

• 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

• 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.

• Windows 8.1: Using Internet Explorer 11
• Windows 8.1: Other Windows 8.1 Features
• Windows 8.1: Using Windows 8.1 Security Features