Overslaan naar inhoud
Cursusinhoud

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

Beoordeling
0 0

Er zijn momenteel geen reacties.

om als eerste een reactie achter te laten.