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
Resolve the captcha to access the links!