Welcome to Onsite Training - Have a look round!

Feedback Nottingham Home

Excel Macros

 

Up PC Concepts Windows Word Word VBA Excel Excel Macros Excel VBA Access Office Outlook Visual Basic PowerPoint Publisher Pagemaker Photoshop QuarkXPress Project

 

Duration: 1 Day

Objectives:

This course will provide delegates with a good understanding of how macros and user-defined functions can be recorded and edited, or written directly in Visual Basic.

By the end of the course, delegates will be able to create effective macros to automate many aspects of Excel.

Designed for:

The course is suitable for delegates with a good understanding of Excel, especially the use of formulae and functions, multiple worksheets and Range Names.

Description:

Excel macros, written in Visual Basic, offer the possibility of automating and simplifying the use of workbooks, enabling users to remain focused on the business needs and results, rather than the technical details of how a workbook operates.

This course focuses on the essential knowledge required to create and use macros and functions to automate many aspects of Excel.

 

Course Topics

Recording and Running Macros
The Visual Basic Editor
Object Oriented Programming
Programming Techniques
Variables and Functions
Standard Dialogues
Controls on Worksheets

Send mail to admin@onsite.demon.co.uk with questions or comments about this web site.
Copyright © 1999 - 2003  Onsite Training (East Midlands) Ltd