Excel: Tools, Add-Ins, and Macros
Included here is the start of a much needed compilation of Excel add-ins, macros, and tools.
For the one person who'll read this, please add your most frequented excel shortcuts, and own collection/links of Excel Add-Ins/Macros/Tools in the comments down below. That way when any new WSO users search for "Excel Tips" they can find and bookmark this.
Boost Excel
Features:
Connecting routine tasks in Excel to custom shortcuts; Adding the Excel 2003 menu to the Excel 2007 and 2010 ribbon; Easily break up complicated formulas and trace precedent and dependent cells; Automatically color cells based on custom settings.
Download Link: http://goo.gl/fzxLC
Ex Stock
Features:
Allows you to download data from the Stock Exchange into the Excel file with one click. Required just insert a symbol (YHOO, MSFT, AAPL, etc)
Contains the following:
- financial statement - balance sheet - cash flow
- price history - daily summary
- basic technical indicators (SMA, MACD, RSI)
Key statistics:
- Valuation Measures - Financial Highlights - Trading Information
Download Link: http://goo.gl/RMoYB
SmartShortcuts
Features:
Designed by one of our very own WSO users, it fits you with an array of custom shortcuts to let you avoid that mid-life carpal tunnel.
Download Link: http://www.smartshortcuts.com/
Email Permulator
Features:
Really need to email that VP? His email just completely impossible to find? Download the Excel Spreadsheet below, type in his full name and website extension, then download the Rapportive plugin for gmail. After you do that, paste the results you get from the Excel Spreadsheet one by one into any gmail full compose box (but don't send anything), and Rapportive will scan it and tell you if it's a functional address.
Spread Download Link: http://goo.gl/D6v1T
Rapportive Download: http://rapportive.com/
1. What Shortcuts do you use the most?
2. What Add-Ins smoothen it out the work?
3. Handy Spreads to keep on file?
4. Macro Download Links?
Recommended Reading
Federal Reserve Economic Database add-in: http://research.stlouisfed.org/fred-addin/
Much better off with Center across selection.