VBA for Excel part 4 of 4

VBA for Excel

Training Event Level 1

Learn to use Visual Basic for Applications (VBA), and you can expand the already awesome power of Excel

If you're already an experienced Excel user, this training will make you an Excel master. You'll learn a new approach to Excel and the steps involved in developing a new spreadsheet application. You'll also discover how to develop VBA subroutines and functions, use advanced programming techniques, and more.

You will learn how to:

• Create powerful Excel apps with VBA

• Develop user-friendly dialog boxes

• Enhance Excel with custom worksheet functions

• Write event-driven VBA cod

For level 1 there will be 4 three hour classes

Class 1 January 17, 2016 11am-2pm

Class 2 January 24, 2016 11am-2pm

Class 3 February 7, 2016 11am-2pm

Class 4 February 21, 2016 11am-2pm

Students bring own laptops. Only software needed is Excel (IDE is built-in). ver 2010 or 2013. Ver 2007 is OK but some things are different. 2003 should not be mixed into a group w/ modern versions.

Level 1 Covers

Intro and Excel Review topics

Macros

IDE / Editor

Range ref 1

Range ref 2: R1C1

Named ranges

Properties and methods of ranges

Collections, For…Each

Projects – Level 1

The cost of the class is dependent on the number of people that decide to join. The instructor has a flat fee of $50 per hour regardless of how many attend. The curriculum above is 12 hours of training so that would be $600 paid to the instructor. If there are 6-8 people that sign up that would be $75-100 for the training. This is an unbelievably inexpensive price for the learning that will be provided (ONLC Training Center charges $1,200 for an 18 hour class on the same subject).

Hope to see you there!