0:00
Hi everyone, in this video, you will learn 5 Excel tricks and formulas that will improve
0:05
the way you work with large data. These tricks will definitely help you save hours of time
0:11
So without wasting time, let's go to Excel and get started. We have some employee data of first name and last name
0:21
And we want to have a new column of full name that combines first name and last name
0:27
Instead of manually writing full names one by one, what we will do is, we will write
0:33
this first full name, and then select all these cells and press Ctrl E to have all the
0:40
full names in one go. Next, we have this data of date of birth of all these employees
0:48
And from this data, we want to find out what their exact age is
0:53
Now instead of manually calculating in your head, click on the first cell here and we
0:58
will write this formula. Equals, dated if, bracket, we will select the date of birth of this first employee
1:07
comma, today, comma, y, this y means year, because we want the age in years
1:16
Hit enter. And select all these cells and press Ctrl D and we have exact age of all these employees
1:28
Now we have the task of giving all of these employees their employee number or employee ID
1:34
Also, the employee ID should start with CP and then the number
1:40
Now instead of writing manually one by one for each employee, we will use a formula here
1:46
We will write equals CP and text bracket sequence bracket again, the number of employees
1:56
we want, comma, and then we will specify three zeros because we want three digits after CP
2:04
Now press enter. And we have employee IDs for all the employees in one go
2:11
We have more data of our employees now. We have their email addresses and street addresses
2:18
Now these email and street addresses are not visible because the column width is really small
2:24
Now instead of adjusting the width and height one by one, what we will do is we will select
2:29
all the data by pressing Ctrl A, then press Alt HOA to auto adjust row heights and press
2:38
Alt HOI to auto adjust column widths and everything can be seen clearly now
2:45
Lastly, when we scroll down through the data, it can be difficult for someone to recognize
2:51
that if this is the first name or this is the first name
2:55
In this case, we want to fix these headers so that the data is identifiable easily
3:01
To do this, we will press Alt WFR. And now if we scroll down, the headers are fixed and the confusion is no more
3:10
These were some of the basic tricks and formulas in Excel. Make sure to give this video a thumbs up and share it with your friends
3:18
Drop a comment below with topics you would like me to cover next. Till then, keep learning and I'll see you in the next video
