Microsoft Office System 2007 Step by Step

5 day Instructor-Led Course (40 hours)
 

Course Overview

• Take control of your day—organize your e-mail, calendar, and meetings
• Learn the essentials for creating effective documents
• Build spreadsheets and perform calculations on your data
• Design database applications to help manage information
• Produce and deliver compelling slide show presentations
• Organize and format text to craft professional-quality documents

Your all-in-one learning experience includes:
• Files for building skills and practicing the book’s lessons
• Fully searchable eBook
• Bonus quick reference to the Ribbon, the new Microsoft Office interface
• Windows Vista Product Guide eBook—plus other resources on CD
 

Target Audience

Beg/Int

Book Details

752 pages, 1 companion CD

Previous Software Versions: MS Office 2003, XP, 2002, 2000

Course Outline:

1 Exploring Word 2007
Working in the Word Environment
Opening, Moving Around in, and Closing a Document.
Displaying Different Views of a Document
Creating and Saving a Document,
Previewing and Printing a Document
Key Points
 

2 Editing and Proofreading Documents
Making Changes to a Document
Inserting Saved Text
Finding the Most Appropriate Word
Reorganizing a Document Outline
Finding and Replacing Text
Correcting Spelling and Grammatical Errors
Finalizing a Document
Key Points
 

3 Changing the Look of Text
Quickly Formatting Text and Paragraphs
Manually Changing the Look of Characters
Manually Changing the Look of Paragraphs
Creating and Modifying Lists
Key Points
 

4 Presenting Information in Columns and Tables
Presenting Information in Columns
Creating a Tabular List
Presenting Information in a Table
Formatting Table Information
Performing Calculations in a Table
Using a Table to Control Page Layout
Key Points

5 Setting up a Workbook
Creating Workbooks
Modifying Workbooks
Modifying Worksheets
Customizing the Excel 2007 Program Window
Zooming In on a Worksheet
Arranging Multiple Workbook Windows.
Adding Buttons to the Quick Access Toolbar
Key Points
 

6 Working with Data and Data Tables
Entering and Revising Data
Moving Data Within a Workbook
Finding and Replacing Data
Correcting and Expanding Upon Worksheet Data .
Defining a Table
Key Points
 

7 Performing Calculations on Data
Naming Groups of Data
Creating Formulas to Calculate Values
Summarizing Data That Meets Specific Conditions.
Finding and Correcting Errors in Calculations
Key Points
 

8 Changing Document Appearance
Formatting Cells
Defining Styles
Applying Workbook Themes and Table Styles
Making Numbers Easier to Read
Changing the Appearance of Data Based on Its Value.
Adding Images to a Document
Key Points

9 Creating a Database
Creating a Database from a Template
Creating a Table Manually
Creating a Table by Using a Template
Manipulating Table Columns and Rows
Key Points
 

10 Simplifying Data Entry by Using Forms
Creating a Form by Using the Form Tool
Refining Form Properties
Changing the Arrangement of a Form
Adding Controls to a Form
Entering Data in a Form by Using VBA
Creating a Form by Using an AutoForm
Adding a Subform to a Form
Key Points
 

11 Locating Specific Information
Sorting Information in a Table
Filtering Information in a Table
Filtering Information by Using a Form
Locating Information That Matches Multiple Criteria .
Creating a Query Manually
Creating a Query by Using a Wizard
Performing Calculations by Using a Query
Key Points
 

12 Keeping Your Information Accurate
Restricting the Type of Data in a Field
Restricting the Amount of Data in a Field
Specifying the Format of Data in a Field
Restricting Data by Using Validation Rules
Creating a Simple Lookup List
Creating a Multi-Column Lookup List
Updating Information in a Table
Deleting Information from a Table
Preventing Database Problems
Key Points
 

PART 4 - MICROSOFT OFFICE POWERPOINT 2007
 

13 Starting a New Presentation
Quickly Creating a Presentation
Creating a Presentation Based on a Ready-Made Design ..
Converting an Outline to a Presentation
Reusing Existing Slides
Key Points
 

14 Working with Slide Text
Entering Text
Editing Text
Adding and Manipulating Text Boxes
Correcting and Sizing Text While Typing
Checking Spelling and Choosing the Best Words
Finding and Replacing Text and Fonts
Changing the Size, Alignment, Spacing, and Look of Text..
Key Points
 

15 Adjusting the Slide Layout, Order, and Look
Changing the Layout of a Slide
Rearranging Slides in a Presentation
Applying a Theme
Switching to a Different Color Scheme
Using Colors That Are Not Part of the Scheme
Adding Shading and Texture to the Background of a Slide.
Key Points
 

16 Delivering a Presentation Electronically
Adapting a Presentation for Different Audiences
Rehearsing a Presentation
Preparing Speaker Notes and Handouts
Preparing a Presentation for Travel
Showing a Presentation
Key Points

17 Getting Started with Outlook 2007
Connecting to Your Primary E-Mail Account
Troubleshooting the Startup Wizard
Connecting to Additional E-Mail Accounts
Creating Additional Outlook Profiles
Personalizing Your Outlook Workspace
Exploring the Advanced Toolbar
Key Points
 

18 Sending E-Mail Messages
Working in the Message Window
Creating and Sending Messages
Addressing Messages
Sending Courtesy Copies
Saving Message Drafts
Attaching Files to Messages
Creating and Formatting Business Graphics
Personalizing the Appearance of Messages
Adding Signatures to Messages Automatically . .
Key Points

19 Managing Your Inbox
Quickly Locating Messages
Arranging Messages in Different Ways
Organizing Messages by Using Color Categories
Organizing Messages in Folders
Archiving Messages
Key Points
Working in the Calendar Item Windows
Scheduling and Changing Appointments
Scheduling and Changing Events