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

) Introduction

1 of 19

1 of 19

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