News

Webinars from Spindustry on SharePoint, MS Teams, and Power BI

Spindustry offers a variety of ways to learn more about solutions to benefit your business. Below is a list of upcoming webinars or pre-recorded sessions that we hope you find helpful.

Five Benefits of Live Instructor Led Training

Five Benefits of Live Instructor Led Training

Experts still agree that there are no viable replacements for having a live professional in the room during training sessions.

Spindustry Training Offers SharePoint Governance Consulting

Avoid costly, time consuming mistakes with your SharePoint installation.


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

There are no dates scheduled for this course.
If you would like to be added to the wait list for this class Click Here

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