Sometime we you are working on large worksheet you need to automatically apply alternate color shading between rows in Excel. If you do this job manually then it will take lot of time. Conditional formatting allows you to quickly apply alternate color shading between rows in Excel.
Sometime you need to insert the file name list of any format from any specific folder to active worksheet in Excel. This could be done by copy the file name one by one and paste them in the active worksheet. You can use given latest Excel trick to get the file names from a folder using Excel function.
Excel is an important utility application software. It is used for data analysis, modelling, charting, calculations, apply lot of functions for complex calculation and many more. Sometime we need to insert symbols and special characters in Excel, but most of the symbols and special characters does not shown in your keyboard.