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
Course
Approximate Cost
TBD
Format
Online
Duration
TBD
Total Credits
1