100 Excel formulas course -Concatenate, Min, Max, Lower,Upper and Proper - 2020
#Excel Tutorial #Excel #Concatenate, #MIn, #Max, #Proper, #Upper, #Lower, Excelformulas #Excel course #5minofficeskills
Closed caption - Subtitle is also given in the description end
This video is all about the “100 Excel formulas course -Concatenate, Min, Max, Lower, Upper and Proper - 2020”. After watching this tutorial, you will be able to use Concatenate, Min, Max, Lower, Upper, and Proper formulas in an excel sheet. We are providing a tutorial for the Top 100 formula course. You will get the most popular software also in this channel like Adobe photoshop, Camtasia studio, free photo editor, and many more.
Previous: 100 Excel formulas course - Sum, SumIf & SumIfs • 100 Excel formulas course - Sum, SumI... Photoshop Download
• 100 Excel formulas course - Vlookup, ... - Vlookup, Hlookup and If statement
--------------------------------------------------------------------------------------------------------------------------- Special Message to you: -*Thank you for giving your valuable time reading this description. I hope, I was able to share with you some knowledge about MS Office, if you liked my content, then please don’t forget to subscribe to my channel. I can’t grow my channel without your support.
------------------------------------------------------------------------------------------------------------------------- About me: My name is Madhur, I've created this channel to share helpful and creative videos about free software download, Software tutorial, Interview, and trending topics. By subscribing to this channel you can expect to learn free software download, Ms-office tutorials, Hr interview questions and answers, and other trending videos. I am creating this channel to help people to grow their skills and mine too. YouTube is the best place to express your views where you can learn new things every day. Contact us: I'm currently based in New Delhi, India. I'm always down to connect and answer any questions. Please feel free to reach out on social media, and If you would like to connect me for business purpose, you can reach me at
[email protected]
Madhur Gupta
-------------------------------------------------------------------------------------------------------------------------
Closed Captions
1
Hello Guys, My Name is Madhur, and welcome to my channel 5 min office skills.
2
This is my other video for the top 100 formula course.
3
If you didn't watch my previous videos yet, please watch, links are given below in the description box.
4
In this video, we are going to learn Concatenate, MAX/Min, and lower/upper/proper function.
5
So, let's start without wasting your time.
6
The first formula is concatenate, it allow a user to merge or join two or more cells.
7
So let me show you how to use the concatenate formula.
8
Press = then type concatenate, press tab then select the first text
9
Then comma, If you need space between text. So press
10
" " then,
11
then select the second text. Now you can see the column is merged.
12
Merge means, The data will come in a single cell.
13
Second formula is Min and Max, If you want to know the max value in this table
14
Press = type max and select the data range and you will get the maximum value, do the same for minimum also, Just use min instead of max.
15
Our, last formula is lower/UPPER/Proper.
16
Lower is used to make everything in lowercase, similarly, Upper for upper case and Proper function for the first word will be in uppercase of each word and rest word in lowercase
17
If you didn't subscribe to my channel yet, Please subscribe to it and press the bell icon for future video notification.
18
Thank you for watching it. Have a great day!
============================================================ All Night by Ikson / ikson Music promoted by Audio Library • All Night – Ikson (No Copyright Music)
Watch video 100 Excel formulas course -Concatenate, Min, Max, Lower,Upper and Proper - 2020 online without registration, duration hours minute second in high quality. This video was added by user 5 min office skills 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3 once and liked it people.