Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 4


In this 2-day instructor-led course you will learn: Creating macros using the macro recorder & Visual Basic programming. Creating forms using the Microsoft Excel Forms toolbar. Creating user forms or more precisely, user interfaces.

  • Date: Jun. 4
  • Location: Montreal (Map)
  • Time: 9:00 am - 4:30 pm
  • Duration: 2 days
  • Delivery Method(s):Instructor Led
  • Discount Seats Available:2
  • Category:Microsoft Excel Training

 
Course Outline
Creating macros using the macro recorder and Visual Basic programming. Creating forms using the Microsoft Excel Forms toolbar. Creating user forms or more precisely, user interfaces.

Course Outline Day 1 : Macro-Commands:
    Automating routine tasks;
    Running macros;
    Modifying macros;
    The Personal Macro Workbook and execution errors.

Introduction to VBA - Part 1:
    Why VBA?;
    Object properties and methods;
    Creating a procedure;
    Using objects;
    Variables and constants;
    The Function procedures

Day 2: Introduction to VBA - Part 2:
    Specifying control structures;
    Exploring objects and managing errors;
    Using Excel or VBA functions or functions customized in VBA;
    Varied and interesting procedures;
    Practical tips for optimizing your code;
    Exercises.

User forms:
    Working with user forms;
    Manipulating the sheet's controls;
    The code linked to the user form.

Excel Specifications and Limits

Bibliography

Web Site

Additional Details
Pre-Requisites

Microsoft Excel 2007 Intermediate.

Certificates offered

Certificate of completion


Cancellation Policy
All registration cancellations made within five (5) working days of the date of the course are billable at 100%. Synesis reserves the right to cancel any public courses due to lack of sufficient participants.
Map & Reviews
Synesis
[ View Provider's Profile ]

Synesis Inc.
2075 University
5th Floor

Montreal, Quebec
Canada   H3A 2L1


Reviews
 

We have not received any reviews specific to this course as yet, however here are some reviews of the training vendor.

I would DEFINITELY recommend this to my co-workers.
Reviewed by 2011
The classroom was cold
Reviewed by 2011
4-June-2012 $400 Regular Price $500 Register for this course

Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer.

Not interested in this Course?

Tell us why:

This page has been viewed 14 times.