Welcome to DMACC Continuing Education
Intro to Excel Macros | |
---|---|
CRN: 32450 Location: Zoom Course/Section: DATA591 300 Date: 06/23/2022 - 06/23/2022 Room: Instructor: Smith Pamela Time: 09:00AM - 12:00PM Days: Thursday Contact Hrs: 3 hours |
|
Description: | |
Many repetitive tasks can be simplified by creating a macro. This course will introduce you to macro creation and give you the tools to automate repetitive tasks. You will discover how to display the Developer Ribbon and customize the Quick Access Toolbar, create and use personal macros, create a Relative macro and an Absolute macro, create and use workbook macros, use the Visual Basic Editor to declare variables, add remarks and prompt for user input, and create an If..then..else statement in the Visual Basic Editor. Book included. Prerequisite: Intermediate Excel course or equivalent knowledge. A day or two before the course start date you will receive an email with the Zoom link, handout and exercise files that will be used during class. | |
Available Seats: 10 Fees: $69.00 | |
Back | Add |