|
|
|---|---|
.JPG)
Training - Office Automation
Modes
I offer public training courses - where you can join users from other organizations in a common shared-cost day or more of training.
I offer private training courses - where you as an individual, or as an organization, can benefit by focusing on a training course customized to your needs.
I offer FREE correspondence training courses - where you as an individual can receive emails at a rate best suited to your needs, on a variety of topics. Such courses are designed to give you an introduction to a complex topic such as VBA, or to boost and refresh your skills (for example "Windows Tips") without having to leave your desk.
General Information
Course Title: Office Automation
Instructor: Chris Greaves
Duration: Two days
Prerequisites: Familiar with use of Microsoft Word 2000 or later; Familiar with use of Microsoft Excel 2000 or later;
Contact: www.ChrisGreaves.com; 416 621 9348
Description: Immediate 20% increase in productivity through better use of Word and Excel. Move beyond the typewriter-calculator mentality into the realm of Information Engineering.
Chris Greaves Policy Statements
All our training carries full, Lifetime Technical Support.
Learning Outcomes
By the end of this course you will be 20% more effective in your use of Word and Excel. In particular you will be able to automate many of your regular daily or weekly tasks by using built-in automation tools of Microsoft office and by developing simple macros.
Course Content
The course starts with little-known but powerful built-in features of Word and Excel. We take an especial interest in reducing the drudgery of keying-in text and data. Following that we look at automated mechanisms to take care of formatting and other important cosmetic issues. We finish off with a solid introduction to macros, stressing the techniques that allow us to write macros that work right the first time every time.
Module (1) Word fields, keyboard macros, autocorrect, styles
Module (2) Excel range names, professional data entry techniques, styles
Module (3) Word macros
Module (4) Excel macros
Module (5) Word compound macros, keyboard and toolbar assignment.
Module (6) Excel compound macros, keyboard and toolbar assignment.
Module (7) Data-entry forms for Word and Excel
Module (8) Application development – a healthy introduction
Instructional Method
Each module consists of short introductory statements followed by a sedate walk-through of the procedures involved. This is followed by student exercises, performed by each student with the assistance of the instructor. Each walk-through and each exercise, with a solution where appropriate, is included in the course materials.
Course Materials
A course workbook is supplied [as PDF on CD]; a hard-copy list of topics and exercises is supplied. Data and examples are supplied on a CD for each student.
There is a gap of at least one week between the first day and the second day. This gap is provided expressly so that the student can practice skills learned in the first day before using those skills in the second day.
Assignments and Evaluation
There are no assignments and no evaluation. Chris Greaves can be reached by telephone and email in the interval between training days for purposes of reinforcing the skills learned in Day 1.
Loading
Toronto and Mississauga, Monday, March 21, 2011 9:03 AM
Copyright © 1996-2011 Chris Greaves. All Rights Reserved.