Amazing Macros (Microsoft Excel 2007 & 2010)

Code: 50476
Course duration: 1 days
Location Period
Greenwich, Connecticut (Virtual Instructor-Led) 10-13
09:00AM to 05:00PM
enroll
Fort Lauderdale, Florida (Virtual Instructor-Led) 10-13
09:00AM to 05:00PM
enroll
Mid-Town New York City (Virtual Instructor-Led) 10-13
09:00AM to 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led) 10-13
09:00AM to 05:00PM
enroll
Attend Online 10-13
09:00AM to 05:00PM
enroll
NYC-23rd Street (Virtual Instructor-Led) 10-13
09:00AM to 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led) 10-13
09:00AM to 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Instructor-Led) 10-13
09:00AM to 05:00PM
enroll
Secaucus, New Jersey (Virtual Instructor-Led) 10-13
09:00AM to 05:00PM
enroll
Palm Beach County Florida (Instructor-Led) 10-13
09:00AM to 05:00PM
enroll
Greenwich, Connecticut (Virtual Instructor-Led) 11-10
09:00AM to 05:00PM
enroll
Fort Lauderdale, Florida (Virtual Instructor-Led) 11-10
09:00AM to 05:00PM
enroll
Mid-Town New York City (Virtual Instructor-Led) 11-10
09:00AM to 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led) 11-10
09:00AM to 05:00PM
enroll
Attend Online 11-10
09:00AM to 05:00PM
enroll
NYC-23rd Street (Virtual Instructor-Led) 11-10
09:00AM to 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led) 11-10
09:00AM to 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Virtual Instructor-Led) 11-10
09:00AM to 05:00PM
enroll
Secaucus, New Jersey (Instructor-Led) 11-10
09:00AM to 05:00PM
enroll
Palm Beach County Florida (Instructor-Led) 11-10
09:00AM to 05:00PM
enroll
Greenwich, Connecticut (Instructor-Led) 12-15
09:00AM to 05:00PM
enroll
Fort Lauderdale, Florida (Virtual Instructor-Led) 12-15
09:00AM to 05:00PM
enroll
Mid-Town New York City (Virtual Instructor-Led) 12-15
09:00AM to 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led) 12-15
09:00AM to 05:00PM
enroll
Attend Online 12-15
09:00AM to 05:00PM
enroll
NYC-23rd Street (Virtual Instructor-Led) 12-15
09:00AM to 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led) 12-15
09:00AM to 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Virtual Instructor-Led) 12-15
09:00AM to 05:00PM
enroll
Secaucus, New Jersey (Virtual Instructor-Led) 12-15
09:00AM to 05:00PM
enroll
Palm Beach County Florida (Instructor-Led) 12-15
09:00AM to 05:00PM
enroll
Fort Lauderdale, Florida (Instructor-Led) 01-12
09:00AM to 05:00PM
enroll
Mid-Town New York City (Virtual Instructor-Led) 01-12
09:00AM to 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led) 01-12
09:00AM to 05:00PM
enroll
Attend Online 01-12
09:00AM to 05:00PM
enroll
NYC-23rd Street (Virtual Instructor-Led) 01-12
09:00AM to 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led) 01-12
09:00AM to 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Virtual Instructor-Led) 01-12
09:00AM to 05:00PM
enroll
Secaucus, New Jersey (Virtual Instructor-Led) 01-12
09:00AM to 05:00PM
enroll
Palm Beach County Florida (Instructor-Led) 01-12
09:00AM to 05:00PM
enroll
Greenwich, Connecticut (Virtual Instructor-Led) 01-12
09:00AM to 05:00PM
enroll
Mid-Town New York City (Instructor-Led) 02-16
09:00AM to 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led) 02-16
09:00AM to 05:00PM
enroll
Attend Online 02-16
09:00AM to 05:00PM
enroll
NYC-23rd Street (Virtual Instructor-Led) 02-16
09:00AM to 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led) 02-16
09:00AM to 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Virtual Instructor-Led) 02-16
09:00AM to 05:00PM
enroll
Secaucus, New Jersey (Virtual Instructor-Led) 02-16
09:00AM to 05:00PM
enroll
Palm Beach County Florida (Instructor-Led) 02-16
09:00AM to 05:00PM
enroll
Greenwich, Connecticut (Virtual Instructor-Led) 02-16
09:00AM to 05:00PM
enroll
Fort Lauderdale, Florida (Virtual Instructor-Led) 02-16
09:00AM to 05:00PM
enroll
Mid-Town New York City (Virtual Instructor-Led) 03-16
09:00AM to 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led) 03-16
09:00AM to 05:00PM
enroll
Attend Online 03-16
09:00AM to 05:00PM
enroll
NYC-23rd Street (Instructor-Led) 03-16
09:00AM to 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led) 03-16
09:00AM to 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Virtual Instructor-Led) 03-16
09:00AM to 05:00PM
enroll
Secaucus, New Jersey (Virtual Instructor-Led) 03-16
09:00AM to 05:00PM
enroll
Palm Beach County Florida (Instructor-Led) 03-16
09:00AM to 05:00PM
enroll
Greenwich, Connecticut (Virtual Instructor-Led) 03-16
09:00AM to 05:00PM
enroll
Fort Lauderdale, Florida (Virtual Instructor-Led) 03-16
09:00AM to 05:00PM
enroll

Amazing Macros (Microsoft Excel 2007 & 2010)

Course Specifications

Course number:50476

Course length:1.0 day(s)

About this Course

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 activate the macros.

Audience Profile

This course is intended for Information workers who have an understanding of Microsoft Office Excel 2003/2007/2010.

At Course Completion

After completing this course, students will be able to:

· Use Macros

· Record Macros

· Editing simple commands

· Customizing Quick Access Toolbar and buttons

· Adding Forms Controls to a Worksheet

Course Outline

Module 1: Using Macros

This module gives the introduction of how to execute Macros.

Lessons

· 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

Lab: Using Macros

After completing this module, students will be able to:

· Understand how to execute Macros.

Module 2: Recording Macros

This module explains how to create Macros through usage of recording.

Lessons

· Using the Developer Tab

· Recording a Macro

· Assigning a Shortcut Key

· Using Relative References

· Deleting a Macro

Lab: Recording Macros

After completing this module, students will be able to:

· Record Macros.

· Assign Shortcut Key to Macro.

· Using Relative Reference in Macro Recording.

Module 3: Editing Macros

This module explains how to start editing simple commands within the Visual Basic Editor.

Lessons

· Writing a New Macro

· Entering Macro Comments

· Copying Macro Commands

· Editing Macro Commands

· Typing Macro Commands

· Create Message Box

· Running Macro from the Code Window

· Using the Debugger

Lab: Editing Macros

After completing this module, students will be able to:

· Write simple Macro commands.

· Create message box.

· Insert comments.

Module 4: Custom Button in Quick Access Toolbar

This module demonstrate how to create custom buttons in the Quick Access Toolbar.

Lessons

· Creating a Custom Button

· Adding a Button to Quick Access Toolbar

· Assigning a Macro to a Button

· Changing a Button Image

· Deleting a Custom Button

Lab: Custom Button in Quick Access Toolbar

After completing this module, students will be able to:

· Use custom button in Quick Access Toolbar.

· Assign Macro to custom button.

· Delete custom button.

Module 5: Adding Forms Controls to a Worksheet

This module explains how to create forms control onto a worksheet.

Lessons

· Creating a Macro Button

· Copying a Macro Button

· Formatting a Macro Button

· Moving/Sizing a Macro Button

· Deleting a Macro Button

Lab: Adding Forms Controls to a Worksheet

After completing this module, students will be able to:

· Create forms control for a Macro.

· Format Macro button.

· Delete Macro button.

Before attending this course, students must have:

  • This course assumes that students have some familiarity with Excel.

Guaranteed to Run

2018-03-20 09:00 to 2018-03-23 17:00
Palm Beach County Florida (Instructor-Led)
2018-03-19 09:00 to 2018-03-23 17:00
Secaucus, New Jersey (Virtual Instructor-Led)
2018-03-01 09:00 to 2018-03-02 17:00
Palm Beach County Florida (Instructor-Led)

Course Reviews

No reviews found for this course.

Be the first to write a review