Sometime you need to fill colors in cell data to make more readable. Now, you can easily sort data based on color in Excel as per your need.
Difference between two given times, using text function in excel. Text function change a value to text in a specific number format.
Goal Seek feature in Microsoft Excel is an important tool which allows you to change one variable value and show the impact on rest of the values.
ABS is an important Math & Trig Excel function which is used to change negative numbers to positive numbers. ABS stands for Absolute value.
Sometime you need to quickly convert positive number into negative number with the help of Paste Special command in MS Excel.
If you need to calculate any person’s age from his date of birth to current date then you can use given quick methods to get age from birthdate in Excel.
If you need to filter required complex data then you can easily and quickly use filter command in Microsoft Excel. Filter command turn-on filter options.
To increase or decrease the final calculated result and want to divide extra amount in all the items equally use Solver command in Microsoft Excel.
If you have more than one hyperlink in active worksheet and want to remove them then read this article to quickly remove all hyperlinks from MicroSoft Excel.
Sometime if you don’t want to include few numbers for calculation then you have use given methods to convert or change number to text format in Excel.