Intermediate Microsoft Excel 2016

Audience profile
This course is intended for students who have little or no familiarity with Microsoft Excel
2016 or more experienced Excel users who want to learn the topics covered in this course in
the 2016 interface.

Skill gained
 Learn to use formulas and functions.
 Create and modify charts.
 Convert, sort, filter, and manage lists.
 Insert and modify illustrations in a worksheet.
 Learn to work with tables.
 Learn to use conditional formatting and styles.

Prerequisites
 Basic Excel experience

Course Outline
Module 1: Advanced Formulas
This module explains how to work with formulas.
Module 2: Working with Lists
This module explains how to work with lists.
Module 3: Working with Illustrations
This module explains how to work with illustrations.
Module 4: Visualizing Your Data
This module explains how to work with charts, objects, and text boxes.
Module 5: Working with Tables
This module explains how to work with tables.
Module 6: Advanced Formatting
This module explains how work with formatting options in Excel.
Module 7: Microsoft Excel Features that Were New in 2013
This module explains how to use some features that were new in 2013.
Module 8: Features New in 2016
This module explains how to use the new charts in 2016.