Request Information

 
 
 
 
Content
ICDL Traing Classes in Dubai

Amazing Macros

This one-day course introduces Microsoft Excel 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.

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

Audience Profile

Aimed at information workers who need to learn more in-depth on the techniques of creating time saving Microsoft Excel® macros.

Topics include:
  • 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

Th This module explains how to run a Microsoft Excel® macros. Topics such as how to set macro security, running a macro with shortcut keys and using the visual basic toolbar to run the macro is discussed.

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 1: Using Macros

  • Understand how to execute Macros.After completing this module, students will be able to:
This module explains how to create Macros through usage of recording.

Lessons

  • Recording a Macro
  • Assigning a Shortcut Key
  • Using Relative References
  • Deleting a Macro

Lab 1: Recording Macros

  • Recording a Macro
  • Deleting Macro

After completing this module, students will be able to:

  • Record Macros
  • Assign Shortcut Key to Macro
  • Using Relative Reference in Macro Recording

This module explains how to edit macro in the Visual Basic for Application Editor.

Lessons

  • 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

Lab 1: Editing Macros

  • Editing Macro Commands

After completing this module, students will be able to:

  • Writing a New Macro
  • Entering Macro Comments
  • Copying Macro Commands

This module explains how to assign custom button in QAT.

Lessons

  • Create a custom button
  • Adding a button to Quick Access Toolbar
  • Change a button image
  • Delete a custom button

Lab 1: Custom Button

  • Adding custom Button in QAT

After completing this module, students will be able to:

  • Create a custom button
  • Deleting a custom button
This module explains how to add and work with form controls to worksheet

Lessons

  • 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

Lab 1: Adding form control to worksheet

  • Create a Macro button

After completing this module, students will be able to:

  • Create a marco button
  • Format a macro button
Trainer : Tauqeer Faiz
IT Instructor, Al Dar University College

Get A Call Back