VERY USEFUL TRICK WITH MUST LEARN FORMULAS
Excel sheet, we use every day at our workplace. Without Excel can not finish our work properly. And every Excel user need some tips and trick to do work perfectly. After learning some Excel tricks and formulas we can save our lots of time. I have listed here some top formulas and excel tricks for you.
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.