Name: Excel VBA workshop I: get started
Start: 2014-03-13T19:00:00-04:00
End: 2014-03-13T21:00:00-04:00
Location: SumAll Foundataion SumAll.org

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.

Vivian Zhang

AI Professionals New York - AI Transformation & Adaptation

Technology

Machine Learning

Cloud Computing

Data Science

Artificial Intelligence

Artificial Intelligence Machine Learning Robotics

Artificial Intelligence Programming

Artificial Intelligence Healthcare

Robotics

Future Progress in Artificial Intelligence

AI and Society

AI Algorithms

Excel VBA workshop I: get started

SumAll Foundataion SumAll.org

Share

AI Professionals New York - AI Transformation & Adaptation

Excel VBA workshop I: get started

AI Professionals New York - AI Transformation & Adaptation

Details

Members are also interested in