Completed
) Introduction
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Basics - Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & More
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Example 1: Excel Table feature for VLOOKUP & Data Validation List
- 3 ) Example 2: Excel Table feature for Chart
- 4 ) Example 3: Excel Table feature for PivotTable
- 5 ) Example 4: Excel Table feature for Other Formulas
- 6 ) Example 5: Add New Column to an Excel Table AND Create Approximate Match Lookup Table from a written statement.
- 7 ) Create Approximate Match Lookup Table from Written Instructions
- 8 ) 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 Co…
- 9 ) Add columns to Excel Tables with Table Formula Nomenclature with Relative and Absolute References.
- 10 ) Formula for Discounts when we need to calculate Net Revenue based on a Discount.
- 11 ) Add new records to bottom of Excel Table and Formulas will automatically populate down
- 12 ) Summary - Conclusion