Excel 2016 Advanced - Half Day Class Personalize our class outlines. We'll create a class just for you.

Printable Version  |  See Other Class Topics  |  See All Class Outlines


Overview

Upon successful completion of this course, students will be able to:

  • Create macros to automate tasks 
  • Collaborate with others using workbooks 
  • Audit worksheets
  • Analyze data using PivotTables and Slicers 
  • Import data

Class Content

Lesson 1: Streamlining Workflow

  1. Creating a Macro 
  2. Editing a Macro 

Lesson 2: Collaborating with Others

  1. Protecting Worksheets 
  2. Sharing a Workbook 
  3. Adding Data Validation

Lesson 3: Troubleshooting Functions & Formulas

  1. Error Checking 
  2. Using Precedents & Dependents 
  3. Evaluating Formulas 

Lesson 4: Analyzing Data

  1. Creating a PivotTable 
  2. Populating a PivotTable with Fields 
  3. Customizing a PivotTable with the Timeline Filter and Quick Explore
  4. Working with Slicers 
  5. Updating Source Data 

Lesson 5: Importing and Updating Data

  1. Importing Data from a File or Database 
  2. Importing Data from a Web Page 
  3. Updating Imported Data

Have a Question?

Give us a call at (888) 572-1200 or contact us for fast attention.

Get in touch!