Microsoft 2007 Excel VBA Training
|
Summary
|
|
|||||||||||||
Microsoft 2007 Excel VBA Training
Microsoft Excel 2007 VBA - 2-day training course
This Microsoft Excel 2007 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 2007 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 2007 VBA training course here.
If you want to find out more about Microsoft 2007 Excel 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 2007 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 2007 VBA training course covers the following areas:
· Getting
Started
o Recording VBA
o Buttons to Run Macros
o Macro Security
· Visual Basic
Editor
o Overview of Menus and Toolbars
o Project Explorer
o Local, Immediate and Watch Windows
o Short cuts
o Object explorer
o Addins to the Editor
· Programming
Basics
o Objects, Properties and Methods
o Comments
o Code Layout
o Location of Code
o Subs, Functions and Events
· Excel Object
Model
o Range Object
o Worksheet Object
o Workbook Object
o Events
o Add-ins
o Worksheet Functions
· Ribbons
o Using Custom UI Editor
o Adding New Ribbons
o Adding Groups and Buttons
· Programming
Structures
o Sub and Function Statements
o Decision Code
- If Statement
- Select Case
Statement
- Loops
- Do Loop
- For Loop
- For Each
Loop
o With Statement
o Msgbox and Inputbox
· Variables
o Naming Variables
o Types of Variables
o Using Parameters
o Variable Lifetime and Scope
· User-Defined
Forms
o Basic Form Design
o Form Handling and Events
· Error
Handling
o Trapping Errors
o Err Object
o Debugging Techniques
· Development
Process
o Modular Code
o Flow Control
o Test Plans
- Gold Plating
Outcome / Qualification etc.
On successful completion of this Microsoft Excel 2007 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 2007 Excel VBA Training, please fill out the following details:
