Excel Basics - Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & More

This course demonstrates how to convert spreadsheet data into Excel Tables and use them to create dynamic ranges for VLOOKUP, data-validation lists, charts, PivotTables, and formulas. It also covers approximate-match lookup tables, calculated discount columns, table naming, references, and automatic expansion when records or columns are added.

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.