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

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.

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

Excel 2016 users

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

• Microsoft Office 2010 and Windows 7: What's New in Excel 2010?
• Microsoft Office 2010 and Windows 7: What's New in Office 2010?
• Microsoft Word 2010: Managing Lists