Excel tables and tabular data

This is the agenda for Table of Contents
Table of Contents
 
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