50476 - Excel Amazing Macros
CLASS DATE(s):
Request a Class

COURSE LENGTH: 1 Day

COURSE COST: $295.00

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print

COURSE OVERVIEW

This one-day course introduces Microsoft Excel 2007/2010 users to the features in creating and managing Excel macro. Participants will learn how to record macro, execute macros in variety of different methods, editing macro and creating a control buttons to activiate the macros.

AUDIENCE AND PREREQUISITES

Aimed at information workers who need to learn more in-depth on the techniques of creating time saving Microsoft ExcelŽ macros. An intermediate user of Microsoft Excel 2007 or 2010 for at least 1 year

PREREQUISITE COURSES  

Course is subject to minimum enrollment. Courseware Cost is not included in price. For more details, please email: learn@vtec.org or call: 207.775.0244.

COURSE TOPICS:


At Course Completion
Open a Workbook Containing Macros
Run a Macro
Use a Shortcut Key
Open the Visual Basic for Application Editor Window
Record a Macro, Assign a Shortcut Key
Use Relative References, Writing New Macro
Assign a Custom Button to QAT
Delete a Custom Button from QAT
Delete a Macro, Assign a Macro to a Button
Create a Macro Button, Use a Macro Button
Create a Macro Button, Copy a Macro Button
Format a Macro Button, Using Form Control

Module 1: Using Macros
Opening a Workbook Containing Macros
Running a Macro
Using a Shortcut Key
Using the Visual Basic Toolbar
Opening the Visual Basic Application Window
Using the Visual Basic Application Window

Module 2: Recording Macros
Recording a Macro
Assigning a Shortcut Key
Using Relative References
Deleting a Macro

Module 3: Editng Macros
Writing a New Macro
Entering Macro Comments
Copying Macro Commands
Editing Macro Commands
Typing Macro Commands
Running a Macro from the Code Window
Using the Debugger

Module 4: Custom Button In Quick Access Toolbar
Create a custom button
Adding a button to Quick Access Toolbar
Change a button image
Delete a custom button

Module 5: Adding Form Controls To A Worksheet
Create a Macro button
Copy a Macro button
Assign Macro to Pasted Macro
Format a Macro button
Rename a Macro button
Moving/Sizing a Macro button
Deleting a Macro button