addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramlinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

Excel VBA workshop I: get started

Taught by David Romoff

Topics include:
Quick tour of keyboard shortcuts, Named ranges, Named ranges as related to data control and calculations, Array calculations, Vlookup and match Data tables. Macros and Buttons and user interface ideas. A fun Macro Example. Plus VBA Concepts such as  Variable Declaration, Reading Ranges, Controlling Alerts,FunctionsR and Excel Interface Pivot Tables and Charts.

Description:This is a hands-on workshop intended to introduce concepts for working with Excel and VBA.  Familiarity with Excel is recommended and probably necessary to get the most from the presentation.  In general, a topic will be introduced for about 5 minutes and then you can practice on a sample workbook for about 5 minutes; and then we'll repeat.


Please have an installed version of Excel ready to go.  Also, if you wish to follow along for the brief part where we tour an interface between R andExcel you may wish to download and install RExcel from

Macs: I am not familiar with how Excel performs on Apple products and I do not know if VBA is available on Macs.  My ability to support apple products as related to Excel is limited.

Notes:If there's a topic you're curious about, let me know and I'll prepare and include it.

About Me: David Romoff has worked with Excel and VBA intensely for about 2 years.  While I am not a Professional Excel Developer, I have seen how it used for reporting and analytics at large firms and I'm hoping to share some underlying concepts here.

Join or login to comment.

  • Shangxuan Vivian Z.

    Hey, today's file is at, please download and use it for the workshop.

    March 13, 2014

  • Laura F.

    I'd like to pass along an invitation to an event that I am attending at the Open Society Foundations next week on Technology, Society and the Future of Work. See the following link: They are specifically reaching out to civic tech folks to join the discussion. The event is aimed at fostering a diverse discussion on the future of work with technologists, designers, social innovators, scholars and business leaders. Space is limited. Please RSVP directly to Maggie Corser ([masked]). Feel free to circulate the invitation to others in the New York area that you think might be interested in attending.


    March 13, 2014

  • A former member
    A former member

    I also facilitate an Excel workshop (at universities mostly). If you're interested in learning more, check out

    March 6, 2014

    • Shangxuan Vivian Z.

      Sounds good. Hope you can teach some excel workshops in the group,too.

      March 9, 2014

  • Aaron G.

    Can use LibreOffice or Apple's Numbers for this workshop?

    March 7, 2014

    • David

      I'm sorry, I don't know anything about that software. I think what I will present is specific to Excel.

      March 7, 2014

  • Shangxuan Vivian Z.

    Hi members, I am still looking for a venue for this event. If your firm can sponsor us a space, that will be a big help. Thanks a lot!

    March 5, 2014

Your organizer's refund policy for Excel VBA workshop I: get started

Refunds offered if:

  • the Meetup is cancelled
  • the Meetup is rescheduled
  • you can cancel at least 3 day(s) before the Meetup

Payments you make go to the organizer, not to Meetup. You must make refund requests to the organizer.

Regardless of the refund policy set by the organizer, Meetup may issue refunds on an organizer's behalf if we determine that Meetup's Payment Policies have been violated.

Our Sponsors

  • NYC Data Science Academy

    use"nycopen100ff" coupon to take classes on

  • Supstat

    Supstat shares its expertise in data mining and visualization.

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy