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

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Learn how to leverage the Excel Table feature for dynamic ranges in VLOOKUP, PivotTables, charts, and more in this comprehensive 37-minute video tutorial. Explore practical examples demonstrating the power of Excel Tables for data validation lists, charts, PivotTables, and various formulas. Discover how to add new columns to Excel Tables, create approximate match lookup tables from written instructions, and modify settings to automatically include new rows and columns. Master table formula nomenclature with relative and absolute references, and learn to calculate net revenue based on discounts. Gain valuable insights into automating formula population for new records added to the bottom of Excel Tables. Download accompanying files and written notes for hands-on practice and reinforcement of concepts covered in this Highline College Business 216 class taught by Michael Girvin.

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.