Back to CPASelfstudy.com    Back to Software Tips Page

Macros - If you have not used macros before you will probably need to go into the Tools menu and change the Macro Security level before Microsoft will open the spreadsheet.

March Macro - Amortization Schedule

This macro will create an amortization schedule for you automatically. It  will prompt you for the required information- amt, rate and time period.

Click here to access the Amortization schedule in  the Excel worksheet (Version 2003)
If you want the 2007 version, email me and I will send it to you- I am currently having a problem getting it to download properly.

April Macro - Format Numbers into Dates
This macro is written for 2003 as well as 2007. This macro will format your numbers into dates.
This macro was created for someone who had to enter a lot of dates while doing bank reconciliations - I thought other people might have a use for it.
When you access the macro Enter Dates, it will prompt you to enter a range of cells.
Either type in the range or use your mouse to select the range.
Then enter your dates without the slashes.
The macro will automatically format it as a date.
THIS MACRO ASSUMES THAT YEAR IS 2 DIGITS!

For example, type in 33109 and it will display as 3/31/09
This macro was created for someone who had to enter a lot of dates while doing bank reconciliations - I thought other people might have a use for it.
Click here to access the Excel workbook containing the macro.

Updated: 3/30/09