Overview:

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, then your data may need to correct your data structure and format.

Why Should You Attend:
Join this webinar to learn how to set up data in the correct format and to use key features to best manage and present your data.

To gain a practical "hands-on" understanding of mastering data & information in formal tables in MS Excel with confidence, knowledge, and consistency.

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

• Anyone seeking to significantly boost profits
• Competitive Advantage
• Productivity
• Job Satisfaction, and effective use of their technology
• This webinar is for students with foundational knowledge and skills in Excel who wish to take advantage of the higher-level functionality of Excel