The Magic of Excel Keyboard Shortcuts... Excel keyboard shortcuts generally start with by pressing the "Alt" key. So, once you press the "Alt" key, you will see a shortcut or in fact an alphabet for each tab in the ribbon. Like F is for File, H is for Home, N for insert and so on. In the old excel interface, I mean 2003, you can find an underline under the letter in the menu which denotes the short key.
Download the practice file from this link: https://drive.google.com/file/d/10QldVsSpaWzi0g01SUOHHZrYl3vd878L/view?usp=sharing
Using sparklines and conditional formatting make your task tracker and dashboard visually appealing in just 5 minutes.
Subscribe to my channel at http://www.youtube.com/user/excelissimple?sub_confirmation=1
#exceldashboard #exceltasktracker #dashboardinexcel #excelformulasandfunctions #exceltutorial
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
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=R_EBXJzB9UQ
Check this video to see how to count the number of line breaks in a 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=0VKR3NjHtU0
TEXTJOIN function is a life saver #ExcelTricks #msexcel
~~~~~~~~~~~
?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=CxjxkMRplcQ
Learn Excel Transpose Function in less than 3 minutes #ExcelTips #MSExcel
#TransposeFunction #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=uxZxMZrmJck
The question troubles many times why we have both CONCATENATE and AMPERSAND while they serve the same purpose.
Watch this video to understand how both of them are useful
Concatenate and Ampersand (&) both serve the same purpose but it is all about the type of concatenation that you want to do which will decide which one is easier for you. In case of text concatenation, or if you have to just reference the cells; it is good to use Amerpsand because it is quick and easy. When you have to do long calculations along with concatenation, the repeating Ampersand symbol might irritate you. Instead, if you use concatenate function, the only separators are commas and it is easy to use.
Still it is up to you! If you are regularly using Ampersand, you will not find any difficulty in using it in any case or vice-versa.
While the CONCATENATE Function is all nice and proper and well documented, the Ampersand (&) operator is much easier to use in practice.
The Ampersand operator separates the different arguments to be combined in a text string. Much easier to use than typing out CONCATENATE, don’t you think?
In any event, both the CONCATENATE Function and Ampersand Operator return a Text String. Excel will recognize this text string as a Date, but there are problems associated with Dates entered as Text. You can’t change it’s numeric formatting, to name just one.
...
https://www.youtube.com/watch?v=JkO0tf_YjwM
Substitute function has got may practical applications while using excel. Let us see this with five practical examples.
00:00 - Substitute function's Syntax
01:00 - Substitute All
02:08 - Substitute Some
03:57 - Remove Line Breaks
04:07 - Count Line Breaks
06:06 - Count words in a cell
#substitutefunction #exceltricks #msexcel
...
https://www.youtube.com/watch?v=4GwQEzQUZwI
VLOOKUP tutorial for beginners with multiple examples
Here are the chapters of the video:
00:00 Introduction to VLOOKUP
02:07 Syntax of VLOOKUP function
03:31 Simple Search Example
07:13 Merging Databases
13:04 Named Ranges
16:09 Trim
17:49 Wildcards
20:25 Weekday
21:15 Working with Dates
22:58 ISNA in VLOOKUP
25:34 Present Data
30:52 Helper Column in VLOOKUP
33:06 Two Way Vlookup Using Match
37:20 Ordinal Number Of Date
41:55 RandBetween
45:27 Approximate Match in VLOOKUP
#vlookuptutorial #howtovlookup #whatisvlookup
#vlookup #vlookupinexcel #excelvlookup
~~~~~~~~~~~
?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=lziCOL6Grh8
Can SWITCH Function save us from 'Nested IF' | Excel 'Switch Function' is a life saver
#SwitchFunction #exceltips #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 usability 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 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=7La1lO8tVho
SELECT ROWS WITH SHORTCUT KEYS
The keyboard shortcut for highlighting an entire row in a worksheet is:
Shift + Spacebar
USING SHORTCUT KEYS TO SELECT A WORKSHEET ROW
1. Click on a worksheet cell in the row to be selected to make it the active cell
2. Press and hold down the Shift key on the keyboard
3. Press and release the Spacebar key on the keyboard without releasing the Shift key
4. Release the Shift key
5. All cells in the selected row should be highlighted - including the row header
SELECTING ADDITIONAL ROWS
...
https://www.youtube.com/watch?v=7yr8Jcej-_k