Save time by learning how to filter your spreadsheets to get to the data you need.
These days most of us have a ton of data that we find ourselves dealing with. This course will show you how to filter that data to get the exact records that you are looking for. Learn about the basic filter, how to apply a custom view, how to copy filter cells onto other worksheets using visible cells only, and advanced filters. Our speaker will also discuss slicers with formatted tables, slicers on PivotTables and filtering using Power Query.
Learning Objectives
- You will be able to review how to apply a filter.
- You will be able to identify identify timelines on PivotTables.
- You will be able to recognize recognize slicers with formatted tables.
- You will be able to review review filtering using Power Query.
Agenda
- Filter
- Custom View
- Visible Cells Only
- Advanced Filter
- Slicers With Formatted Tables
- Filters on Charts
- Subtotals
- Visible Cells Only
- Filters on PivotTables
- Slicers on PivotTables
- Timelines on PivotTables
- Filters on Conditional Formatting
- Filtering Using Power Query
Speakers
Tom Fragale,
Computer Trainer and Consultant ,
Tom FragaleTom Fragale is a computer professional with over 30 years experience. He has trained over 30,000 business people with online webinars, public seminars and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant and project manager on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks and SharePoint. His passion is training people and helping them get most out of their computers. He has written and published a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.
Who Should Attend
This live webinar is designed for business owners and managers, supervisors, associates, administrative professionals, analysts, bookkeepers and accountants.
