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

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

ExcelIsFun via YouTube Direct link

) 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.

14 of 19

14 of 19

) 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.

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. 1 ) Introduction
  2. 2 ) Why lookup is so common
  3. 3 ) Exact Match VLOOKUP to get Product Price & Data Validation Dropdown List
  4. 4 ) VLOOKUP & IFERROR Functions to build Invoice. Learn about Relative and Absolute (Locked) Cell References.
  5. 5 ) Approximate Match VLOOKUP to get Commission Amount. Discussion of importance of Number Formatting in Excel.
  6. 6 ) Approximate Match VLOOKUP to get Commission Rate. More about Number Formatting. Learn about General Number Formatting to wipe away all Number Formatting.
  7. 7 ) Approximate Match VLOOKUP to get Tax Amount
  8. 8 ) Approximate Match VLOOKUP add Helper Column to Payroll Data Set.
  9. 9 ) VLOOKUP & MATCH function to retrieve an Employee Record
  10. 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. 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. 12 ) Create Cross Tabulated PivotTable Reports. This is a PivotTable Summary Report that has Calculations made with two Criteria.
  13. 13 ) Pivoting a PivotTable
  14. 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. 15 ) Create PivotTable Reports for Large Data Sets on a New Sheet.
  16. 16 ) Grouping Dates by Year and Month
  17. 17 ) Using Show Values As to Create % Change Reports
  18. 18 ) PivotTable to show Total, Average, Min and Max Values for each Region
  19. 19 ) Summary of all 16 examples

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.