Loading...

Course Description

In this course, you really see the power of Excel at work and become more efficient and productive crunching numbers with VLOOKUPS, pivot tables, IF functions, data manipulation and template building.

Course Outline

This class covers:

4 hours of VLookups

4 hours of Pivot Tables

4 hours of customized content: IF Statements, Data Manipulation and Template building.

Learner Outcomes

Upon completion of this training, participants will be able to:

  • Use advanced formulas including VLOOKUP and HLOOKUP
  • Create and interpret Pivot Tables
  • Use Conditional Logic Functions with IF
  • Use best practices for data manipulation
  • Create easy to use templates


 

Prerequisites

Intermediate level of knowledge in Excel.

Recommendations

Each participant should have their own device, access to internet and access to Office 365.
Loading...
Please call our Customer Service Center at 704.330.4223 for information on the next available section.
Required fields are indicated by .