50476-B: Amazing Macros (Microsoft Excel 2007 & 2010)

Course Modality

Instructor-led (classroom)

Course Level

Intermediate

Course Time

1 day

Course Language

English

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

Prerequisites

Before attending this course, students must have:

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

 

Intended Audience

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

Why The DataTech Labs ?

Self-Paced Online Video

A 360-degree learning approach that you can adapt to your learning style

A 360-degree learning

Engage and learn more with these live and highly-interactive classes alongside your peers

24/7 Teaching Assistance

24/7 Teaching Assistance Keep engaged with integrated teaching

Online Practice Labs

Projects provide you with sample work to show prospective employers.

Applied Projects

Real-world projects relevant to what you’re learning throughout the program

Learner Social Forums

A support team focused on helping you succeed alongside a peer community

Skill Covered

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

Get In Touch

Course Curriculum

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.

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

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

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.

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

Reviews

Get in touch, enquire now!


By submitting this form, I consent to the processing of the personal data that I provide The Data Tech Labs Inc. in accordance with and as described in the Privacy Policy.

© 2020 The Data Tech Labs Inc. All rights reserved.

TDTL-arrow
[glt language="Arabic" label="Arabic" image="yes" text="yes" image_size="24"]
[glt language="English" label="English" image="yes" text="yes" image_size="24"]
[glt language="French" label="French" image="yes" text="yes" image_size="24"]
[glt language="German" label="German" image="yes" text="yes" image_size="24"]
[glt language="Hindi" label="Hindi" image="yes" text="yes" image_size="24"]
[glt language="Marathi" label="Marathi" image="yes" text="yes" image_size="24"]
[glt language="Spanish" label="Spanish" image="yes" text="yes" image_size="24"]

Microsoft Power Platform App Maker

Designing & Implementing Azure AI Solution

Microsoft Azure Administrator

Developing Solutions For Microsoft Azure

Microsoft Azure Architect Design Exam

Implementing Azure Data Solution

Administering Relational Databases On Microsoft Azure