Office 2007 Fundamental Series

Office 2007 Fundamental Series

6 Sessions –
18 Hours of Interactive Training

In today’s fast-paced, collaborative business world, proficiency in Microsoft Office is a must. The Office 2007 Professional Fundamental Series from LearnKey allows you an inside look at the new powerful features of Office 2007 so you can make a smooth transition to the new suite of applications. Expert instructors guide you step-by-step through one session each of Access 2007, Excel 2007, Outlook 2007, PowerPoint 2007, Word 2007 and Learning Office 2007.

Benefits

Efficiently use MS Office 2007 applications.

Make your daily tasks flow smoothly and quickly.

Enhance your personal productivity and promotional value.

About The Authors

LearnKey maintains relationships with an impressive list of publishers with content covering a wide variety of subject matter areas. LearnKey also has relationships with a host of subject matter experts who are distinguished authors, trainers, consultants and educators.

Access 2007
Session 1

Section A: Understanding Access
· What Is Access?
· Access vs. Excel
· Components, Objects, and Terms
· Changes In 2007

Section B: Getting Started
· Application Overview
· Using Templates
· Using the Ribbon
· The Navigation Pane
· Shortcut to Forms
· Finding Help

Section C: Using the Navigation Pane Effectively
· Group View Options
· Item View Options
· Organizing Items
· Navigation Options
· Table Views
· Query and Form Views
· Report and Macro Views

Section D: Data Entry
· Working with Records
· Entering and Editing Records Data
· Deleting Records
· Sorting Data In Records
· Finding Data in Records
· Entering Data In Forms

Section E: Database Design
· Design Steps
· Purpose
· Tables
· Fields
· Relationships
· Primary Key
· Making the Relationship
· Naming Conventions
· Design Cleanup
· Example: Purpose and Tables
· Example: Primary Key and Relationships

Section F: Creating Databases and Tables
· Create Blank Database
· Datasheet View
· Saving Tables
· Table Templates

Excel 2007
Session 1

Section A: Introduction
· What You Will Learn
· Excel 2007 Interface
· Ribbon and Tabs
· Document Windows
· Navigation Tips

Section B: Creating and Manipulating Data
· Entering Data
· AutoFill a Series
· Fill Non-Adjacent Cells
· AutoFill on Multiple Sheets
· Creating Custom Lists
· Series Formatting

Section C: Managing Worksheets
· Copying Worksheets
· Inserting and Deleting Worksheets
· Hiding Worksheets

Section D: Data Integrity
· Validation Criteria
· Character Validation
· Drop-Down Lists

Section E: Modifying Cell Content
· Cut, Copy, Paste
· Transposing Data
· Copy Cell Format Only
· Removing Duplicates
· Data Validation

Section F: Changing Views
· Zoom Features
· Workbook Views
· Page Layout View
· Repeating Cell Content
· Freeze Panes
· Split Windows
· Viewing Multiple Windows
· Saving Hot Links
· Hiding the Ribbon

Learning Office 2007
Session 1

Section A: What's New
· Changing Expectations
· Office 2007 Requirements and Versions
· Office 2007
· Command Tab
· Contextual Tools
· Dialog Launchers
· Gallery
· Live Previews
· File Menus
· Quick Access Toolbar
· Status Bar
· Task Panes

Section B: Formatting Text
· Selecting Text
· Character
· Highlighter
· Font Dialog Box
· Paragraph Formatting
· Paragraph Alignment
· Line Spacing
· Paragraph Indents

Section C: Bulleted/Numbered Lists
· Creating Lists
· Indenting/Outdenting
· Modifying Bullets
· Numbered Lists

Section D: Tabs
· Overview
· Entering Text
· Viewing the Ruler
· Setting Tabs
· Tabs Dialog Box
· Leaders

Section E: AutoCorrect/AutoFormat
· AutoCorrect
· Fractions/Ordinals
· Symbols
· Arrows/Lines
· Add Dividing Lines
· Smart Tags
· Hyperlinks
· AutoCorrect Options
· Add AutoCorrect Entries

Section F: Web Features
· Insert Hyperlink
· E-mail Address
· Web Page
· Bookmarks
· ScreenTips
· Save As Web Page
· Web Layout View

Office 2007 Fundamental Series continued

Outlook 2007
Session 1

Section A: Learning to be Efficient
· What is Outlook Really?
· New Features
· Outlook Editions
· Edition-Specific Features
· Edition Version Summary

Section B: Outlook Interface
· Getting Started
· Navigation Pane
· Information and Reading Panes
· To-Do Bar

Section C: Outlook Today
· The Ideal Assistant
· Customizing Outlook Today

Section D: Configuring E-mail Accounts
· How E-mail Works
· Account Settings
· Manual Configuration
· Changing E-mail Accounts

Section E: Creating E-mail
· Creating Messages
· Addressing the Message
· E-mail Options

Section F: E-mail Extras
· Formatting
· Voting Buttons
· Attachments
· Importance and Sensitivity
· Spell Check
· Saving a Draft

Section G: Hyperlinks and Quick Parts
· Using Hyperlinks
· Using Quick Parts
· Bookmark Hyperlinks

Section H: Setting E-mail Defaults
· E-mail Settings
· Mail Format
· Themes and Fonts
· Setting up E-mail Signatures
· Creating Multiple Signatures

Section I: Securing E-mail
· Digital Signatures
· Encrypting Messages
· IRM
· Configuring IRM
· The Trust Center

PowerPoint 2007
Session 1

Section A: Introduction to PowerPoint
· How to Create Effective Presentations

Section B: Effective Presentations
· Overview
· Take AIM
· Audience
· Intent
· Message
· Presentation Structure
· Visuals
· Nonverbal Communication
· Presentation Tips

Section C: Creating Presentations
· Opening PowerPoint
· New Presentations
· Opening Templates
· Interface Layout
· Changing Views
· Navigation
· Saving a Presentation
· File Extensions
· PowerPoint Process

Section D: Creating Initial Content
· Placeholders
· Working with Text
· Adding Slides
· Changing Slide Layouts
· Arranging Slides
· Copying and Pasting

Section E: Themes
· Live Preview
· Theme Colors
· Customizing Colors
· Theme Effects
· Saving Themes
· Setting Default Themes

Section F: Customizing Slide Masters
· Using Masters
· Slide Master View
· New Slide Master
· New Layout
· Headers and Footers
· Renaming Layouts
· Using New Layout
· Preparing Templates
· Saving Templates

Section G: Working with Text
· Mini Toolbar
· Paragraph Formatting
· Font Formatting
· Editing Master
· Synonyms
· Format Text Box
· Turning Off Mini Toolbar

Section H: Working with Lists
· Creating Bulleted Lists
· Modifying Bulleted Lists
· Customizing Bullets
· Setting Tabs
· Using the Ruler
· Applying Indents

Word 2007
Session 1

Section A: Getting Familiar
· What's New
· Interface Tour
· Getting Help

Section B: Document Navigation Tips
· Navigating Within Documents
· Navigating With the Keyboard
· Browsing By Object
· Selecting Text

Section C: Manipulating Text
· Setting Up a Document
· Cut, Copy, Paste, Move
· Using the Clipboard
· Find and Replace

Section D: Themes and Templates
· Using Themes
· Inserting Pages

Section E: Quick Parts
· Overview
· Modifying Building Blocks
· Inserting Fields
· Inserting Symbols
· Inserting Logos

Section F: Preparing Documents for Printing
· Inline Spelling Errors
· Proofing Indicator
· Spelling and Grammar Dialog
· Proofing Options
· Saving Documents
· Naming Files
· Print Preview
· Print Options
· More Print Options