Published By
Created On
10 Jul 2019 23:23:24 UTC
Transaction ID
Cost
Safe for Work
Free
Yes
Understanding Concatenate and Ampersand (&) in Excel - Their similarities, differences and usage
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
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
Author
Content Type
Unspecified
video/mp4
Language
English
More from the publisher
Controlling
VIDEO
EXCEL
excel-trick-how-to-create-a-validation
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
Transaction
Created
3 weeks ago
Content Type
Language
video/mp4
English
Controlling
VIDEO
HIDE
hide-and-unhide-rows-and-columns-excel
Hide and Unhide rows and columns using excel keyboard shortcuts
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
...
https://www.youtube.com/watch?v=p8GrvV9uT70
Transaction
Created
3 weeks ago
Content Type
Language
video/mp4
English
Controlling
VIDEO
8 POW
8-powerful-excel-shortcuts-rarely-used
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
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
Transaction
Created
3 weeks ago
Content Type
Language
video/mp4
English
Controlling
VIDEO
USE A
understanding-and-or-functions-how-to
Learn Excel AND OR function step by step using this video
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:
Blog: http://excelissimple.blogspot.com/
...
https://www.youtube.com/watch?v=rDeAhZ7Ub_Y
Transaction
Created
3 weeks ago
Content Type
Language
video/mp4
Controlling
VIDEO
AMAZI
amazing-excel-trick-scan-text-in
Amazing Excel trick SCAN TEXT in EXCEL!!! #exceltricks #msexcel #shorts #imagetotext #exceltips
HOw to extract data from an image using EXCEL.
~~~~~~~~~~~
?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 #excel
...
https://www.youtube.com/watch?v=tRf4Ckw7rs8
Transaction
Created
3 weeks ago
Content Type
Language
video/mp4
English
Controlling
VIDEO
INSER
insert-copyright-trademark-and
3 ways to insert copyright, trademark and registered symbols is explained in this video.
A variety of symbols can be added to an excel sheet that you are working on.
1. On the Insert tab, click Symbol.
2. Click a symbol in the immediate list, or click More Symbols, and then click the symbol you want.
Copyright and trademark symbols can also be added by using a keyboard shortcut.
For example:
• To insert the copyright symbol, press Ctrl+Alt+C.
• To insert the trademark symbol, press Ctrl+Alt+T.
• To insert the registered trademark symbol, press Ctrl+Alt+R.
...
https://www.youtube.com/watch?v=YQSpTJPnJbY
Transaction
Created
3 weeks ago
Content Type
Language
video/mp4
English
Controlling
VIDEO
HOW T
how-to-fill-blank-cells-in-a-list-excel
A simple excel trick to fill blank cells in a series with the above values
#exceltricks #fillblankcells #exceltipsandtricks #excelautofill
~~~~~~~~~~~
?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=YIERuI6UsUQ
Transaction
Created
3 weeks ago
Content Type
Language
video/mp4
English
Controlling
VIDEO
HOW T
how-to-compare-two-text-strings-while
If you use an Equal to (=) for two text strings with exactly same text but different casing, you will get a true result. Therefore it is best to use the EXACT function with text strings.
The Excel EXACT function compares two text strings, taking into account upper and lower case characters, and returns TRUE if they are the same, and FALSE if not. EXACT is case-sensitive.
Purpose
Compare two text strings
Return value
A boolean value (TRUE or FALSE)
Syntax
=EXACT (text1, text2)
Arguments
text1 - The first text string to compare.
text2 - The second text string to compare.
Usage notes
The EXACT function compares two text strings in a case-sensitive manner. If the two strings are exactly the same, EXACT returns TRUE. If the two strings are not the same (taking into account upper and lower case) EXACT returns FALSE.
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
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=AVLRerq9Fd8
Transaction
Created
3 weeks ago
Content Type
Language
video/mp4
English
Controlling
VIDEO
HOW T
excel-nested-if-function-nested-if
Excel Nested IF function
Nesting of the IF function is quite tricky but after using the methodology shown in this video, you can be a master at using multiple IF conditions.
This tutorial will teach you How to use Multiple IF conditions in a single formula
--------------------
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=Ejd7HGOS5Hs
Transaction
Created
3 weeks ago
Content Type
Language
video/mp4
English