Name: VBA EXPERT
Start: 2016-11-30T09:00:00-08:00
End: 2016-12-01T17:00:00-08:00
Location: Confidential until registration

PRACTICAL DETAILS

Prerequisite: Intermediate MS Excel level
Time: 2-day workshop​ (From 9am to 5pm with an hour for lunch and two 15 minute breaks)
When: Nov. 30th & Dec. 1st 2016
Where: Kitsilano, Vancouver
Price: $850 (breakfast & lunch included)

Maximum of 10 students per class

IMPORTANT Please RSVP before November 28th: http://www.vba101.com/schedule-vba-expert

KEY FEATURES

In this advanced VBA workshop, we cover the following topics:
​- Automatically create complex and dynamic userforms
​- In-depth knowledge of the powerful listbox control
​- Using arrays to manipulate large table much faster than Excel alone

COURSE CONTENTS

Automatic creation of dynamic UserForms​
- Programmatically and dynamically add controls such as TextBoxes and ComboBoxes on a userform
- Automatically manage the controls
- Use class module

In-depth knowledge of the powerful listbox control
- Basic level : fill-in the listbox, manage interactions between listboxes
- Intermediate level : manage multi-culumns, transfer data from one list to another, managing titles
- Advanced level : filtering listboxes, drag and drop elements

​ Using array in VBA
- Overview of arrays
- Practical use of array
- Library of array functions

​You need to bring your own computer at the workshop and have MS Excel. All the versions of MS Excel from Excel 2007 to 2016 are accepted. We work preferentially with Windows but other operating systems are welcome.

ABOUT THE SPEAKER

Gaëtan has a PhD in Management of Information Systems from Paris Dauphine University and Georgia State University. For more than 20 years, he has been teaching VBA, reporting and advanced use of MS Excel in the best European and North American Universities such as IESEG School of Management, Strasbourg University, GSU... Just the past month he taught VBA and Excel to more than a hundred of students!

Gaëtan developed over 80 applications for MS Excel for various industries (e.g. insurance, bank, textile) and domains (e.g. marketing, management, finance).​

IMPORTANT

Please RSVP before November 28th: http://www.vba101.com/schedule-vba-expert

QUESTIONS?

Contact Océane DE DECKER, at contact@vba101.com or 778 708 1798
www.vba101.com (http://www.vba101.com/)

Oceane DE DECKER

Vancouver Excel Power Users

Technology

Data Management

Computers

Big Data

Data Analytics

Computer Training

Data Visualization

Data Mining

Microsoft Excel

Microsoft Office

Spreadsheets

Microsoft Excel PowerPivot

VBA EXPERT

Confidential until registration

Share

Vancouver Excel Power Users

VBA EXPERT

Vancouver Excel Power Users

Details

Members are also interested in