vba programming with microsoft excel

qa ltd.
aberdeen, birmingham, bristol, edinburgh, exeter, glasgow, leeds, london, manchester, slough, united kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' many companies have made a major investment in excel spreadsheets to support their business. however, few organisations realise the potential for improved efficiency and effectiveness that can be realised by programming with excel and visual basic for applications (vba). this combination allows for the development of custom spreadsheet applications, which can extend the functionality of excel and its user interface.

through the mixture of lectures and practical sessions you will practice all the significant aspects of excel-based application development with visual basic for applications. delegates will learn how tocomplete, robust applications.

prerequisites
delegates must have used excel for at least three months.
an understanding of programming concepts, such as looping, conditional statements and variables, is essential. required programming skills can be obtained by attending the 2-day qa-iq course “Introduction to programming with visual basic for applications�(qavbaint).

programmers, systems analysts and support professionals who want toand support custom spreadsheet applications using microsoft’s visual basic for applications.
this course is not suitable for excel users without programming experience (see prerequisites section).
this course is relevant for any version of microsoft office from 97 to 2003



delegates will learn how to
use microsoft excel to develop applications that aggregate, analyse and present data in a user-friendly fashion
write procedures in vba to control the wide variety of object types that excel and microsoft office make available
write code in ways that make the application easier to maintain
develop a professional user interface for an excel-based application
protect an excel-based application from interference by its users


course outline


introduction
using the excel macro recorder and the visual basic editor toand modify macros; customising menus and toolbars to run macros.

the vba language
simple input and output; declaring and using variables of appropriate data types; controlling the flow of the program; debugging techniques and aids.

using excel’s objects
objects, properties and methods; collections of objects; excel’s object hierarchy; object browser and online help; useful properties and methods of the application object; working with workbooks and sheets; special vba statements for working with objects.

using procedures
program design; scope and lifetime of variables; passing parameters to procedures; event procedures; functions; writing functions to be used in worksheet formulas; error handling.

working with worksheet ranges
identifying a range; range object properties and methods; formatting; navigating around a worksheet; improving on the macro recorder.

designing user forms
uses of different control types; displaying a user form; validating user input; using built-in dialogs.

the user interface
using controls on worksheets; creating and modifying commandbars by program; using event procedures to set up the desired environment; protection; hiding excel’s interface; providing help; making an add-in.

getting data into excel
using microsoft query; querytables and parameters; use of ado objects to access databases; importing from text files; importing data from web pages; using links.

analysing data
sorting; filtering; excel’s data analysis functions; pivot tables.

presenting results
charting; chart object model; creating generic charts; pivotcharts; report generation by controlling microsoft word; sending results by email; publishing to the web. ...''

Elements of this syllabus are subject to change.

Phone:0844 871 2080

School Address:

tel: 0844 871 2080
e-mail us: info@qa.com

Jobs & Resumes: aberdeen, birmingham, bristol, edinburgh, exeter, glasgow, leeds, london, manchester, slough
Houses & Roommates: aberdeen, birmingham, bristol, edinburgh, exeter, glasgow, leeds, london, manchester, slough
Travel Agencies: birmingham, bristol, edinburgh, leeds, london, manchester,

Search other schools for vba programming with microsoft excel training resources.

visio 2002 professional level 1
visio 2002 professional level 2
visio 2002 standard basic
project 2002 level 1
project 2002 level 2
access 2003 vba
excel 2003 vba
vba
publisher 2003 intro
word 2003 vba
access 2007 level 1
access 2007 level 2
access 2007 level 3
access 2007 level 4
SharePoint 2007 Advanced
excel 2007 level 1
excel 2007 level 2
excel 2007 level 3

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.