Excel Data Management Essentials with Table Techniques

Join this webinar to learn how to set up data in correct format and to use key features to best manage and present your data.

Tables are a powerful Excel functionality to streamline many data management functions.

Think of a table as a defined set of rows and columns in a spreadsheet.

You can have multiple tables on the same sheet.

You might think that your data in an Excel spreadsheet is already in a table simply because it's in rows and columns. However, your data isn't in a true "table" unless you've used the specific Excel data table feature.

If PivotTables, and functions like VLOOKUP, SUMIF, etc. have challenged you with errors, then you may need to correct your data structure and format.

Areas Covered in the Session:

• Setup data correctly and effectively
• Sort data by columns
• Sort data by row
• Custom filter for text, numbers, and dates
• Save a filter for re-use
• Subtotal data
• Learn the benefits of tables
• Create and modify tables
• Learn how tables are named and why
• Add and delete data in a table
• Use tables to filter multiple lists on a worksheet
• Calculate filtered data in a table
• Keyboard shortcuts - Excel, general & web browser
• NOTE: Topic sequence may be subject to slight variation

• All MS Excel Users
• Account Executives
• Accountants
• Auditors
• Bookkeepers
• Business Owners
• Chief Executives
• Controllers
• CPA's
• Cybersecurity staff
• Database Administrators (DBA)
• Educators
• Trainers
• Engineers
• Financial Analysts
• Human Resource Personnel
• IT Professionals
• Managers
• Marketers
• New Recruits
• Project Managers
• Social Media Specialists
• Staff at all level
• Supervisors