This course teaches learners how to utilize Excel's Table feature for various functions such as VLOOKUP, PivotTables, and creating charts. By the end of the course, students will be able to add new columns to Excel Tables, create lookup tables, and manage settings for dynamic ranges. The course focuses on practical examples and hands-on exercises to enhance understanding. This course is suitable for individuals looking to enhance their Excel skills, particularly in data analysis and visualization.
Excel Basics - Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & More
ExcelIsFun via YouTube
Overview
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.
Taught by
ExcelIsFun
