The Power of Pivot Tables and Lookups: Extracting Deeper Intelligence with Excel
- Duration
- 3 hours
- Starting Price
- Contact us for pricing
Organizations depend on business intelligence for strategic success. This course teaches advanced Excel users how to leverage pivot tables and lookup functions for data analysis and competitive advantage.
Course Outline
1 - Extracting Information from Worksheets Using Pivot Tables
- Aggregate Functionality and Data Assembly
- Slicer Feature Filtering
- Creating Multiple Tables from Single Worksheets
- Chart Creation and Filter Application
- Basic Report Generation Using Pivot Tables
2 - Finding Information Using Lookups
- Comparing Lists for Differences
- Traditional and New Lookup Functions
- Excel Options Optimization
- Lookup Function Variations
Upcoming Sessions
There are no scheduled sessions for this course right now.
Interested in this course?
No sessions are currently scheduled. Let us know you're interested and we'll reach out to plan one with you.