Microsoft Office 2007 – Windows XP – Word – Excel – Outlook

Objectives

At the end of the course, the participant will be able to navigate the basic functions of Windows, prepare a simple text document in Word, Execute basic operation in Excel, and manage e-mails in Outlook. 

Clientele

The public

 

 

Prerequisites

Basic knowledge of a computer 

Duration

45 hours (6 days)

 

Course Outline

1. OFFICE 2007 NEW FEATURES

  • The Fluent Interface
  • Customizing the Ribbon

 

2. INTRODUCTION TO PERSONAL COMPUTING

  • Windows Operating System
  • Hardware/Software
  • Turning on your PC/ Logging on
  • The Desktop: Document/Original/Application/Folder icons
  • Taskbar 
  • Start Button/Menu
  • Mouse Clicks
  • Moving/Copying files and folders
  • Creating/Renaming/Deleting a file or folder 
  • Parts of a Window: Bars/Buttons/Scroll Bars
  • Resizing/Moving a window
  • Opening/Saving a document
  • Editing text
  • Drag and Drop
  • How to type in Arabic
  • Getting Help
  • Shutting Down

 

3. WHAT’S NEW IN WORD 2007

  • Using the Navigation Pane
  • Text Effects, OpenType Features & Alternative Text
  • Keeping Safe & Opening Unsaved Documents

 

4. GETTING STARTED

  • Menu Bar 
  • Viewing or Hiding Toolbars
  • Shortcut Menus
  • Task Pane
  • Views
  • Working with Files
  • Create New Documents
  • Open Existing Documents
  • Save Documents
  • Rename Documents
  • Close Documents
  • Working with Text
  • Formatting Text and Paragraphs
  • Undo and Redo Options
  • Lists
  • Columns
  • Graphics
  • Print Documents
  • Text Formatting
  • Tables
  • Spelling and Grammar
  • Track Changes
  • Comments
  • Table of Contents

5. WHAT’S NEW IN EXCEL 2007

  • Applying Cross Sheet Conditional Formatting
  • Exploring Data Bar Enhancements
  • Filtering Data
  • Additional Excel Enhancements

 

6. EXCEL FUNCTIONS

  • Spreadsheet Basics
  • Modifying Worksheets
  • Formatting Cells
  • Formulas and Functions
  • Referencing
  • Sorting and Filling
  • Comparing Workbooks
  • Page Properties and Printing
  • Charts
  • Functions & Formulas Fundamentals
  • Errors in Formulas
  • Excel Functions Overview

 

7. WHAT’S NEW IN POWERPOINT 2007

  • Creating Presentation Sections
  • Enhanced SmartArt, Animations & Transitions
  • Creating Video & Broadcasting Presentations

 

8. POWERPOINT FUNCTIONS 

  • Introduction
  • Create a new presentation
  • PowerPoint screen
  • Working with Slides
  • Add content
  • Work with Text and Tables
  • Graphics and Charts
  • Save and Print

 

 

9. WHAT’S NEW IN OUTLOOK 2007

  • Getting Familiar with Interface Updates
  • Monitoring Conversations
  • Taking Control of Your Inbox
  • Simplifying Actions with Quick Steps

 

10. OFFICE WORKSPACE BASICS

  • Basic Window Elements
  • Working with the Ribbon
  • Customizing the Quick Access Toolbar
  • Getting Help
  • Using the Navigation Pane
  • Working with Folders
  • Exploring the Inbox
  • Reading Your E-Mail
  • Replying to an E-Mail Message
  • Forwarding a Message
  • Sending a New Message
  • Adding an Attachment
  • Viewing Sent Items

 

11. MANAGING MESSAGES

  • Flagging Messages for Follow Up
  • Using Multiple E-Mail Accounts
  • Adding a Signature
  • Formatting Messages
  • Setting Message Priorities
  • Setting Delivery Options
  • Printing Your E-Mail
  • Saving Messages

 

12. CONTACTS

  • Adding Contacts
  • Viewing Contact Information
  • Modifying and Deleting Contacts
  • Creating a Distribution List
  • Sending a Message to a Contact
  • Printing Contact Information
  • Exporting Contact Information 

 

13. CALENDARS AND TASKS

  • Viewing Calendar Information
  • Scheduling Appointments
  • Adding Recurring Appointments
  • Exploring Calendar Settings
  • Planning a Meeting
  • Scheduling a Meeting
  • Responding to Meeting Requests
  • Publishing Your Calendar
  • Creating Tasks
  • Using the Task Form
  • Viewing Tasks
  • Assigning Tasks to Others
  • Responding to Task Requests
  • Delegating Tasks to Others
  • Using the Journal
  • Manually Recording Journal Entries
  • Viewing Journal Entries

 

14. ORGANIZING INFORMATION

  • Keeping Notes
  • Managing Folders
  • Copying Items among Folders
  • Locating Items
  • Creating Categories
  • Arranging Items
  • Organizing Folders
  • Designing Custom Views 
TOP