What is the use of Sort and Filter in Excel | How to use Filter in Excel | Excel Filter Shortcut Key
Hello My Dear friends,
I am 💻Pintu Kushwha💻
⏳Video Time Table⏳ :-
⏰00:20 First Tricks of using filter
⏰01:28 Second Tricks of using filter
⏰02:58 Excel Filter Shortcut Key
Filter Shortcut Key CTRL+SHIFT+L
🎬Most Popular Advanced Excel Playlist Visit🎬 : -
🔊 https://www.youtube.com/watch?v=-GJJ0tdC2VM&list=PLziuwbso1iLTRahrPR2Ivvx1AEMb6hQ_e
Video Explanation : -
◼️ When you use the filter and sort option on an excel spreadsheet, it allows you to narrow down a large spreadsheet to show just the information you are wanting to see. Use filters to temporarily hide some of the data in a table, so you can focus on the data you want to see.
▪️Filter a range of data
▪️Select any cell within the range.
▪️Select Data Filter.
▪️Select the column header arrow Filter arrow .
▪️Select Text Filters or Number Filters, and then select a comparison, like Between.
▪️Enter the filter criteria and select OK.
◼️ Filter data in a table
▪️When you Create and format tables, filter controls are automatically added to the table headers.
▪️Select the column header arrow Filter drop-down arrow for the column you want to filter.
▪️Uncheck (Select All) and select the boxes you want to show.
▪️Click OK.
◼️ The column header arrow Filter drop-down arrow changes to a Applied filter icon Filter icon. Select this icon to change or clear the filter.
✔️To become expert in Microsoft Excel you need to subscribe my channel (Advanced Excel) you will find awesome Excel Features, Functions, Formulas, Tips and Tricks
✔️We always provide useful content on the my Advanced Excel Channel, Here Microsoft Excel Useful Information
📔Keep Watching and Keep Learning📔
✔️Language :- Hindi
Social Media Link:-
**************************************************************
▪️Facebook (Persnoal Account)
Link:- https://www.facebook.com/pintukushwha.kushwha
▪️Instagram (Personal Account)
Link:- https://www.instagram.com/pintukushwahakushwaha/
▪️Facebook Page (Advanced Exce)
Link:- https://www.facebook.com/Advanced-Excel-103781865299796
**************************************************************
💠 Video Related as :-
➡️ Advanced Excel
➡️ How to use Filter in Excel
➡️ Excel Filter Drop Down
➡️ How to Filter Data in Excel
➡️ Excel Filter Shortcut Key
➡️ Use of Sort and Filter in Excel
➡️ Excel Filter Formula
➡️ Excel me Date Wise Filter Kaise Kare
➡️ What is Filter in Excel
➡️ Filtering in Excel
➡️ How to Filter in Excel in Hindi
➡️ Excel Advanced Filter
➡️ How to Create Filter in Excel
➡️ How to Create Filter
➡️ Creating of Filter in Excel
➡️ Excel How to Create Filter
➡️ How to do Filter in Excel
➡️ How to Sort in Excel
#advancedexcel #msexcel #excel #pintukushwha
0 Comments