SitesPower Training Center - PO Box 13801 Dubai, UAE
SitesPower Training Institute | Dubai : +9714-335-5549 | Sharjah Institute : +9716-575-1315 | معهد تدريب سايتس باور

Enquire About Course

Training Programs | Course Schedule

Printing Instructions

Microsoft Office System 2003 Step by Step
5 day Instructor-Led Course (40 hours)

Course Overview:
•Create and publish professional-quality documents, brochures, and Web pages
•Develop powerful but easy-to-use spreadsheets and databases
•Manage your e-mail communications and workday
•Produce and deliver compelling slide presentations
•Get your Web site up and running quickly
•Learn how to take notes electronically
•Easily capture and reuse information with InfoPath forms
•Work better together using the collaboration features across the Microsoft Office System

Target Audience:

Beg/Int

Book Details:

992 pages, 1 companion CD

Previous Software Versions: MS Office XP, 2002, 2000

Course Outline:

1 Working with Documents
Getting Started with Word
Creating, Saving, and Closing Documents
Opening and Viewing Existing Documents
Deciding Which View to Use When
 

2 Editing and Proofreading Documents
Editing a Document
Using Text Entry Shortcuts
Finding the Best Word
Using an Outline to Rearrange Paragraphs
Finding and Replacing Text
Checking Spelling and Grammar
 

3 Changing the Appearance of Text
Changing the Look of Characters
Changing the Look of Paragraphs
Creating and Modifying Lists
Formatting Text as You Type
Changing the Look of Characters & Paragraphs with Styles
 

4 Presenting Information in Tables and Columns
Presenting Information in a Table
Formatting Table Information
Working with Table Data
Presenting Text in Columns
 

Section II : Microsoft Office Excel 2003
 

5 Setting Up a Workbook
Making Workbooks Easier to Work With
Making Data Easier to Read
Adding a Graphic to a Document
 

6 Performing Calculations on Data
Naming Groups of Data
Creating Formulas to Calculate Values
Finding and Correcting Errors in Calculations
 

7 Changing Document Appearance
Changing the Appearance of Data
Applying an Existing Format to Data
Making Numbers Easier to Read
Changing Data's Appearance Based on Its Value
Making Printouts Easier to Follow
Positioning Data on a Printout

8 Focusing on Specific Data Using Filters
Limiting the Data That Appears on the Screen
Performing Calculations on Filtered Data
Defining a Valid Set of Values for a Range of Cells 

Section III : Microsoft Office Access 2003
 

9 Creating a New Database
Creating a Database Structure the Simple Way
Checking the Work of a Wizard
Creating Tables the Simple Way
Refining How Data Is Displayed
Manipulating Table Columns and Rows
 

10 Simplifying Data Entry with Forms
Creating a Form by Using a Wizard
Refining Form Properties
Refining Form Layout
Adding Controls to a Form
Using Visual Basic for Applications to Enter Data in a Form
Creating a Form by Using an AutoForm
Adding a Subform to a Form
 

11 Locating Specific Information
Sorting Information
Filtering Information in a Table
Filtering By Form
Locating Information That Matches Multiple Criteria
Creating a Query in Design View
Creating a Query with a Wizard
Performing Calculations in a Query
 

12 Keeping Your Information Accurate
Using Data Type Settings to Restrict Data
Using Field Size Properties to Restrict Data
Using Input Masks to Restrict Data
Using Validation Rules to Restrict Data
Using Lookup Lists to Restrict Data
Updating Information in a Table
Deleting Information from a Table

Section IV : Microsoft Office PowerPoint 2003
 

13 Creating Presentations
Getting Started with PowerPoint
Opening, Saving, and Closing a Presentation
Viewing a Presentation
Creating a Presentation Based on Content
Creating a Presentation Based on Design
Creating a New Blank Presentation
 

14 Working with Slides
Creating Slides and Entering Text
Changing the Layout of a Slide
Inserting Slides from Another Presentation
Rearranging a Presentation
Entering Speaker Notes

15 Working with Slide Text
Adding and Manipulating Text
Changing Size, Alignment, and Spacing
Finding and Replacing Text and Fonts
Correcting Text While Typing
Checking Spelling and Presentation Styles
Choosing the Best Word
 

16 Setting Up and Delivering Slide Shows
Taking a Presentation on the Road
Delivering a Slide Show
Customizing a Slide Show
Adding Slide Timings
Using Microsoft Producer to Set Up an Online Broadcast
 

Section V : Microsoft Office Outlook 2003
 

17 Working with Outlook
Starting Outlook for the First Time
Reading Messages and Opening Attachments
Responding to Messages
Creating New Messages
Using Address Books
Attaching Files to Messages
Sending and Receiving Messages
Printing Messages
Creating and Sending Instant Messages
 

18 Managing E-Mail Messages
Formatting Messages
Changing Message Settings and Delivery Options
Customizing How You View Messages
Managing Messages with Color
Adding Signatures to Messages
Flagging Messages for Follow-Up
 

19 Finding and Organizing E-Mail Messages
Finding and Categorizing Messages
Using Search Folders
Filtering Messages
Managing Messages through Rules
Organizing Messages in Folders
Sharing Folders with Others
Saving Messages in Other Formats
Archiving Messages
 

20 Managing Your Calendar
Looking at Calendars in Different Ways
Scheduling Appointments and Events
Managing and Organizing Appointments
Working with Multiple Calendars
Defining Your Available Time
Labeling Appointments with Color
Printing Calendars
 

21 Scheduling and Managing Meetings
Scheduling Meetings
Responding to Meeting Requests
Updating and Canceling Meetings
Viewing Other Users' Calendars

Saving a Calendar as a Web Page

Section VI : Microsoft Office FrontPage 2003
 

22 Understanding How FrontPage Works
Looking Around in FrontPage
Exploring an Existing Web Site
Looking at a Web Site in Various Ways
Exploring an Existing Web Page
Understanding FrontPage Web Site Concepts
 

24 Presenting Information in Lists and Tables
Creating Bulleted and Numbered Lists
Creating Tables
Entering Information in a Table
Editing the Structure of a Table
Formatting a Table
Splitting a Table into Separate Tables
 

25 Enhancing Your Web Site with Graphics
Adding Pictures to a Web Page
Editing and Formatting Pictures
Creating and Displaying Thumbnails
Adding a Line, Shape, or Drawing to a Web Page
Creating a Photo Gallery
Adding Fancy Text to a Web Page
 

Section VII : Microsoft Office Publisher 2003
 

26 Creating and Printing Publications
Creating a Publication for the First Time
Creating a Print Publication by Using a Design Set
Creating a Publication from a Blank Page
Creating and Using a Template
Printing a Publication
Preparing a Document for a Commercial Printing Service
 

27 Creating Web Sites and E-mail Messages
Creating an E-mail Message by Using a Wizard
Sending a Publication as an E-mail Message
Creating a Web Site from Scratch
Publishing a Web Site
Creating a Web Site from an Existing Publication
Updating a Web Site
Converting a Web Publication to a Print Publication
 

Section VIII : Microsoft Office OneNote 2003
 

28 Taking Notes
Using OneNote for the First Time
Adding Drawings and Images
Finding and Inserting Web Clippings
Adding Pages and Sub Pages
Moving Notes on Pages
Organizing Notes into Sections and Folders
 

29 Working with Notes
Using Quick Notes
Marking Notes with Note Flags
Searching Notes
Sending Notes in E-mail
Creating Outlook Tasks from Notes

Section IX : Microsoft Office InfoPath 2003
 

30 Working with InfoPath Forms
Completing InfoPath Forms
Updating Form Data
Viewing and Sorting Form Data
Importing and Exporting Form Data
Sharing and Publishing Forms
 

31 Designing InfoPath Forms
Modifying an Existing Form
Designing a New Form
Creating Form Views
Validating Form Data

Section X : Collaborating with The Microsoft Office System
 

32 Working in a Document Workspace
Creating a Document Workspace and Managing Workspace Members
Creating and Assigning Document Tasks
Updating a Document in a Workspace
Receiving Alerts When Information in a Workspace Changes
Starting a Discussion in a Workspace
Customizing Your Document Workspace
 

33 Teaming Up in a Meeting Workspace
Creating a Meeting Workspace
Documenting Meeting Objectives and Agenda Items in a Workspace
Posting Meeting Materials to a Workspace
Creating and Assigning Meeting Tasks
Customizing a Meeting Workspace