Sort, Filter and View Data in Excel Webinar
Sort, Filter and View Data in Excel Webinar
This webinar focuses on sorting and filtering data in Excel. Sorting is the process of ordering all data in a specified range by single or multiple criteria. Filtering is distinct from sorting in an important way. Filtering takes user-specified criteria and returns only those records that match those parameters. Both features play an important role in organizing and displaying your data.
In this session you will learn how to perform both single and multi-level sorting. You will learn about subtotals, an amazing tool that takes your sorted data and automatically builds subtotals and grand totals within your data range. We’ll go from basic sorting and filtering must know, to intermediate topics the address conditional formatting as well as adding a Slicer that will let you quickly display filtered data with a simple click.
Duration: 45-minutes + Q & A
Core Objectives
• Perform single and multi-level sorts
• Create and Remove subtotals
• Create nested subtotals
• Using find and filter
• Introduction to conditional formatting
• Building a data slicer
Presenter Jonathan Hood:
Jon is a Microsoft Certified Professional (MCP) and a recognized expert in Microsoft Word and Office 365. Jon provides hands-on training for the entire Microsoft Office Suite in various delivery formats for KnowledgeWave clients across North America. With a special focus on SaaS applications like Google Apps and Microsoft Office 365, Jon excels at the opportunity to provide customized training experiences that engage our clients. His experience and expertise with the collaboration options in Office 365 and SharePoint, along with his strong ability to provide knowledge transfer helps those he teaches feel an immediate return on their training or coaching investment. Jon embraces the evolution of technology, has delivered hundreds of live webinars and is a regular contributor to the KnowledgeWave blog with first-to-press topics related to increasing end-user productivity and efficiency.
Jon provides support and training for various forms and document management solutions, from Adobe Acrobat and eCopy to SharePoint and other ECM solutions. Further rounding out Jon’s teaching abilities is his expertise with the Adobe Creative Cloud Suite. With top-notch skills for teaching, coaching and consulting Jon has recently provided services for Northern Trust Company, Mitsui Co., IKEA, Department of Homeland Security, Eastern Quality Foods, Malian Institute, Senior Solutions of Vermont, and the State of Vermont.