Event Description
Topics include:
• Pivot Tables & Pivot Charts
• Advanced Functions: VLOOKUP, HLOOKUP, Nested IF, AND, OR, INDEX, MATCH
• Filtering with Subtotals
• Hyperlinking Your spreadsheets
• Macros inc Overview of Excel VBA
• Custom Views
• 3D Ranges
• Working with Tables & DAX