Microsoft Office 2003
Call for Office 2007 (615.460.5554)
|
Course
|
Price
|
Days
|
Dates
|
Introduction Excel |
149 |
1 |
Mar 13 |
Introduction to Visio |
195 |
1 |
Mar 14 |
Introduction Access |
249 |
2 |
Mar 19 & 20 |
Introduction Excel |
149 |
1 |
Apr 1 |
Visio for Business Analyst |
195 |
1 |
Apr 4 |
Advanced Access |
249 |
2 |
Apr 10 & 11 |
PowerPoint |
249 |
2 |
Apr 24 & 25 |
Intermediate Excel |
149 |
1 |
May 20 |
Advanced Excel |
149 |
1 |
May 30 |
Courses Offered:
WORD 2003-Introduction
One-day course
- Creating and Editing Documents
- Copying & Moving Text
- Formatting a Document
- Working with Tables
- Headers/Footers, Columns
- Merging Documents
WORD 2003-Intermediate
One-day course
- Formatting with styles
- Working with Larger Documents
- Working with Graphics
- Creating and Modifying Charts
- Creating and using forms
- Customizing Word with AutoText and Macros
Word 2003-Advanced
One-day course
- Illustrating Documents with Documents
- Creating a Web Site
- Working with Styles and Templates
- Multi-Page Documents
- Integrating Word with Other Applications
- Collaborating with Workgroups
Excel 2003-Introduction
One-day course
- Working with Toolbars and menus
- Designing a Worksheet
- Relative & Absolute Cell Referencing
- Formulas & Functions
- Working with Charts
- Managing Workbooks
Excel 2003-Intermediate
One-day course
- Analyzing List Data
- Enhancing Charts & Worksheets
- Linking Data Between Workbooks
- Sorting List
- Lookup Values
- Sharing Excel Files
Excel 2003-Advanced
One-day course
- Using a What-If Analyzing
- Pivot Tables
- Exchanging Data with other Programs
- Auditing a Worksheet
- Understanding Visual Basic Editor
- Macro Recorder and Programming with Excel
VBA for Excel
Three-day course
- Review of Excel features
- Excel object model & VBA language
- Cell & Range properties
- Using Name properties
- Controls & Event procedures
- Error handling & debugging techniques
Access 2003 First Course
Two-day course
- Creating a database
- Modifying a database
- Sorting, Filtering
- Relational Databases
- Creating Queries & Reports
- Creating Forms & Sub forms
Access 2003 Second Course
Two-day course
- Sharing with other Office Programs
- Creating Advanced Queries
- Creating Advanced Forms & Reports
- External Links
- Creating Macros for Automation
- Maintaining the Database Compact/Repair
VBA for Access
Three-day course
- Review of Access features
- MS Access Objects & properties
- Event driven programming
- VBA modules, functions & subroutines
- DOA methods
- Error handling & debugging techniques
PowerPoint 2003
Two-day course
- Creating a Presentation
- Drawing and Modifying Objects
- Inserting Clip Art & Pictures
- Embedded and Linked Objects
- Slide Show Features
- Hyperlinks
