Community 50476B:

Amazing Macros (Microsoft Excel 2007 & 2010)

Length:1 Days
Published:June 11, 2013
Language(s):English
Audience(s):Information Workers
Level:200
Technology:Microsoft Excel 2010
Type:Course
Delivery Method:Instructor-led (classroom)
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 OutlineModule 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.
Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community. Preparing for an exam now? Find your Microsoft Certification Study Group. Talk to us on these social networks:

Find a Microsoft Learning Partner near you

Find Training Near You

Location:

Eg: Seattle, WA or Paris, France