Greenfield Community College

Greenfield Community College
0 course(s) in your cart Total: $0
Your cart Your account
General information Course guide home Workforce Development & Community Education home Contact
Automate Tasks with Excel Macros

Automate Tasks with Excel Macros

Instructor: Pioneer Training Instructor
Course time(s): 42404 WFD 120-10: T/Th, 4/24–4/26, 2:00–4:00 pm
$99.00
Seats open
Quantity
Use Excel's power to perform routine tasks with the click of a button! Suitable for those who want to record and customize Excel macros without having to learn the entire Visual Basic for Applications programming language. The class will provide a description of how to record macros and then illustrate a series of techniques for modifying them, including recording and running macros, using loops, using variables, reading and writing specific cells, and customizing recorded attributes, such as print options. Prerequisites: • Experience using Microsoft Excel. • Experience with recording macros in Microsoft Excel and experience with programming concepts is helpful. Course Outline Recording Macros • Using the Macro Recorder • Launching the Visual Basic Editor • Attaching macros to the Quick Access Toolbar Editing a Macro • Changing cell references • Commenting Out Lines of Code • Using the Intellisense editor Modifying Specific Cells • Reading from and writing to specific cells. • Obtaining input from the user when the code is run. • Using variables for calculations and concatenations of various input. Using Loops • Repeating a series of actions for a specific number of times • Using While loops to repeat a series of actions for an entire list • Stepping through a series of cells
Foundational Manufacturing
Sorry, online registration is unavailable. Please read the full workshop description to find out how to participate.
1C Forklift Renewal
$99.00
Seats open
HAZWOPER Refresher
$199.00
No sessions currently scheduled; get on our wait list to be notified of our next one!