Excel Basics - Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & More
ExcelIsFun via YouTube
Overview
Syllabus
) Introduction.
) Example 1: Excel Table feature for VLOOKUP & Data Validation List.
) Example 2: Excel Table feature for Chart.
) Example 3: Excel Table feature for PivotTable.
) Example 4: Excel Table feature for Other Formulas.
) Example 5: Add New Column to an Excel Table AND Create Approximate Match Lookup Table from a written statement..
) Create Approximate Match Lookup Table from Written Instructions.
) Change Settings to Allow Columns and Rows to be added to Excel Table as you work: Excel File, Options, Proofing, AutoCorrect, Auto Format As You Type, “Apply As You Work” – “Include New Rows and Columns in Table”.
) Add columns to Excel Tables with Table Formula Nomenclature with Relative and Absolute References..
) Formula for Discounts when we need to calculate Net Revenue based on a Discount..
) Add new records to bottom of Excel Table and Formulas will automatically populate down.
) Summary - Conclusion.
Taught by
ExcelIsFun