Microsoft Excel 2016 Advanced

Welcome to the second part of our Microsoft Office Excel 2016 courseware. This version of Excel incorporates some new features and connectivity options in efforts to make collaboration and production as easy as possible. This course is intended to help all users get up to speed on the different features of Excel and to become familiar with its more advanced selection of features. We will cover how to create and use advanced formulas, analyze data, organize worksheet data with tables, visualize data with charts, insert graphics, and enhance workbooks.

 

By the end of this course users should be comfortable in creating advanced formulas, analyzing data with functions, analyzing data using functions and PivotTables, working with tables, visualizing data with charts, inserting graphics, and enhancing workbooks.

–

Prerequisites

 

This manual assumes the user has completed or has an understanding of the materials covered in the first part of the Microsoft Office Excel 2016 courseware, including:

Using absolute, relative, and mixed references

Using formulas and functions in a worksheet

Managing and organizing worksheets

Editing and formatting Excel data

Printing and saving Excel files

Customizing the Excel interface

 

Topics

 

Lesson 1: Creating Advanced Formulas

Lesson 2: Analyzing Data with Logical and Lookup Functions

Lesson 3: Organizing Worksheet Data with Tables

Lesson 4: Visualizing Data with Charts

Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts

Lesson 6: Inserting Graphics

Lesson 7: Enhancing Workbooks