| MS Office 2003 or 2007 |
 |
| Duration: 4Weeks @ 2days/Week |
 |
| Course Contents: |
- MS Access
- MS Excel
- MS PowerPoint
- MS Word
|
| MS Access 2003 or 2007 |
 |
| Table of Contents: |
- Database Fundamentals
- The User Interface
- Creating Databases
- Creating Tables
- Working with Table Records
- Creating Relational Databases
- Using Select Queries
- Calculations in Your Queries
- Creating Forms and Controls
- Creating and Using Reports
- Enhancing Forms and Reports
- Working with External Data
- Adding Security
- Access and the Web
- Speed Up a Database Application
|
| MS Excel 2003 or 2007 |
 |
| Table of Contents: |
- Introduction
- Getting Started
- Creating Workbooks
- Modifying Worksheets
- Formatting Worksheets
- Printing Workbooks
- Working with Formulas
- Working with Basic Functions
- Enhancing Worksheets
- Using Templates, Styles and Auto formats
- Charts
- Finding and Replacing Data
- Importing and Exporting Data
- Using Multiple Worksheets
- Manipulating the Screen Display
- Working with Advanced Functions
- Formulas and Text
- Pivot Tables
- Macros
- We teach you 120 formulas
- Briefing with VB Script
|
| MS PowerPoint 2003 or 2007 |
 |
| Table of Contents: |
- Getting Started
- Beginning a Presentation
- Formatting Text Slides
- Working with Tables and Charts
- Adding Organization Charts and Diagrams
- Adding Images to a Presentation
- Modifying Objects
- Adding Special Effects
- Creating Templates
- Creating Web Presentations
- Collaborating in PowerPoint
- Preparing to Deliver a Presentation
- Delivering a Presentation
- Printing
- Getting Help
|
| MS Word 2003 or 2007 |
 |
| Table of Contents: |
- Introduction
- Getting into Word
- Creating and Saving Documents
- Editing Documents
- Formatting Text
- Styles
- Using Automatic Text Features
- Formatting Paragraphs
- Formatting Document Pages
- Using Find and Replace
- Using Proofing Tools
- Taking Control of Your Documents
- Using Shared Workspaces
- Printing Documents, Envelopes and Labels
- Working with Graphics
- Working with Columns
- Working with Tables
- Working with Templates
- Integrating Word Files with Other Applications
- Getting Help
- Working with Toolbars
|