Monday, December 19, 2011

Excel Macro Online Tutorial


1. Navigate to the Brown University Excel macros tutorial listed in References. The guide walks you through running macros, creating macros, and running macros using toolbar buttons and shortcut keys. The guide offers plenty of examples and an advanced section on how to edit macro code. The instructions for creating and running the macros are applicable to Excel 2003, but the concepts are the same for Excel 2007.
2. Go to the Help With PCs website listed in the References section. This website includes an Excel macros tutorial, complete with screen shots to help you see what actions you are performing. The beginning tutorial is a guide to creating a simple macro and playing it back. The guide is applicable to Excel 2003.
3. Load the Florida Gulf Coast University website listed in References. Click on 'Macros' toward the bottom on the page to take you to an Excel 2007 online macros tutorial page. The site also offers a variety of other basic help for Excel 2007, accessible by clicking on any menu item.

Blogger news