Excel Tips and Tricks 2020 Part 2 | Tech Universe
In this second article
Topics
1. Sort
2. Format Painter
3. Table
4. Remove Duplicate
5. Data Validation List
6. Vlookup (Function)
7. Flash Fill
8. Text To Columns
9. Consolidate
10. Advance Filter
1. Sort
When we have a large excel file and want to adjust data as we need is a major problem but this is actually very easy. Simply select your data and go to Sort & Filter and sort the data as required.We can also use shortcut key for this function.Its shortcut key is Alt+H+S+S. For better understanding a picture is attached bellow.
2. Format Painter
Format painter is used in excel to copy formatting. In this function we select a cell which we want to copy and click at Format Painter and then select the range where we want to copy.There is also a shortcut for this function which is Alt+H+FP. For better understanding a picture is attached bellow.
3. Table
4.Remove Duplicate
Lets suppose you have a large file of employees data and when you represent to your boss he says that he didn't want any duplicate in this file you only have some mints to do this you will be absolutely worried about how to do this but if you know the function of remove duplicate then you will not be worry. You can remove duplicates in a mints by using remove duplicate function.Select your data & Go to Data tab and click at remove duplicates all the duplicates will remove at once.Shortcut key for this is Alt+A+M.There is also a shortcut for this function which is Alt+H+FP. For better understanding a picture is attached bellow.
5. Data Validation List
If you have 2 or more sheets in a workbook of excel and want to pick the data of 2nd sheet you can use Data Validation List for this. In this function you have to go to Data tab and select Data validation list option click on this & there will open a dialogue box in settings change the any value option to list option and then select the range of data in source and then click at ok you will see a list of data in your selected cell you can also drag this list to other cells in rows and columns.Shortcut key for this is Alt+A+V+V. For better understanding a picture is attached bellow.
6. Vlookup (Function)
Vlookup function is used to search data against a word. In this function simply write =vlookup in you cell & select the cell of data against which you want to search data then select the range from where you want to pick data write the number of column of required data and then write 0 for absolute match and press enter you will receive your required data in the cell you can also drag this to other cells.For better understanding a picture is attached bellow.
0 Comments