Layout Table~~~~6923~6923~~

Office 2003 Macros 1 Session - 3 Hours of Interactive Training~
Office Macros 2003 is the perfect intermediate course for Excel users who want to work more efficiently, customize automated workbook tasks and save time. In just one session, Erin Olsen covers the critical features of macros for Excel and Word. This course demonstrates everything from understanding how macros work to creating and using macros in your documents. Erin also explains VBA primer, shedding light on how to write simple code, testing and formatting.

Benefits
• Create professional, informative documents using macros to simplify routine functions.
• Maximize your efforts and save time, contributing to a more efficient workplace.
• Enhance personal productivity and technical credibility. .~~~6923~6924~~

Course Outline Table~~~~6923~6925~~

Session 1~Section A: Using Macros
· Purpose of Macros
· Why Use Macros?
· Where to Use Macros
· Other Options
· Macros 101
· Planning a Macro
· Macros in Office Applications
· Recording Macros

Section B: Word Macros
· How to Record Word Macros
· Record Mode Toolbar
· Recording
· Running a Word Macro
· Editing a Macro
· Organize Styles, AutoText, Toolbars

Section C: Excel Macros
· Recording a Macro
· Absolute and Relative Referencing
· Global Macros
· Running the Macro
· Looking at Code
· Terminology/Syntax

Section D: VBA Primer
· VBA Terminology
· Syntax/Spelling
· Editing a Procedure
· Setting Properties
· Manipulating Ranges and Cells
· Formula Property
· Select Method
· Close Method
· With Statement
· VBA Editor

Section E: Writing Code
· Creating Procedures in Excel
· Sub Procedures/Modules
· Public vs. Private
· Writing Code and Formatting
· With Statements
· Modify Formatting
· Format Range
· Compile Error
· Format Style
· Testing Your Code

Section F: Access Macros
· Tips for Success
· Form/Switchboard
· Macro Container
· Add/Close Mode
· Exit Application
· Attaching Macros to Buttons
· Testing a Macro~~~6923~6926~~

Ordering~~~~6923~6931~~

Office 2003 Macros Training Course by LearnKey~Per Seat Licencing Available

Call 01223 894 136 for quotes for MULTIPLE USERS and Training Centre/Bootcamp & Education Solutions!~~PER USER%3A CD Course|200888|LIBRARY LICENCE%3A CD Course|200885|~6923~6932~excel microsoft end user 2003~