Loading...

Course Overview

This course will begin with the creation of PivotTables with features including calculated fields, Slicers and Timelines, Functions in Lists, special IF functions, Advanced Filters, Formula Auditing, Lookup Formulas, linked formulas, protected workbooks, templates, and macros will complete the course.
 
Key Topics:
  • PivotTables, Slicers, Timelines and Calculated Fields in PivotTables
  • Functions in Lists: IF, SumIF, CountIF, SumIFs, CountIFs, and Formula Auditing
  • Lookup Formulas for internal and external data
  • Protect workbook formulas and create Excel templates
  • Text functions for imported data 
  • Macro basics and the VBA Editor
Takeaways:
  • PivotTables with tools such as Slicers and Timelines
  • Special IF functions and formula trouble-shooting
  • Create Lookup functions for internal and external data
  • Apply text functions for imported data
  • Build a basic macro and edit in the VBA Editor

Prerequisites

  • Participants should be familiar with Excel commands, spreadsheet design, creating formulas and using functions. 
  • Participants who are most successful in this course will be those who use Excel on a regular basis to accomplish routine tasks in their job or business.
Loading...
Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.

Course Materials

All course materials will be provided electronically.

Policy Information

View registration, refund and cancellation policies

Advisory Board

Course curriculum is developed in consultation with our Professional Development Advisory Board of subject matter experts, faculty, and industry practitioners.

Required fields are indicated by .