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 FilesMicrosoft OfficeOffice12Library 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.

EnableExcelAddIns Power Up Microsoft Excel 2010/2007 With Macros & Hotkeys

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.

Macabacus Formatting Excel

formulas macro excel

harvey balls macros excel

To view the hotkeys and edit them to suit your working style, hit the Hot Key Manager button.

Hotkey manager excel

You can tweak the Color Cycles, Font AutoColor, Borders, Numbers, Alignment, and other options from Macabacus Settings dialog.

Macabacus Settings ExcelIt 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!

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

Your email address will not be published. Required fields are marked *