Excel 2013 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!