In this video, we will learn how SWITCH is a better alternative to NESTED IF.
Further, we will check an example of VLOOKUP where we need to SWITCH between the tabs for ARRAY.
#excelswitchfunction #vlookup #excelformulasandfunctions
Download this sample Spreadsheet from here: https://drive.google.com/file/d/1lPfaMFpCMq0HJTJmHkf4GrFw3SaP8rO0/view?usp=sharing
VLOOKUP tutorial: https://www.youtube.com/watch?v=rmc4o4cszM4
Check these rarely used excel functions: https://www.youtube.com/watch?v=LfbAYIc5Or0
Filter function tutorial: https://www.youtube.com/watch?v=oeV5e7iDqUk
SWITCH Function - Your alternative for NESTED IF | DYNAMICALLY change array in VLOOKUP using SWITCH
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
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=_W2PmRfSKzY
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
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=M9aJ7Mf0nPY
Google Sheets Magic Trick! - Replicate using ARRAY function
#arrayfunction #googlesheet #GooglesheetTricks
~~~~~~~~~~~
?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=Q_vn9tCvw5g
How to fully automate your Task tracker using Google Sheets and Google Forms
Here is the link to the original video for task tracking:
https://www.youtube.com/watch?v=0s-xSQjXKBg
Assume that your team is working in collaboration from multiple locations…working from home like what we are doing right now because of the pandemic situation. You have tasks allocated to everyone and they need to report back to you once the task is completed. We all know that calls, chats, and emails can eat away a lot of time and is not the right way to work on it. The manager or the supervisor will spend his/her entire time just tracking and updating the statuses if there are hundreds of job tickets to be tracked.
You also do not want to expose your tracker to everyone to collaborate as it would cause a lot of chaos and unwanted issues if multiple people are filling it at the same time.
So, to resolve this problem, we will use a combination of Google Sheets and Google Forms. In our solution, the tracker is never exposed to the team and they only see what is allocated to the team members.
In our solution, every time, you allocate a new job, it will show up in the pivot and in turn on the webpage that the team can view. Once they are done with their work, they fill the form. This updates the records in the responses tab. This in turn updates the master tracker. Once the master tracker has the completed date, it is removed from the pivot and hence removed from the webpage that is shared with the team as well.
#workfromhome #freetasktracker #wfh #projectmanagement
Here are the time codes to jump to the respective sections of the video:
02:09 Creating the master tracker
06:28 Pivot Table Creation
10:02 Create a webpage from the Pivot Table
11:41 Create a google form
17:40 Link the Form responses to master tracker
19:43 VLOOKUP Form Responses and Master Tracker
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
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=xVhcQNRs-UA
This video teaches you how to do a VLOOKUP with multiple criteria.
Excel VLOOKUP Function with Multiple Criteria | Two way VLOOKUP in your Task Tracker and Dashboards
Two way VLOOKUP using MATCH
#vlookupinexcel #twowayvlookup #vlookupwithmultiplecriteria #excelformulasandfunctions
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
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=eVgDEPTRdbo
#excelformulasandfunctions #excelhacks #exceltipsandtricks
Subscribe to my channel at http://www.youtube.com/user/excelissimple?sub_confirmation=1
Chapters of Video:
0:00 Sequence function
2:22 Current date and time
3:06 Join text from cells
5:02 Advanced Paste shortcuts
7:46 Cell Border Shortcut
8:36 Expand/ Collapse Ribbon
9:07 Insert Table Shortcut
9:56 Create Multiple folders
14:47 Shortcut to select row/column
15:31 Select non-adjacent cells
16:19 Copyright, Trademark, Registered Symbols
17:39 Hyperlinking Shortcuts
20:03 Add line breaks in a cell
20:22 Remove line breaks from a cell
21:34 Toggle Filters
22:23 Instant Dropdown list
23:20 Units conversion
25:35 Compare text using EXACT function
27:08 Using UNIQUE and FILTER together
30:38 Check a function - FORMULATEXT function
31:58 Count words in a cell
34:19 The TRANSPOSE Function
36:57 TEXT function
42:55 VLOOKUP with multiple criteria
46:58 Count Line Breaks
48:59 How to add Sparklines
51:04 Find next match
53:47 Superscript and Subscript
55:05 Dependent Data Validations
Boost your productivity with these rarely used excel shortcuts and functions - MEGA EXCEL HAUL
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
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.
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=soRkWtfhAf4
A simple excel task tracker to track your personal tasks.
Download the excel sheet from this link: https://drive.google.com/file/d/1EG8WvE51S7Na5pPut6dGfdbJY7eEpesF/view?usp=sharing
Create a personal Excel Task Tracker in 20 mins | Download sample task tracker
#exceltracker #trackingsheet #tasklist #exceltasklist
00:00 Introduction
00:30 Tracker elements
01:13 Status checkbox
02:24 Capturing checkbox click
03:23 Weightage to priority
03:59 Lookup of weightage and task
05:45 Capturing checkbox weightage
06:56 Overall tasks completed
07:21 Creating the progress bar
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
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
Stay connected at:
Facebook: https://web.facebook.com/excelissimple
Google Plus: google.com/+excelissimplenow
Share, like and post any questions on the videos
...
https://www.youtube.com/watch?v=K15XN7vA5lc
In this video, we show you how to do a fuzzy match in excel using WILD CARDS in VLOOKUP function.
#vlookupwildcards #fuzzymatchvlookup #excelformulasandfunctions
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
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=I5RJh7MgCvY
Simple Hack to count the words in a cell! #excelhacks #msexcel #exceltricks
~~~~~~~~~~~
?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=o7F2F_xcWgU