MS Excel: Demystifying the Sort and Filter Tools

Duration: 60 minutes

Anyone who touches MS Excel should master at least one process: how to efficiently sort and filter data. At its core, that’s what Excel was designed to do. And for many users, that’s all they really need.

This webinar will help you understand the full scope of sorting and filtering tools and show you how to use them to save countless hours of time. (more details below)


WHY ATTEND

The ability to manage data is becoming more important than ever in today’s workplace. Data is everywhere and touches almost every level of most organizations. Those who master the ability to gather and digest data into meaning information get ahead. Those who don’t struggle to keep up.

The starting point for most is to figure out how to effectively Sort and Filter. The good news is, Excel offers a suite powerful tools to help you get that done. Unfortunately, many users don’t fully understand how to best use these tools. They know one way of crunching their data and spend hours on a task that should take minutes.

This 60-webinar event will give you practical, easy-to-understand guidance on what you really need to know to master this critical application of Excel.

LEARNING OBJECTIVES

Our Excel expert Cathy Horwitz will reveal a host of tools and tricks including how to:

  • Format data lists for optimum data management
  • Sort data in a worksheet
  • Filter data with AutoFilter
  • Use custom filter techniques
  • Apply conditional formatting for quick analysis
  • Sort and filter using colors and icons from conditional formatting
  • Create, view, and remove Subtotals
  • Split complex data into separate columns for ideal filtering and sorting

ABOUT THE SPEAKER

Cathy Horwitz has over thirty years of software training and support experience in the personal computer market. She has a broad professional background including curriculum development as well as training to corporate clients, end users, retailers, legal firms and distributors. She has been training as an independent consultant since 1993 teaching basic, intermediate and advanced Microsoft Office desktop applications, including: Word, Excel, PowerPoint, Access and Outlook.

What You Get With Each Option

Live Recording

Live Only

Participation in the live upcoming webinar

Recording

Recording Only

Full MP4 recording of webinar, including Q&A. Choose digital download or CD-ROM by mail.

Live and Recording

Live + Recording

Participation in the live webinar + Full MP4 Recording. For recording, choose digital download or CD-ROM by mail.

Event Package

Event Value Pack

Participation in the live webinar + Full MP4 Recording + Audio-only MP3 recording. For recordings, choose digital download or CD-ROM by mail.

What You Get With Each Option close

Live Recording

Live Only

Participation in the live upcoming webinar

Recording

Recording Only

Full MP4 recording of webinar, including Q&A. Choose digital download or CD-ROM by mail.

Live and Recording

Live + Recording

Participation in the live webinar + Full MP4 Recording. For recording, choose digital download or CD-ROM by mail.

Event Package

Event Value Pack

Participation in the live webinar + Full MP4 Recording + Audio-only MP3 recording. For recordings, choose digital download or CD-ROM by mail.

About Webinar Connections close

Each purchase is for ONE computer to access the session.
A group may participate in a room together as long as only 1 computer is logged in.
If you need more than one computer to access the webinar, please call customer service at 888-479-2777.
A charge will apply for each connection.