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

Highlights

Our Firm Directory allows you to search for Canadian CPA firms using our interactive map as well as other criteria.

Jointly presented by CPA Canada and CPA Ontario, The ONE is the must-attend, multi-track event of the year, designed for all CPAs who want to be at the top of their game.