Excel for Accountants - VLOOKUP & PivotTables - Complete Lessons from Basic to Advanced

Excel for Accountants - VLOOKUP & PivotTables - Complete Lessons from Basic to Advanced

Dive into a comprehensive 1 hour 33 minute seminar on Excel for accountants, focusing on VLOOKUP and PivotTables. Master essential skills from basic to advanced levels, including number formatting, keyboard shortcuts, and Excel efficiency tricks. Learn to create exact and approximate match VLOOKUPs, build invoices, handle commission calculations, and manage payroll data. Explore PivotTables for creating summary reports with multiple criteria, cross-tabulated reports, and data analysis techniques. Practice grouping dates, calculating percentage changes, and displaying various statistical measures. Download provided start and finished files to follow along with 16 detailed examples, enhancing your Excel proficiency for accounting applications.