Premium Only Content
![Excel Filter Basics (for quick data analysis)](https://1a-1791.com/video/s8/1/4/5/Q/m/45Qmk.qR4e.1-small-Excel-Filter-Basics-for-qui.jpg)
Excel Filter Basics (for quick data analysis)
Mar 1, 2018 Excel Introduction - Learn Excel Basics
Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials
Find out how to filter your data in Excel. In this filter basics tutorial you'll learn the following:
1. The shortcut key to turn filter on and off in Excel
2. How to do approximate matches (filter for words that contain a specific word)
3. How to filter multiple columns
4. How to filter for "or" conditions
5. How to copy a filtered range to another sheet
6. How to use formulas (such as subtotal) to sum a filtered range
7. How to filter for values between 2 dates
8. How to filter based on color
9. How to turn your data set into an Excel table (shortcut key)
10. How to add totals to your Excel table
🡻 Download the workbook here 🡻
http://www.xelplus.com/excel-filter-basic-to-advanced/
★★ Links to related videos: ★★
Check out my Excel Basics Playlist here: https://www.youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0
★ My Online Excel Courses ★
Courses ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
-
52:40
Candace Show Podcast
2 hours agoSaturday Night Lively: What Were They Thinking? | Candace Ep 148
45.7K30 -
LIVE
Revenge of the Cis
3 hours agoEpisode 1449: Boo This
2,061 watching -
1:20:31
Awaken With JP
3 hours agoWiping Hard Drives, Hire a Criminal Defense Lawyer - LIES Ep 79
44K27 -
1:02:23
In The Litter Box w/ Jewels & Catturd
20 hours agoDEI Kills | In the Litter Box w/ Jewels & Catturd – Ep. 744 – 2/18/2025
39.2K24 -
LIVE
Game On!
2 hours agoBreaking Down COLLEGE BASKETBALL BETTING LINES Like a Pro!
78 watching -
LIVE
John Crump Live
5 hours agoMexico Backs Cartels By Threatening To Designate Gun Manufactures As Terrorist!
252 watching -
LIVE
The Nunn Report - w/ Dan Nunn
2 hours ago[Ep 611] DOGE On The March! | Guest Sam Anthony - [your]NEWS | Seditious Dems | Ukraine
497 watching -
1:00:56
The Tom Renz Show
8 hours agoThe War On DOGE Is ALSO A War On The Economy
4.95K5 -
1:30:16
Steve-O's Wild Ride! Podcast
5 days ago $0.84 earnedAri Shaffir Exposes The Dark Side of Podcasting - Wild Ride #252
11.3K1 -
1:56:29
The Quartering
6 hours agoAirplane FLIPS and CRASHES, Sean Duffy Slams Pete Buttigieg, & What Happened with Patriarchy Hannah
78K30