Learn the most advanced features of Microsoft Excel in this training course. Once you've mastered the basics of building and organizing spreadsheets, you'll learn how to manipulate and visualize data to improve your workflow and extract deeper insights. In this course, you'll learn how to manage ...
Overview
Syllabus
- Advanced Cell Lock
- Hot Keys
- Go To Special
- Date Functions
- Adv Conditional Formatting
- Nested IFs
- If AND OR
- Goal Seek
- Data Tables
- Conditional Sumproduct
- Pivot Table Variances
- Pivot Calculations
- Pivot Charts
- Match Function
- Vlookup Match
- Index Match
- Index Double Match
- Windows
- Working Across Sheets
- Macros
- MacrosReport
- Consolidation
