Excel is a strong tool for managing and analyzing long lists of data, as long as you know how to find what you need. This 60-minute Excel sort and filter training covers the tips and shortcuts for working with large worksheets.
You'll sort data, filter it with AutoFilter and custom filter techniques, and apply conditional formatting for quick analysis. You'll then sort and filter by the colors and icons conditional formatting creates, add, view and remove subtotals, and split complex data into separate columns so it sorts and filters cleanly.
Many people know the Excel basics; these tools help you get more from your data and work more efficiently.
Being efficient in Excel matters in many office jobs, and sorting, filtering and subtotals are some of the fastest ways to find the information you need in a large data set.
The session suits administrative assistants, managers, directors, sales, marketing, medical and legal professionals, teachers, students and anyone using Microsoft Office at work or school to create reports and presentations.
Being efficient in Excel matters in many office jobs, and sorting, filtering and subtotals are some of the fastest ways to find the information you need in a large data set.
The session suits administrative assistants, managers, directors, sales, marketing, medical and legal professionals, teachers, students and anyone using Microsoft Office at work or school to create reports and presentations.
Cathy Horwitz
Cathy Horwitz is a highly experienced Microsoft Office instructor, specializing in Excel, Word, PowerPoint, Outlook, and Access. With over 30 years of expertise in both in-person and online training, she has helped thousands of professionals boost productivity, streamline workflows, and master essential Microsoft Office skills.Cathy has been teaching Microsoft Office since its inception, offering tailored training programs that meet the unique needs of individuals and businesses. Her courses cover everything from Excel formulas, PivotTables, and automation with macros to Word document formatting, PowerPoint presentation design, and Outlook email management. Workshops from beginning level through advanced are available.Known for her engaging, …
NEW Nacha Rule - Third-Party Sender (TPS) Roles and Respons…
Paying and Receiving Payments for Referrals: You Can Go to …
FDA Technology Modernization Action Plan (TMAP) and Impact …
Human Factors Usability Studies Following ISO 62366 and FDA…
Validation Statistics for Non-Statisticians
Construction Lending And Real Credit Administration: Evalua…
Thriving in a Hybrid Workplace: Keys to Leadership and Team…
Excel Power Skills: Master Functions, Formulas, and Macros …
Discover how Emotional Intelligence turns AI from a technic…
Batch Record Review and Product Release
Tattoos, hijabs, piercings, and pink hair: The challenges …
Handbook Overhaul 2026: Compliance, OBBB Act & Beyond
Copilot and HR: An Introduction for HR Professionals
Female to Female Hostility @Workplace: All you Need to Know
ChatGPT for HR - Build HR Policy Framework and Strategy
Excel Spreadsheets; Develop and Validate for 21 CFR Part 11…
Major cGMP Issues: FDA Concerns in 2026
The Perfect Storm Coming to Healthcare: Value Based Care Me…
Fostering a Culture of Respect: Eliminating Gossip, Rumour…
Language is Code - Intro to AI - Generative AI - ChatGPT an…
Excel + AI: The Smart User's Guide to Faster, Easier Work w…
The Importance of the first 5 seconds when presenting
Managing Difficult Employee Conversations
ChatGPT and Project Management: Leveraging AI for Project M…
I-9 Audits: Strengthening Your Immigration Compliance Strat…
Pivot tables beginner to advanced + 20 advanced Pivot table…
Emotional Intelligence: Mastering the Emotions of Great Lea…
2026 Nacha Rules Changes (Part 1): Fraud Monitoring & Ops B…
Accounting For Non Accountants : Debit, Credits And Financi…
Medical Device Cybersecurity Following FDA’s 2026 Premarket…
Performance of Root Cause Analysis, CAPA, and Effectiveness…
Human Error Reduction Techniques for Floor Supervisors