Excel Filter Basics (for quick data analysis)
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
Видео Excel Filter Basics (for quick data analysis) канала Leila Gharani
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
Видео Excel Filter Basics (for quick data analysis) канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Advanced Excel Filter (And, Or, Between conditions for criteria range)](https://i.ytimg.com/vi/VqQACB_69SQ/default.jpg)
![3 Cool Effects You Did NOT Think are Possible in PowerPoint | Morph](https://i.ytimg.com/vi/nzH4KPz_cIs/default.jpg)
![Don't Use Excel Filters! Use This Incredible Excel Formula Instead ...](https://i.ytimg.com/vi/Qi1nfN5F8F4/default.jpg)
![Pivot Table Excel Tutorial](https://i.ytimg.com/vi/m0wI61ahfLc/default.jpg)
![Excel shortcut keys you SHOULD know!](https://i.ytimg.com/vi/Xe4U_-o_EWw/default.jpg)
![Embarrassing Microsoft Teams Meeting Mistakes: What NOT TO DO!](https://i.ytimg.com/vi/6qQ24RfRedc/default.jpg)
![Learn Pivot Tables in 6 Minutes (Microsoft Excel)](https://i.ytimg.com/vi/qu-AK0Hv0b4/default.jpg)
![How to Filter in Microsoft Excel](https://i.ytimg.com/vi/BtiVbY7lhqw/default.jpg)
![Excel Header & Footer (& Quickly Copy to other Sheets)](https://i.ytimg.com/vi/Q6b315vRNrg/default.jpg)
![Calculate Percentages the Right Way in Excel (% Change & Amount after % increase)](https://i.ytimg.com/vi/UN5PckRADyQ/default.jpg)
![SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)](https://i.ytimg.com/vi/evrnIuDRtsQ/default.jpg)
![Excel for Accounting - 10 Excel Functions You NEED to KNOW!](https://i.ytimg.com/vi/m_SH0TOLsIc/default.jpg)
![Consolidate & Clean Multiple Excel Sheets in One Pivot Table](https://i.ytimg.com/vi/FI4HkCzMaIk/default.jpg)
![Excel FILTER Function TRICK for Non Adjacent Columns](https://i.ytimg.com/vi/Onudkw9DMlU/default.jpg)
![Excel Conditional Formatting with Formula | How to Get it RIGHT Every Time](https://i.ytimg.com/vi/XHT4paRaY4g/default.jpg)
![MS Excel - Filtering Data](https://i.ytimg.com/vi/JNZqRYkgZ4c/default.jpg)
![Your Excel Printing Problems, Solved!](https://i.ytimg.com/vi/SZBRFRoGSFY/default.jpg)
![How to Create & Use Excel Macros (Real world example)](https://i.ytimg.com/vi/An-2Nxf_Dms/default.jpg)
![Excel SUMIFS (better version of SUMIF), COUNTIFS & AVERAGEIFS (Multiple Criteria)](https://i.ytimg.com/vi/AZuBNWMh7VM/default.jpg)
![5 Excel Functions YOU NEED in 2021](https://i.ytimg.com/vi/_EWcAR_Hkvg/default.jpg)