AUTOMATING EXCEL USING VBA

Dates:	September 24 - October 3, 2024
Meets:	Tu and Th from 6:30 PM to 8:30 PM, 4 sessions
Hours:	8.00
Location:	West Junior High
Instructor:	James Thomas
Fee:	$74.00  Fee Breakdown

Computers will be available, or you can bring a laptop with Office 2010 or later. If you do not bring your own laptop, please bring a thumb drive to save your work. 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. If you are attending class at a Boise Schools location, a Community Ed site coordinator will be at the entrance to direct you to your classroom. MASKS ARE OPTIONAL IN OUR SCHOOLS.

Course Description

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. 

Computers will be available, or you can bring a laptop with Office 2010 or later. If you do not bring your own laptop, please bring a thumb drive to save your work.

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+