AUTOMATING EXCEL USING VBA
|Dates:||May 4-13, 2021|
|Meets:||Tu and Th from 6:30 PM to 8:30 PM, 4 sessions|
Class will be taught via GoToMeeting. Instructor will email you the meeting code before class. Suggested book (optional): Excel VBA in Easy Steps by Mike McGrath. Students may purchase this book on their own from a book supplier or Amazon if they wish to have it.
THIS COURSE IS NOW CLOSED. FALL SESSION REGISTRATION OPENS AUGUST 22ND. COME BACK AND SEE US!
Sorry, this course is full.
Are you spending hours doing the same Excel analyses just with different data? Radically reduce the time it takes by "automating" repetitive tasks. Did you know that Excel comes with a programming language called Visual Basic for Applications (VBA)? One can automate repetitive tasks. For example, a new batch of data comes in weekly. The boss wants the same analysis that takes you a couple of hours. Writing VBA code will allow you to click a button and the analysis is done in seconds! Must be proficient in Excel and have a desire to learn this programming language.
Suggested book (optional): Excel VBA in Easy Steps by Mike McGrath. Students may purchase this book on their own from a book supplier or Amazon if they wish to have it.
Click on instructor link for biography; ages 18+