Excel Basics - Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & More
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.