Using Excel Tables To Enhance Managing And Analyzing Data
Human Resources
90 Minutes
Friday, June 16,2023
- Monday, July 31,2023
STA2023114
Overview
Learning how to efficiently use Excel is so critical in many of today’s office jobs. Many people know the Excel basics. This webinar will show you how to use the tools sort and filter in Excel, and subtotals to really help get the most out of your data, be more efficient, and find the information that you are looking for.
Who should attend?
- Administrative assistants
- Managers
- Directors
- Sales associates
- Students
- Teachers
- Marketing personnel
- Medical personnel
- Legal professionals
- Anyone using MS Office in a business or educational setting to create reports and presentations
Why should you attend?
Attend the webinar if you are using MS Office in a business or educational setting to create reports and presentations.
What you'll learn?
- Sort Data by a Single Column
- Sort Data by Multiple Columns
- Sort Data by Row
- Filter For Specific Data
- Custom Filter Text, Numbers, and Dates
- Save A Filter For Re-Use
- Subtotal Data
- Learn the Benefits of Tables
- Create and Modify Tables
- Format Tables with Styles
- Find Duplicate Table Records
- Summarize Table Data with a PivotTable
Speakers
Ms. Cathy Horwitz
Ms. Cathy Horwitz believes that when you know the capabilities of the software you use, you will demonstrate improved productivity, will be more efficient, and will be able to problem-solve more easily.
Cathy teaches classes on the Microsoft suite of application software including Excel, PowerPoint, Word, Access, and Outlook. Cathy has over 30 years of experience in the classroom and virtual training and has been an instructor of Microsoft Office since 1989.
Her strengths include customizing classes based on the needs of individual students and providing realistic business examples to complement the training. She is a high-energy trainer with a flair for training adult students.
She holds the Modern Classroom Certified Trainer certification from Logical Operations which prepares instructors for all aspects of delivering a course using the latest training technologies and approaches.
When not teaching, Cathy enjoys gardening, shopping estate sales, and refinishing mid-century furniture.
Choose Options
