Power Up Microsoft Excel 2010/2007 With Macros & Hotkeys
Macabacus Macros is a free add-in for Excel 2010/2007 and Excel 2003 that adds various tools and keyboard shortcuts to speed up the construction of financial models. According to the developer, it can trim the time required to perform common tasks by upto 75%.
Unlike other add-ins, it doesn’t install automatically. You will have to first copy the downloaded file to C:\Program Files\Microsoft Office\Office12\Library and then head over to Excel Options and select View Add-ins tab. From here, next to Manage, select Excel Add-ins and hit Go.
From here, check Macabacus Macros add-in and hit OK.
Note: The above installation method works with MS Office Excel 2010 and Excel 2007 only. To install it in Excel 2003, see the guide on developer’s page.
Restart Excel and you will find the newly added Macabacus tab. It contains small tools to speed up the tasks, I have shown some in the screenshots below.
To view the hotkeys and edit them to suit your working style, hit the Hot Key Manager button.
You can tweak the Color Cycles, Font AutoColor, Borders, Numbers, Alignment, and other options from Macabacus Settings dialog.
It might not come handy to average Excel user, but will surly help those heavy Excel power users.
Download Macabacus Macros Add-in
It works with Excel 2003, Excel 2007, and Excel 2010. Enjoy!
Thanks for this post, I’m very interested in all connected with MO2010. I just would like to ask you to post an article concerning Microsoft Office 2010 Tech Preview ( if you’re using one from Microsoft as a beta tester). The thing is that I also got invitation from Microsoft to test their MO2010 Tech Preview, and I’m working with it, but the thing is that in 14 days MO2010 will become unlicensed. Could you tell me please what I supposed to do- either uninstall MO2010 completely or continue testing it..? And what functions are going to be switched off after my license expires..?
I am using Technical Preview for the last 2 months and it has not expired yet. It only shows the feedback dialog after every 10 minutes or so which wouldn’t be much of a problem. But if you are considering removing older version of Office to install MO2010, then don’t.