Excel: Filtering Data for Beginners

Excel: Filtering Data for Beginners
Excel: Filtering Data for Beginners
English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 0h 29m | 98 MB

Did you know Excel enables you to zero in on exactly the data you need with the click of a mouse? In this short course, Microsoft Excel content publisher Dave Ludwig shows the ins and outs of filtering in Excel. He shows how to filter for text, numeric values, and ranges of data. Dave also shows how to filter with color coding, and how to use advanced filtering options such as slicers and shortcuts. Advance your Excel skills in minutes with this mini course.

Table of Contents

Introduction
1 Zero in on the right data with filters in Excel
2 What you should know

Basic Filter Concepts
3 What is a filter
4 Types of filters

Refining Filters
5 Custom filters
6 Advanced filters
7 Filter for unique values
8 Filter with a formula

Filtering Tips
9 Use slicers to filter
10 Use Power Query to filter
11 Shortcut keys for filtering

Conclusion
12 Next steps


Download from Rapidgator

Download from Turbobit