This is a list of excel and access resources for my students

Recommended Add-ins / Upgrades for Excel:

• Data Analysis Toolpak   (File->Options->Add-ins)
• ASAP Utilities (http://www.asap-utilities.com/)
• FRED (http://research.stlouisfed.org/fred-addin/)
• Powerpivot  (http://www.microsoft.com/en-us/bi/powerpivot.aspx)
• Developer Tab (VBA) (File->Options->Customize Ribbon)

Excel / Access Links / Resources:

• http://cameron.econ.ucdavis.edu/excel/excel.html  (UC Davis, beginners)
• http://www3.wabash.edu/econexcel/  (Wabash College, advanced)
• Interactive Excel Spreadsheets (‘Excelets’) – Lots of fun stuff, great looking charts
• http://pages.stern.nyu.edu/~adamodar (corporate finance and valuation)
• Excel 2013 blog (Excel 2013 has cool add-ins! – including bing mapping)
• http://www.gcflearnfree.org/access2010 (great for beginners)
• Microsoft Office Access Training Site

Understanding when to use Excel (spreadsheets) vs. Access (relational database):

• Microsoft Office Help explanation of the difference
• A better explanation from FMS Inc here

Excel Files – Practice and VBA simulations:

• Summer Prep Excel Practice MFRE 2013
• Orbital_motion shown in class
• Tetris game shown in class (Run the macro first with Alt-F8)

Follow