Making your Excel Spreadsheet much Easier to use with Tables
Join this live webinar to learn how to set up data in the correct format and to use key features to best manage and present your data.
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
Who Will Benefit:
- 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
Speaker Profile
Backed by Microsoft certifications, he teaches more than 2,500 topics across Artificial Intelligence, Copilot, ChatGPT, DeepSeek, Excel, Access, Outlook, Project, PowerPoint, Word, Visio, and Publisher.
He also holds qualifications in Frontline Management, Accounting, Training and Assessment, and is certified in Six Sigma business-improvement methodology. Since 1990, Ray has trained over 40,000 students, business owners, and executives and authored extensive training and procedural documents, complex reports, and engaging web content-demonstrating strong communication skills and exceptional knowledge transfer.
To provide the best learning and knowledge retention experience for attendees, Ray’s unique and engaging webinars replicate the in-person classroom experience and include:
A comprehensive step-by-step Learning Guide
Demonstrations and practical exercises
Exercise files; and
Productivity techniques