Overview:
In this Level 3 or Advanced course, learn how PivotTables quickly summarize and analyze large volumes of business data. Use lookup functions to automatically look up data. Use many advanced tools and functions. Plenty of shortcuts and time-saving tips included.
Areas Covered in the Session:
- Use Names in Formulas
- Lookup Functions (Xlookup; 2 way lookups)
- PivotTablesÂ
- Data Tools (Drop Downs, Text to Columns, Remove Duplicates)
- Advanced Functions
- Protection Commands
- Shortcuts and Time-Saving tips
Who Will Benefit:
- Managers
- Business Professionals
- Administrative Personnel
- Legal Professionals