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
-
6:28:56
The Charlie Kirk Show
11 hours agoObama On-Stage: The DNC, Night 2
196K263 -
LIVE
Jerry After Dark
17 hours agoJerry After Dark: Overnight Camping
3,220 watching -
2:27:20
The Quartering
11 hours agoLive DNC & Kamala Cringe Rally! Trump DESTROYS Woke Reporter, Kamala Tanks , RFK Joining Trump
106K80 -
6:23:04
Drew Hernandez
20 hours agoWATCH PARTY: DNC ROAST DAY 2
135K129 -
4:31:28
Due Dissidence
13 hours agoLIVE: DNC PROTESTS, DAY 2 - Workers Strike Back Rally w/ Jill Stein, Kshama Sawant, Nick Cruse
99.9K44 -
1:37:17
Kim Iversen
12 hours agoAbortion Activists Go Wild at the DNC: Abortion Pills & Free Vasectomies on Display
95.5K131 -
26:31
Michael Franzese
11 hours agoJoe Rogan doesn't HOLD BACK in Netflix Special
77.1K46 -
1:36:32
Glenn Greenwald
12 hours agoIs Kamala Harris "Working Tirelessly" for a Cease-Fire in Gaza?; Jonathan Turley on Free Speech; Richard Medhurst on his UK Arrest | System Update #318
124K117 -
2:21:37
WeAreChange
12 hours agoWARNING: DNC To Be Designated Monkeypox Spreader Event??
107K24 -
LIVE
Right Side Broadcasting Network
3 days agoLIVE: President Trump Delivers Remarks on Crime and Safety in Howell, MI - 8/20/24
3,468 watching