Prerequisites:
Day-to-Day use of MS Office (with emphasize in Word and Excel)
Want to Get More From Microsoft Office? Use
VBA to Customize It!
Learn to use VBA programming to customize and
improve Microsoft Office. This course will demonstrate general
techniques, as well as specific procedures for Word, Excel,
PowerPoint, Access, and Outlook. This course covers the Office
2003 applications, but you can use it to program Office XP and
Office 2000 as well.
Course Description
-
VBA is used
for writing macros, automating Office applications, and
creating custom applications in Word, Excel, PowerPoint,
Outlook, and Access
-
Easily
accessible by novice programmers, VBA is also powerful enough
for IT professionals who need to create specialized business
applications, generating wide interest
-
Includes what
everyone, from power users to system administrators and
professional developers, needs to know
Course Coverage
-
Understanding what
VBA is and what you can do with it
-
Recording and
editing macros in key Microsoft Office applications
-
Creating and editing
code using the Visual Basic Editor
-
Finding the objects,
properties, and methods you need for your code
-
Using variables,
constants, and arrays to store and manipulate data
-
Creating fixed and
indefinite loops to repeat actions
-
Using conditions to
decide between different courses of action
-
Using message boxes,
input boxes, and built-in dialog boxes to interact with the
user
-
Creating custom
dialog boxes and coding their controls
-
Building modular
code for clarity and easy maintenance
-
Testing, debugging,
and improving your code
Automate Your Daily Work Using VBA
Add the Functionality You Need by Programming
Word, Excel, PowerPoint, Outlook, and Access. Build
Custom User Interfaces with User Forms, Menus, and Toolbars.
Attend five hours per week for 10 weeks to total
40 hours
of lecture/workshop training. Weekly worksite implementation
projects hone your skills and additional one-on-one instruction
ensures all your questions get answered! Enrollment is limited.
Apply
Now!
This in-depth program is designed for graduates of previous
PDC Office training and those who already have good working
knowledge of Word and Excel. Each participant must have a
computer loaded with the appropriate software dedicated to
his/her use at work.
Did you know?
U.S. employers spent an average of $647 per employee for
training between May and October 1995. (That's only one-third
of the year!) Extrapolated, that means almost $2000 per year
was spent per employee in the U.S. in 1995. (Bureau of Labor
Statistics, December 1996)
May we help you optimize your
training dollars by providing free state-funded training for
your employees?
|
