MGMT X422.11

Business Applications of Excel: 2

Lookup Functions, Macros and Programming, and Pivot Tables


Whether Excel is a daily part of your business or just occasionally used for a quick spreadsheet project, users often find themselves spending hours trying to answer the question, “I know there’s a way to do this in Excel, but how?” Become a more efficient Excel user and learn the most powerful features that the program has to offer in this one-day, advanced course. Highly interactive and hands-on, you will spend the entire time using Excel while an expert trainer walks you through demonstrations and exercises. Topics include:

  • Lookup Functions and their Limitations

  • Advanced Lookup Functions (How to Get Around Those Limitations)

  • Pivot Tables

  • Pivot Charts

  • Macros

  • VBA

  • Code Writing

  • Data Validation
Icon
Course
Approximate Cost TBD
Format Online
Duration TBD
Total Credits 1