Excel 2007 Macros

• Make a Macro do Simple Tasks
• Difference between VBA & Macro
• Creating a Simple Macro
• Changing Multiple Properties at Once
• Manipulating Recorded Properties
• Recording Methods in a Macro

Lesson2:

• Make a Macro Do Complex Task
• Opening the Report File
• Filling in Missing Labels
• Adding a Column of Dates
• Appending to the Database
• Deleting the Worksheet

Lesson3:

• Explore Workbooks and Worksheets
• Understanding Workbooks
• Understanding Worksheets

Lesson 4:

• Explore Range Objects

Lesson 5:

• Explore Data Objects
• Working with Excel Table
• Working with Pivot Table Reports

• Explore Graphical Objects
• Explore Chart Objects

Lesson 7:

• Control Visual Basic
• Creating Loops
• Managing Large Loops

Lesson 8:

• Extend Excel and Visual Basic
• Creating Custom Functions
• Handling Errors

Lesson 9:

• Launch Macros with Events
• Creating Custom Command buttons
• Handling Worksheet and Workbook Events

Lesson 10:

• Use Dialog Box Controls on a Worksheet
• Using a loan Payment Calculator
• Retrieving a Value from a list
• Protecting the Worksheet

Lesson 11:

• Create a Custom Form
• Preparing a form’s functionality