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): 44484 WFD 120-70: W-Th, 7/11-7/12, 2:00-4:00 pm, 2 sessions
$99.00
No sessions currently scheduled; get on our wait list to be notified of our next one!
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. Students are asked to bring a thumb drive to save work on.

Prerequisites: 
• Experience using Microsoft Excel. 

Course Includes:
• 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
Fundamentals of Grant Writing
$105.00
No sessions currently scheduled; get on our wait list to be notified of our next one!
Managing Your Grant
$35.00
No sessions currently scheduled; get on our wait list to be notified of our next one!
Amateur Radio Technician License
$15.00
No sessions currently scheduled; get on our wait list to be notified of our next one!
CyberSafe: Protecting Your Data from Security Risks
$99.00
No sessions currently scheduled; get on our wait list to be notified of our next one!
Recovery Coach Academy Training
$699.00
No sessions currently scheduled; get on our wait list to be notified of our next one!