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

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

ExcelIsFun via YouTube Direct link

) Introduction

1 of 12

1 of 12

) 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. 1 ) Introduction
  2. 2 ) Example 1: Excel Table feature for VLOOKUP & Data Validation List
  3. 3 ) Example 2: Excel Table feature for Chart
  4. 4 ) Example 3: Excel Table feature for PivotTable
  5. 5 ) Example 4: Excel Table feature for Other Formulas
  6. 6 ) Example 5: Add New Column to an Excel Table AND Create Approximate Match Lookup Table from a written statement.
  7. 7 ) Create Approximate Match Lookup Table from Written Instructions
  8. 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. 9 ) Add columns to Excel Tables with Table Formula Nomenclature with Relative and Absolute References.
  10. 10 ) Formula for Discounts when we need to calculate Net Revenue based on a Discount.
  11. 11 ) Add new records to bottom of Excel Table and Formulas will automatically populate down
  12. 12 ) Summary - Conclusion

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.