Flash Fill is only available in MS excel 13 and above versions. Flash fill is used to fill the data automatically in the below cells if a pattern is evident. It can also extract, insert or concatenate. Some...
A B C 1 PRODUCT NAME TOTAL AMOUNT 2 WASHING MACHINE 3616 3 MI PHONE 4978 4 SAMSUNG MOBILE 3825 5 NOKIA PHONE 3902 6 T.V 3759 6 L.G REFRIGERATOR 3693 7 BOTTLE 4191 ...
Have you every tried Slicer option in Excel? There are lot many features in excel which go unnoticed even if they are visibleAs you know, one of the powerful tool in excel is Pivot table which summarizes...
You need to know about these following functions which are based on Microsoft Excel 2010.1. Speedily Move and Copy Data in Cells:-If you want to move one column of data in a spreadsheet, the fast way...