How to Enable and Use the Macro Recorder in Excel 2007
Excel’s macro recorder is a useful tool that “records” user actions for “playback at a later time”. The main advantage of using a macro recorder in Excel is that it allows a user to easily perform complex operations over and over that may not be feasible without custom computer programming / scripting. It’s usage can [...]
Calculating Price Reductions in Excel
In this example, we have a Price list and certain prices need to be reduced by 10%. Here is how we are going to achieve this.:
How to Reduce Prices by a certain percentage
Open up Microsoft Excel (Formula can be used in virtually any version of Excel).
For this example, we are going to assume that the [...]
Calculate a person’s age in days using Excel
A worksheet lists Names in column A and their birth dates in column B. To calculate the age of these persons in days, first, enter the current date in cell B1 and then perform the following steps:
How to Calculate the age of a person in days:
Open a worksheet in Excel
In this example, we are assuming [...]
