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.

Preparation:

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 

http://rcom.univie.ac.at/

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 http://nycdatascience.com/excel/Excel%20VBA%20Workshop.xlsm, 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:
    futureofworkinamerica.org/end-of-jobs-march19 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.

    Best,
    Laura

    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 www.thekeycuts.com/shop/excel-classes

    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.

Our Sponsors

  • NYC Data Science Academy

    Offers speakers and presenters as well as discounts on its classes

  • Supstat

    Supstat shares its expertise in data mining and visualization.

People in this
Meetup are also in:

Create a Meetup Group and meet new people

Get started Learn more
Allison

Meetup has allowed me to meet people I wouldn't have met naturally - they're totally different than me.

Allison, started Women's Adventure Travel

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