Microsoft Excel 2007 Advanced (Available in French and English)

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.

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 Bessy S. 2011

   

The classroom was cold

Reviewed by Abiola B. 2011