Learning and Development Center

MS Excel Macros 2010


Purpose

Are you proficient with Excel, but need to do more in less time? Do you find yourself entering the same data and repeating the same formatting over and over? Would you like to move to other parts of your spreadsheet with one click of the mouse instead of scrolling or using the Go To command? Would you like to make data entry easier and with little chance of error? If you answered yes to the above questions, Excel Macros is for you.

Learning Outcomes



Make Excel work better for you by:

  • Creating, modifying and running a Personal macro
  • Creating, modifying and running a Workbook macro
  • Entering Visual Basic for Applications code
  • Creating a data prompt, and conditional statement
  • Adding a check box and combo box to a worksheet
  • Linking a control to data
  • Content

    This course focuses on:

  • Creating, modifying, and running personal and workbook macros
  • Entering VBA code in the Visual Basic editor
  • Adding controls such as checkboxes and combo boxes
  • Linking controls
  • Methods

    This hands-on, interactive class includes a step-by-step manual to use in class and as a reference at your office. This manual includes many best practices in working with Excel macros. Class files are sent to participants to use for review and practice.

    Number of Sessions

    7 hours/ 1 Sessions

    Time

    8:30 a.m. – 4:30 p.m.

    City Charge Non-City Charge Minimum Capacity Maximum Capacity
    $35 $100 5 12-14

    Audience

    Anyone who needs to create, modify and run macros to perform repetitive tasks and/or add features such as conditional statements and check boxes.

    Prerequisites Pre-Test Post-Test Credit(s)
    None Yes Yes 0.7 CEUs

    Contact Information: Learning and Development Center | 4501 Leeland Street | Houston, TX 77023 | Phone: 832-395-4900 | Fax: 832-395-4892 | Hours of Operation: Mon-Fri: 6:30 a.m. – 5 p.m.


    Connect With Us