Completed
) Introduction
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel for Accountants - VLOOKUP & PivotTables - Complete Lessons from Basic to Advanced
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Why lookup is so common
- 3 ) Exact Match VLOOKUP to get Product Price & Data Validation Dropdown List
- 4 ) VLOOKUP & IFERROR Functions to build Invoice. Learn about Relative and Absolute (Locked) Cell References.
- 5 ) Approximate Match VLOOKUP to get Commission Amount. Discussion of importance of Number Formatting in Excel.
- 6 ) Approximate Match VLOOKUP to get Commission Rate. More about Number Formatting. Learn about General Number Formatting to wipe away all Number Formatting.
- 7 ) Approximate Match VLOOKUP to get Tax Amount
- 8 ) Approximate Match VLOOKUP add Helper Column to Payroll Data Set.
- 9 ) VLOOKUP & MATCH function to retrieve an Employee Record
- 10 ) VLOOKUP "Helper Column" to "Extend" Data Set for Complicated Reports. See 5 examples of Helper Columns to build complete Data Set for a PivotTable Report.
- 11 ) Introduction to PivotTables as the best tool to take data in a Proper Data Set and create Summary Reports that contain Calculations with Conditions or Criteria. Learn how to use Tabular Report Layo…
- 12 ) Create Cross Tabulated PivotTable Reports. This is a PivotTable Summary Report that has Calculations made with two Criteria.
- 13 ) Pivoting a PivotTable
- 14 ) Add Slicer to PivotTable. This is a PivotTable Summary Report that has Calculations made with three Criteria. Discussion about logic of criteria and how it applies to PivotTable.
- 15 ) Create PivotTable Reports for Large Data Sets on a New Sheet.
- 16 ) Grouping Dates by Year and Month
- 17 ) Using Show Values As to Create % Change Reports
- 18 ) PivotTable to show Total, Average, Min and Max Values for each Region
- 19 ) Summary of all 16 examples