In this segment we learn about Pivot Table, Text to Column, Vlookup formula, Transpose, Special filter, Go to Special and much more excel tricks.
Pivot table is one of most powerful feature of Excel. By this you can filter and generate a significance data table with a summary. You will find it in Insert Tab of Excel. Just select your data and click on Insert and then Pivot.
You can modified your summarized report as you want.
TEXT TO COLUMN :
Text to column is also a very useful excel feature. By this you can define or separate texts to another cells separately. You will find it in Data Tab of Excel. You can separate your text with it’s delimited or Fixed Width feature. Just select your excel column and goto data and text to column.
Vlookup formula is most powerful formula of excel. By this you can search and find any number or text within a criteria. It is must learn formula of Excel. If you learn it correctly, you become master of Excel.
GO TO SPECIAL :
Go to Special feature is also very useful excel feature. if you want to fill blank cells or do any other special things, it will help you lots.
After that some more useful features of Excel is Transpose, Special filter etc.
You can see all these Excel tips and trick in above video.
For any other information please comment below.