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

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