There is an easy way to use keyboard shortcuts to toggle the excel filters
One of the handy features of Excel is AutoFilter. It allows you to quickly filter any list by the contents of a particular column. You can use the Customize option from the Tools menu to add an AutoFilter tool to your toolbars. This tool uses an image of a funnel and an equal sign.
The tool is a bit deceptive, however; it is not the same as the AutoFilter option available from the Data menu. The menu option is a toggle condition. If you have a cell selected in a list and you choose the menu option, then the AutoFilter controls appear at the top of each column in the list—there are no other changes to the list. If you use the AutoFilter tool, not only do the controls appear, but Excel filters the list based on the cell you had selected when you used the tool.
Another difference between the two is that the AutoFilter menu option functions like a toggle—choose it once, and the AutoFilter is applied; choose it again and it is removed. The AutoFilter tool doesn't do that; it only applies the AutoFilter.
Are you using the Excel filters properly and do you know everything about Excel Advanced Filter? Watch this video to understand Excel Filters.
Video Chapters:
00:00 Introduction
00:23 What are excel filters
04:41 Advanced Filters in Excel
07:58 Copy filtered list to another location
~~~~~~~~~~~
?Subscribe to the channel at ?https://bit.ly/3eB8Mmd
?Like, share and comment on the videos.
~~~~~~~~~~~
'Excel Is Simple' is an effort to make Excel & Google-Spreadsheets usage simple and teach the toughest concepts in the simplest ways possible. Here you will find Excel tips and tricks, Excel Task trackers, Excel Dashboards and different Excel keyboard shortcuts. We also cover various Excel formulas and functions and explain the real-life useability of each one of them. If you don't find a relevant video for you, drop a comment on any particular video and we will try our best to make a new video to answer your query.
~~~~~~~~~~~
Check out some of your relevant content here:
? Excel Task trackers and Dashboards: https://www.youtube.com/watch?v=MArcLLrQS1Q&list=PLRJY-_DDvSgIlLZuhQuwFFA6OPBjNyxvQ
? Google Sheets Videos: https://www.youtube.com/watch?v=arNiyCysy-I&list=PLRJY-_DDvSgLoScx2PmQM7kK_zDuu4hvS
? Excel tips and tricks for 2021: https://www.youtube.com/watch?v=soRkWtfhAf4&list=PLRJY-_DDvSgJQzmJSR2eEv-wEsNMB2iqg
? Excel Formulas and Functions: https://www.youtube.com/watch?v=njX0GsyO4T8&list=PLRJY-_DDvSgKsM7G8qQEAa3oWLDCUn401
? How to Excel for Beginners: https://www.youtube.com/watch?v=VB8w1AoMT74&list=PLRJY-_DDvSgLUOnfRBwVQYZVVzOxaVz76
? Must Kow Excel Shortcuts: https://www.youtube.com/watch?v=npNdDvTpTNg&list=PLRJY-_DDvSgJyN7vTu2NQnzV0yPzU84IE
? Time Saving Hacks in Excel: https://www.youtube.com/watch?v=JkO0tf_YjwM&list=PLRJY-_DDvSgKmdbr9DZDZWlOVut-kluNZ
? VBA Macros: https://www.youtube.com/watch?v=D7jU3WIPBZ0&list=PLRJY-_DDvSgK0O0V661KTt4t7I-duD3Op
? Free Excel Templates to Download: https://www.youtube.com/watch?v=e-nylMU8xNg&list=PLRJY-_DDvSgIWTxC6yNkrpw8FvIJ8Cx38
~~~~~~~~~~~
#exceltutorial #exceltutorialforbeginners #exceltraining #excelvba #exceltemplates #exceldashboard #exceltv2020 #excelpayroll #excelapp #excelautoshape #excelautomation #excelamazingfeatures #excelattendance #excelandroid #excelaccounting #excelapplication #excelbill #excelbutton #excelbeginner #excelbhavcopy #excelchart #excelcalendar #excelcost #excelconference #exceldatefunction #exceldatepicker #exceldatarecovery #exceldateformula #exceldataentry #excelfunctions #excelformulaslist #excelforbeginners #excelformulas #excelforhr #excelformulasandfunctions #excelforbegineers #excelformulabasics #excelgstinvoice #excelhash #excelinvoice #excelinvesting #excelinfographics #excelinventory #excelinterviewquestions #exceljobinterview #excellearningseries #excelmacros #excelmining #excelonsmartphone #excelproject #excelpro #excelpivottables #excelpowerquery #excelquiz #excelquotation #excelquickandeasy #excelquestions #excelrevolution #excelsecurity #excelsheet #excelshortcutkeys #excelshorts #excelsior #excelshortcuts #excelshortcutkeysintamil #exceltricks #exceltasktracker #exceltowhatsapp #exceltopdf #excelutility #exceluserform #excelvisulization #excelvisualization #excelvbacode #excelvlookup #excelvbaforbeginners #excelvbatutorial #excelwhatsapp #excel10tutorial #excel2019 #excel2016 #excel2tally #excel4us
~~~~~~~~~~~
...
https://www.youtube.com/watch?v=R5ijilAx6xU
WHAT IF analysis and GOAL SEEK can make your MS Excel live much more simpler! Here is a step by step tutorial to this mostly ignored MS Excel Feature
#MSExcel #GoalSeek #WhatIFAnalysis
~~~~~~~~~~~
?Subscribe to the channel at ?https://bit.ly/3eB8Mmd
?Like, share and comment on the videos.
~~~~~~~~~~~
'Excel Is Simple' is an effort to make Excel & Google-Spreadsheets usage simple and teach the toughest concepts in the simplest ways possible. Here you will find Excel tips and tricks, Excel Task trackers, Excel Dashboards and different Excel keyboard shortcuts. We also cover various Excel formulas and functions and explain the real-life useability of each one of them. If you don't find a relevant video for you, drop a comment on any particular video and we will try our best to make a new video to answer your query.
~~~~~~~~~~~
Check out some of your relevant content here:
? Excel Task trackers and Dashboards: https://www.youtube.com/watch?v=MArcLLrQS1Q&list=PLRJY-_DDvSgIlLZuhQuwFFA6OPBjNyxvQ
? Google Sheets Videos: https://www.youtube.com/watch?v=arNiyCysy-I&list=PLRJY-_DDvSgLoScx2PmQM7kK_zDuu4hvS
? Excel tips and tricks for 2021: https://www.youtube.com/watch?v=soRkWtfhAf4&list=PLRJY-_DDvSgJQzmJSR2eEv-wEsNMB2iqg
? Excel Formulas and Functions: https://www.youtube.com/watch?v=njX0GsyO4T8&list=PLRJY-_DDvSgKsM7G8qQEAa3oWLDCUn401
? How to Excel for Beginners: https://www.youtube.com/watch?v=VB8w1AoMT74&list=PLRJY-_DDvSgLUOnfRBwVQYZVVzOxaVz76
? Must Kow Excel Shortcuts: https://www.youtube.com/watch?v=npNdDvTpTNg&list=PLRJY-_DDvSgJyN7vTu2NQnzV0yPzU84IE
? Time Saving Hacks in Excel: https://www.youtube.com/watch?v=JkO0tf_YjwM&list=PLRJY-_DDvSgKmdbr9DZDZWlOVut-kluNZ
? VBA Macros: https://www.youtube.com/watch?v=D7jU3WIPBZ0&list=PLRJY-_DDvSgK0O0V661KTt4t7I-duD3Op
? Free Excel Templates to Download: https://www.youtube.com/watch?v=e-nylMU8xNg&list=PLRJY-_DDvSgIWTxC6yNkrpw8FvIJ8Cx38
~~~~~~~~~~~
#exceltutorial #exceltutorialforbeginners #exceltraining #excelvba #exceltemplates #exceldashboard #exceltv2020 #excelpayroll #excelapp #excelautoshape #excelautomation #excelamazingfeatures #excelattendance #excelandroid #excelaccounting #excelapplication #excelbill #excelbutton #excelbeginner #excelbhavcopy #excelchart #excelcalendar #excelcost #excelconference #exceldatefunction #exceldatepicker #exceldatarecovery #exceldateformula #exceldataentry #excelfunctions #excelformulaslist #excelforbeginners #excelformulas #excelforhr #excelformulasandfunctions #excelforbegineers #excelformulabasics #excelgstinvoice #excelhash #excelinvoice #excelinvesting #excelinfographics #excelinventory #excelinterviewquestions #exceljobinterview #excellearningseries #excelmacros #excelmining #excelonsmartphone #excelproject #excelpro #excelpivottables #excelpowerquery #excelquiz #excelquotation #excelquickandeasy #excelquestions #excelrevolution #excelsecurity #excelsheet #excelshortcutkeys #excelshorts #excelsior #excelshortcuts #excelshortcutkeysintamil #exceltricks #exceltasktracker #exceltowhatsapp #exceltopdf #excelutility #exceluserform #excelvisulization #excelvisualization #excelvbacode #excelvlookup #excelvbaforbeginners #excelvbatutorial #excelwhatsapp #excel10tutorial #excel2019 #excel2016 #excel2tally #excel4us
~~~~~~~~~~~
...
https://www.youtube.com/watch?v=-0eAZkxG4Ts
When you search for something in excel you would use ctrl+F (Win) or command+F (Mac). If you have to go to the next match, then you would possibly press the ‘find next’ button in the find window. Now since the window overlaps your excel sheet, it becomes a bit difficult to see the next match in excel. There is a shortcut for going to the next match which is Shift+F4 in windows or Command+G in mac versions of the excel. But in order to use this shortcut, you will first need to open the find window once and type the search string so that the search query is registered. The close the find window and use the shortcuts to move to the next match. This shortcut is very useful when you have to find matches in large databases quickly.
More Amazing excel keyboard shortcuts can be seen in the following playlist: https://www.youtube.com/watch?v=4gVTZW7yOfU&list=PLRJY-_DDvSgIuJQgKLwIqrUESnH_cQxqW
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Welcome to Excel is Simple. A place where excel is taught in the dumbest possible way. You will find every type of excel tutorial; excel 2013 tutorial for beginners, excel 2010 tutorial for beginners, excel formulas and functions, excel pivot table tutorial, excel vlookup. Aptly this is one place which has all excel tutorial for beginners.
Subscribe to my channel at http://www.youtube.com/user/excelissimple?sub_confirmation=1
Want some focused playlists. Click here and lean back:
The IF formula explained: https://www.youtube.com/playlist?list=PLRJY-_DDvSgK7khaQJLqhry-PELQ0hLTe
All excel formulas in one place: https://www.youtube.com/playlist?list=PLRJY-_DDvSgKsM7G8qQEAa3oWLDCUn401
...
https://www.youtube.com/watch?v=4gVTZW7yOfU
Here is a Complete Tutorial to the excel logical functions - IF AND OR in Excel
Nesting is a powerful tool, but once you combine more than a couple IFs, the logic can start to look like spaghetti quickly :)The trick is to keep things organized.
Hung up with IF, AND, OR formulas??? Check this video which will help you master these formulas
Welcome to Excel is Simple. A place where excel is taught in the dumbest possible way. You will find every type of excel tutorial; excel 2013 tutorial for beginners, excel 2010 tutorial for beginners, excel formulas and functions, excel pivot table tutorial, excel vlookup. Aptly this is one place which has all excel tutorial for beginners.
Subscribe to my channel at http://www.youtube.com/user/excelissimple?sub_confirmation=1
Want some focused playlists. Click here and lean back:
...
https://www.youtube.com/watch?v=qjUnACU1xxQ
Check this video to see how to count the words in an excel cell using substitute function.
#substitutefunction #excelformulasandfunction #exceltricks #excel hacks
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Welcome to Excel is Simple. A place where excel is taught in the dumbest possible way. You will find every type of excel tutorial; excel 2013 tutorial for beginners, excel 2010 tutorial for beginners, excel formulas and functions, excel pivot table tutorial, excel vlookup. Aptly this is one place which has all excel tutorial for beginners.
Subscribe to my channel at http://www.youtube.com/user/excelissimple?sub_confirmation=1
Want some focused playlists. Click here and lean back:
The IF formula explained: https://www.youtube.com/playlist?list=PLRJY-_DDvSgK7khaQJLqhry-PELQ0hLTe
All excel formulas in one place: https://www.youtube.com/playlist?list=PLRJY-_DDvSgKsM7G8qQEAa3oWLDCUn401
Excel basics if you have just started: https://www.youtube.com/playlist?list=PLRJY-_DDvSgLUOnfRBwVQYZVVzOxaVz76
Share, like and post any questions on the videos
...
https://www.youtube.com/watch?v=GfORAjsY_DU
Live CURRENCY Conversion in Google Sheets!!
#googlesheetsshortcuts #googlesheetsfunctions #googlesheetstips
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Welcome to Excel is Simple. A place where excel is taught in the dumbest possible way. You will find every type of excel tutorial; excel 2013 tutorial for beginners, excel 2010 tutorial for beginners, excel formulas and functions, excel pivot table tutorial, excel vlookup. Aptly this is one place which has all excel tutorial for beginners.
Subscribe to my channel at http://www.youtube.com/user/excelissimple?sub_confirmation=1
Want some focused playlists. Click here and lean back:
The IF formula explained: https://www.youtube.com/playlist?list=PLRJY-_DDvSgK7khaQJLqhry-PELQ0hLTe
All excel formulas in one place: https://www.youtube.com/playlist?list=PLRJY-_DDvSgKsM7G8qQEAa3oWLDCUn401
Excel basics if you have just started: https://www.youtube.com/playlist?list=PLRJY-_DDvSgLUOnfRBwVQYZVVzOxaVz76
Share, like and post any questions on the videos
...
https://www.youtube.com/watch?v=5fbppT5QOsA
Pimp up your Task Tracker using a 'Status' column and Conditional Formatting
Here are the various chapters o the video:
0:00 Introduction
1:42 Assigning statuses
2:50 Using the IF conditions
6:57 Nesting the IF function
9:01 Conditional Formatting
The detailed 'NESTED IF' function video can be found here:
https://www.youtube.com/watch?v=Ejd7HGOS5Hs
Download the spreadsheet from this link:
https://drive.google.com/file/d/1vINCagzOpWCOrPs--3SXNRnLy33ureKb/view?usp=sharing
#exceltasktracker #exceltracker #tasktracker #tasktracking
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Welcome to Excel is Simple. A place where excel is taught in the dumbest possible way. You will find every type of excel tutorial; excel 2013 tutorial for beginners, excel 2010 tutorial for beginners, excel formulas and functions, excel pivot table tutorial, excel vlookup. Aptly this is one place which has all excel tutorial for beginners.
Subscribe to my channel at http://www.youtube.com/user/excelissimple?sub_confirmation=1
Want some focused playlists. Click here and lean back:
The IF formula explained: https://www.youtube.com/playlist?list=PLRJY-_DDvSgK7khaQJLqhry-PELQ0hLTe
All excel formulas in one place: https://www.youtube.com/playlist?list=PLRJY-_DDvSgKsM7G8qQEAa3oWLDCUn401
Excel basics if you have just started: https://www.youtube.com/playlist?list=PLRJY-_DDvSgLUOnfRBwVQYZVVzOxaVz76
Share, like and post any questions on the videos
...
https://www.youtube.com/watch?v=u6ylNpviwuI
A common question from Excel users is along the lines of; I have a list in a cell that has used Data-Validation with the "List" option. I would like to have another cell display a list that is depended on the item chosen in my first list.
There are quite a few ways to achieve this, but the easiest by far is using the INDIRECT functions in the validation. The INDIRECT Function return the reference returned by a text string.
Here is your guide on how to add dependent data validations in excel
You will find a refresher course to data validations and two possible ways to add dependent data validations in excel.
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
...
https://www.youtube.com/watch?v=dhJ_NMuVZwk
Here are 3 excel functions that you should be using in 2021.
Note that all of these functions are available either in Excel 365 or the online version of Excel.
00:00 Introduction
00:15 Filter Function
03:30 Sequence Function
05:24 Unique Function
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Welcome to Excel is Simple. A place where excel is taught in the dumbest possible way. You will find every type of excel tutorial; excel 2013 tutorial for beginners, excel 2010 tutorial for beginners, excel formulas and functions, excel pivot table tutorial, excel vlookup. Aptly this is one place which has all excel tutorial for beginners.
Subscribe to my channel at http://www.youtube.com/user/excelissimple?sub_confirmation=1
Want some focused playlists. Click here and lean back:
The IF formula explained: https://www.youtube.com/playlist?list=PLRJY-_DDvSgK7khaQJLqhry-PELQ0hLTe
All excel formulas in one place: https://www.youtube.com/playlist?list=PLRJY-_DDvSgKsM7G8qQEAa3oWLDCUn401
Excel basics if you have just started: https://www.youtube.com/playlist?list=PLRJY-_DDvSgLUOnfRBwVQYZVVzOxaVz76
Share, like and post any questions on the videos
...
https://www.youtube.com/watch?v=rXOgXBdeFp0