This event has ended

Make it Easy: Using VBA to Automate Tasks

General Assembly

Wednesday, March 14, 2012 from 6:00 PM to 7:30 PM (COT)

New York, United States

Ticket Information

Ticket Type Sales End Price Fee Quantity
Single Ticket Ended $30.00 $2.49

Share Make it Easy: Using VBA to Automate Tasks

Event Details

Make it Easy: Using VBA to Automate Tasks // TECH 131

Dan Kozikowski, VBA Expert

Wednesday, March 14th from 6:00 - 7:30 pm

As a regular user of Microsoft Excel, Word, PowerPoint, or Outlook, do you ever think to yourself "this repetitive task is so easy that a computer could do it"? If so, then this is the class for you, because the answer is "YES!".
Visual Basic for Applications (VBA) is a simple programming language that was designed to automate interaction with Microsoft Office applications. A working knowledge of VBA enables you to complete lengthy, repetitive tasks instantly.
The class is designed to teach you how to use VBA with three specific, real-world examples, and to empower you to teach yourself even more down the road. The class assumes that you have no programming experience whatsoever, and will also offer a general introduction to basic programming concepts such as variables and functions.
All you need to bring is a computer with Excel, which we'll use to live-code three examples.

We'll review:

Basic programming concepts: variables, functions, and objects
Writing your first line of working code
-Using named ranges to read and write massive amounts of data
-Dynamically changing a cell's color based on its value by using an IF test
-Running 1,000 different scenarios using a WHILE loop

Dan Kozikowski has over seven years of experience using Microsoft Office applications to do things they were never designed to do. For example, he built an end-to-end financial settlement system, and a real-time power price monitoring and notification system in Excel. Dan holds a BA in Computer Science and Philosophy from Dartmouth College and teaches Excel, Introductory Javascript, and VBA classes.

Can't make it? Sign up at http://generalassemb.ly to stay in the loop on future events and classes.

Have questions about Make it Easy: Using VBA to Automate Tasks? Contact General Assembly

When & Where


902 Broadway, 4th Floor
New York, 10010

Wednesday, March 14, 2012 from 6:00 PM to 7:30 PM (COT)


  Add to my calendar

Organizer

General Assembly

General Assembly is a campus for technology, design, and entrepreneurship. We provide educational programming, space, and support to facilitate collaborative practices and learning opportunities across a community inspired by the entrepreneurial experience.

  Contact the Organizer

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.