50476B Amazing Macros (Microsoft Excel)

250€

About this course

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 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

Continutul cursului poate fi adaptat in functie de necesitatile si/sau specificul cursantilor. Totodata, editia de curs poate fi aleasa de catre cursanti inainte de inscierea in cadrul grupei: 2010/2013/2016.

La finalul fiecarui curs, fiecare persoana va primi o diploma ce atesta participarea in cadrul respectivei grupe de curs, Certificate of Achievement, elaborata de ITAdviser, Microsoft Certified Partner on Learning Solutions. Diploma are recunoastere atat la nivel national cat si international.

Detalii curs

  • Durata 1 zi
  • Nivel 200
  • Limba curs Engleza/Romana
  • Limba suport Engleza
  • Cursanti/grupa 10
  • Examen
  • Certificare
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