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
  

---