News

Azure For IT Professionals

Learn more about implementing Azure as part of your infrastructure.

Staying Sharp on Microsoft Office Can Save Time & Money

Learning the latest Microsoft Office tips and tricks can benefit you greatly.

"How do I determine if this new technology is for real?"

Michael Bird explains how to navigate new technology waters.

CONTACT US
Training partners

Spindustry Training

spindustrytraining.com - (515) 334-9556

Bookmark and Share

Microsoft Office Excel 2013: Intro to Macros Workshop

Course Code: STT-EXMACR
Length: 1 Day
Tuition: $99.00

Schedule for this Course

 DateLengthLocation
Register 01/23/2019 8:30 AM - 4:30 PM
Instructor: Pamela Smith
1 Day Des Moines

Course Description:

Learn the basics of automating tasks with macros which save time and increase your productivity.

Topics include:

  • Record and run a macro
  • Display and edit macro instructions
  • Add a macro to the toolbar or worksheet
  • Declare variables and add remarks to VBA code
  • Prompt for user input by using Message Boxes and Input Boxes
  • Use the if… then… else statements and Control Loops
  • Place Controls on a Worksheet

Prerequisites

N/A

Course Outline:

Course Outline:

  1. Display Developer Ribbon & Customize Quick Access Toolbar
  2. Create and Use Personal Macros
    • Record a Personal Macro
    • Add Personal Macro to Quick Access Toolbar
    • Modify a Personal Macro in the Visual Basic Editor
  3. Explore Differences in Absolute and Relative Reference Macros
    • Create a Relative Macro
    • Create an Abosolute Macro
  4. Create and Use Workbook Macros
    • Record Workbook Macros
    • Add a Macro Button to Current Workbook’s Quick Access Toolbar
    • Create Macro Buttons on Current Worksheet
  5. Use the Visual Basic Editor to Declare Variables, Add Remarks and Prompt for User Input
  6. Create an If..then..else statement in the Visual Basic Editor
  7. Use a Control Loop in a Macro
    • Use the Do… Loop Structure
    • Use the For… Next Structure
  8. Place Controls on a Worksheet
    • Work with the Combo Box Control
    • Work with the Check Box Control
    • Link a Control to Worksheet Data

back to top