MS Excel: Demystifying the Sort and Filter Tools

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.