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
-
57:58
The Rubin Report
1 hour agoDebate over COVID Failures Gets Tense | Chris Cuomo
7.43K24 -
LIVE
Steven Crowder
3 hours agoREBUTTAL: Jon Stewart is WRONG about Gun Violence
21,232 watching -
2:10:55
Matt Kohrs
3 hours agoStocks Are EXPLODING HIGHER, Nvidia is King & GameStop is Falling
29K6 -
1:28:50
Graham Allen
4 hours agoMega Church Pastor Forced to RESIGN! + Ten Commandments Back in Schools🔥
32.4K86 -
44:57
Rethinking the Dollar
1 hour agoGOP WANTS $500 BILL TO HONOR TRUMP | SIGNS OF GREATER INFLATION TO COME? | Morning Check-In w/ Mike
6.23K2 -
1:36:11
The Podcast of the Lotus Eaters
7 hours agoThe Podcast of the Lotus Eaters #941
42.1K30 -
1:17:47
jeffahern
3 hours agoThursday Thrash With Jeff Ahern (6am Pacific)
23K3 -
2:05:19
AP4Liberty
4 hours agoBorder Wars Breakout Between Kansas and Missouri... Again!
26.4K2 -
19:28
Stephen Gardner
10 hours ago🔴BREAKING: Biden’s RECKLESS new scheme fails with the PEOPLE!!
37.8K85 -
1:03:16
Kimberly Guilfoyle
3 days agoSlow Joe Hits a New Low, Plus New Case of Illegal Immigrant Crime, Live with Karoline Leavitt & Sen Tommy Tuberville | Ep. 134
103K92