Introduction
Welcome
Structuring tabular data
• What We Will Cover
• The Importance of Tabular Data
• Structuring Tabular Data
• Cleaning Up Payroll Data - Part 1
• Cleaning Up Payroll Data - Part 2
• What Have We Done
Working with tabular data
• Mining and Formatting Data - Part 1
• Mining and Formatting Data - Part 2
• Mining and Formatting Data - Part 3
• Mining and Formatting Data - Part 4
• Using Data for Different Information - Part 1
• Using Data for Different Information - Part 2
• Filtering for Specific Information
• What Have We Done
Removing duplicates to drill down data
• Extracting Pay Rates
• What Have We Done
Naming ranges
• Using Named Ranges in Formulas - Part 1
• Using Named Ranges in Formulas - Part 2
• Using Named Ranges in Formulas - Part 3
• Using Named Ranges in Formulas - Part 4
• Calculating Inventory Totals
• What Have We Done
Lookup functions- VLOOKUP(): Approximate matches
• How Are Excel Tables Different?
• Working With Excel Tables
• Creating Excel Tables
• Resizing and Structured Table Referencing
• Table Styles
• Populating the Inventory Sheet
• Advanced Table Lookups - Part 1
• Advanced Table Lookups - Part 2
• What Have We Done
• Dashboard Overview
Conclusion
• In Review
• Conclusion
Final Quiz