Welcome to DMACC Continuing Education
Getting the Most from Excel Macros | |
---|---|
CRN: 14754 Location: Ankeny-Bldg 20 Course/Section: DATA562 100 Date: 09/17/2020 - 09/17/2020 Room: Instructor: Staff * Time: 08:30AM - 03:30PM Days: Thursday Contact Hrs: 6 hours |
|
Description: | |
In this course you will discover the basics of automating tasks with macros which will save time and increase your productivity. You will have several opportunities to practice each concept for maximum understanding and learning. Topics include: record a macro; add new commands to an existing macro; format and assign a macro to a button on a worksheet; change between absolute and relative recordings; display and add comments to document a macro; create conditional statements and control loops using Visual Basic code; and create macros that prompt for user input. Book is included. Prerequisite: Excel Intermediate course or equivalent experience. | |
Available Seats: 10 Fees: $135.00 | |
Back | Add |