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,
The PC Guy, Inc.- Computer professional with over 30 years of professional experience
- Microsoft® Certified Trainer, Microsoft® Certified Office Master, Microsoft® Certified Expert in Word® and Excel®, and a Microsoft® Certified Specialist in Access®, Outlook®, and PowerPoint®
- Trained over 30,000 business people in online webinars, public seminars, and onsite training
- Clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including insurance, manufacturing, banking, pharmaceutical, education, and retail
- Topics of expertise include Access®, Excel®, Word®, PowerPoint®, Outlook®, Crystal Reports, SQL Server, Visio®, QuickBooks®, and SharePoint®, among others
- His passion is training people and helping people get the most out of their computers
- A published author, having written a book on Microsoft® Access®
- B.A. degree in computer science, LaSalle University
Who Should Attend
This live webinar is designed for business owners and managers, supervisors, associates, administrative professionals, analysts, bookkeepers and accountants.
