Brightmoon Consulting & Training

  • Home
    • Gallery
    • Testimonial
  • Contact Us
  • Home
    • Gallery
    • Testimonial
  • Contact Us
Microsoft Excel Macro

Do More with Excel Macro

Duration: 1 Day
Contact Hours: 7

Course Mode

  • Lectures
  • Hands-on
  • Mini-project

Target Audience

  • Office administrator
  • Secretaries
  • Managers
  • General PC users who intend to enhance knowledge & ability to do perform better with macro (without VBA programming)

Benefits

  • Without knowing VBA programming, delegates are able to fuse Macro generated to perform desired tasks.
  • Delegates are shown the strategy to uncover the solution

Course Overview

Getting Started with Macros
  • Identifying applicable situations for using macros
  • Recognizing the need for single-action macros
  • Understanding security
  • Short examples of the recording method
  • Overview of other techniques

Running a Macro
  • Running a macro from the Developer tab or the View tab
  • Running a macro from the Quick Access toolbar button
  • Running a macro from a keystroke shortcut
  • Running a macro from an object or clip art

Using Visual Basic for Applications (VBA)
  • The VBA environment and VBA components
  • Creating the Personal Macro Workbook
  • Closing and updating the Personal Macro Workbook

Recording a Macro in Stages
  • Recording a simple macro
  • Expanding a macro with the if statement

Creating Non-recordable VBA Code
  • Understanding when to use absolute or relative references
  • Using For and For Next statements
  • Using Do While and Do Until statements
  • Creating interactive macros

Macro Project: Converting a Mailing List into a Database List
  • Planning a macro
  • Recording partial code
  • Using loop structures in context
  • Testing a macro in Step mode
  • Pulling the data together
  • Joining two macros
  • Streamlining macros

What’s Next
  • Protect & unprotect macro
  • Sharing macro
  • Backup & Restore macro
  • Benefits of VBA programming


    I'm interested. Let's get connected.

Submit
Powered by Create your own unique website with customizable templates.