Microsoft Excel 2003 VBA Training
|
Summary
|
|
|||||||||||||
Microsoft Excel 2003 VBA Training
Microsoft Excel 2003 VBA - 2-day training course
This Microsoft Excel 2003 VBA training courses is designed to teach delegates how to develop applications with Excel's Visual Basic for Applications (VBA) Programming System.
This training course aims at teaching delegates how to build greater functionality into custom applications or to automate cumbersome everyday tasks.
Microsoft Excel 2003 VBA can be delivered On-Site at your location with your facilities, or with Enliten IT's mobile classroom at a time and place to suit you, and the course can be tailor-mdae to suit your requirements.
Find out more about this Microsoft Excel 2003 VBA training course here.
If you want to find out more about Microsoft Excel 2003 VBA Training, you can make an information request below and the school will contact you with further information.
Suitability and application
This Microsoft Excel VBA 2003 training courses is designed for delegates who need to learn how to create sophisticated applications for data presentations using custom dialogue boxes and menus through use of structured macros and macro code.
Prerequitites: It is essential that delegates have attended an Excel Advanced Course or have a similar level of knowledge. Additionally an understanding of Visual Basic would be useful.
Microsoft Excel Training Course Content
This 2-day Microsoft Excel 2003 VBA training course covers the following areas:
· Getting
Started
o Introducing Visual Basic for Applications
o Recording and Running a Macro
o Understanding the VB Editor
o Using the Menu Bar
o Using the Standard Toolbar and Project Explorer
o Using the Properties Window
o Understanding the Code Window Options
o Editing Code
o Getting Help
· Introducing
Objects
o Understanding the Object Browser
o Understanding Objects
o Understanding the Object Hierarchy
o Referencing Objects
o Understanding Collections
· Using the
Editing Features
o Using the Immediate Window
o Using the Auto List
o Using Auto Quick Info
· Introducing
Variables
o Understanding and Declaring Variables
o Understanding Data Types
o Storing Values in Variables
o Storing Objects in Variables
· Creating
Procedures and Functions
o Understanding Procedures
o Using the Macro Recorder to Create Sub Procedures
o Calling Procedures from Procedures
o Using Intrinsic Functions
o Using Message Boxes
o Using Input Boxes
o Creating Functions
o Passing Arguments to a Function
· Working with
Conditional Statements
o Understanding Conditional Statements
o Working with Decision Structures
o Working with Looping Structures
· Working with
Forms and Controls
o Understanding UserForms
o Using the Toolbox
o Working with UserForm Properties, Events, and
Methods
o Using the Properties Window
o Understanding Controls
o Working with the Label Control and Text Box Control
o Working with the Command Button Control
o Working with the Combo Box Control
Outcome / Qualification etc.
On successful completion of this Microsoft Excel 2003 VBA training course delegates will be able to record macros, edit VBA code and build procedures which interact with the user.
Expenses
Enliten IT Training Solutions
Enliten IT provides a wide range of information technology training
- IT Training (End user, Technical, Developer)
- Development (Databases, Web sites, Templates)
- Soft Skills Training
- Consultancy
Enliten IT is a vendor independent IT training services business. Enliten IT have over 23 years of experience in delivering training on Microsoft, Adobe, Oracle, IBM/Lotus, Quark, AutoDesk, Corel, Business Objects and other vendor’s software packages. Enliten IT has trained customers throughout the UK, in Switzerland and Hong Kong.
Enliten IT specialise in a flexible training approach, offering customised solutions, as we recognise that staff training and skills development are fundamental to the growth and development of businesses. Our tailored training programmes are clearly designed, relevant and focused to meet the specific needs of our customers.
In House Training anywhere in the UK with our Mobile Classroom
Enliten IT provide In House / On site training
courses, that can be completely customised to your organisation, and
are delivered on your site, in your working organisation. Additionally
Enliten IT has invested in creating a mobile classroom that is
proving to be a flexible and effective training solution for companies
all over the UK.
Transform your conference/meeting rooms into a classroom in a matter of
minutes and be more productive by investing in your staff skills. Our
mobile classroom
of laptops means that training can be delivered on-site anywhere in the
UK, and is an extremely
cost-effective way of meeting a training need.
Starting with a Training Needs Analysis designed to target training with pinpoint accuracy, we will transfer the knowledge and skills required by your staff to help them perform their jobs more effectively.
Trainers that are all members of the Institute of IT Training (IITT)
Enliten IT pride themselves in providing quality value for money
solutions.All Enliten IT trainers are members of the Institute of IT Training (IITT) -
the main standards body for IT Trainers in the UK covering all aspects
of training, development and delivery. You can be aassured your training will be quality as Enliten use only the best trainers and consultants, who are not only technically adept within their areas of expertise,
but are also versed in educational methodologies thereby ensuring
your staff get the most out of their training experience.
Show all courses with
Enliten IT Training Solutions
Request information - obligation free
Contact information for Enliten IT Training Solutions
Phone no: +44 (0) 845 108 5481 
To request information from Microsoft Excel 2003 VBA Training, please fill out the following details:
