Excel 2010: Appendix

Introduction to Macros

 

Advanced Excel Objectives

In this lesson, you will learn how to:

1. Use the Developer Ribbon to record, save and run a simple Event Macro

2. Modify a Macro with the Visual Basic Editor

3. Create a custom Macro Button and assign it to the Quick Access Toolbar

4. Run a Macro when a workbook is opened

5. Use the Developer Ribbon to record, save and run an Action Macro to export or import data from Excel