How to convert cell contents from General to Date format in Excel
If you fill any date in general format is not understandable by the Excel. Now, it convert cell contents from General to Date format in microsoft Excel.
Microsoft-Office
VLookup to find first few characters in Excel
VLookup to find first few characters in Excel article helps you to search first few characters of any name to get the proper result in Excel.
Add or insert leading zeros to text or numbers in MS Excel
If you need to add leading zero to a value then read this article to provide quick way to add or insert leading zeros to text or numbers in Excel.
2 Ways to Fill blank cells with 0 or any specific value in Excel
During working on the large worksheet data with balnk cells, you will be able to easily and quickly fill blank cells with 0 or any specific value.
Top secret magical tricks of Microsoft Word
Top secret magical tricks of Microsoft Word. These magical tricks helps you to draw different symbols and line within a short period.
Automatically open a specific Excel file whenever you start Excel
Automatically open a specific Excel file whenever you start Excel allows you to customize how Excel starts or create a startup file in Excel.
Get the File Names from a Folder using Excel function
Excel has many useful tricks which is very useful for us. You can use given trick to get the file names from a folder using Excel function.
How to Filter Bold Cells Character Formatting in Excel
Find and Replace command allows you to apply bold formatting that can be filtered. Now you can use Filter bold cells character formatting.
How to Apply Alternate Color Shading Between Rows in Excel
Conditional Formatting gives decorative look on active worksheet. This feature allows you to apply alternate color shading between rows.
3 Ways to find duplicate values on same worksheet – Excel
Excel allows you to search or find duplicate values on same worksheet. You can use given three methods to identify the duplicate values.