In today's fast-paced, collaborative business world, proficiency in Microsoft Office is a must. Powerful and packed with new features, Office 2007 imposes a demanding learning curve. The Office 2007 Professional Series from LearnKey allows you to make a smooth transition to the new suite of applications with expert instructors guiding you step-by-step through the basics to more advanced features. This series provides three sessions each of Outlook 2007, PowerPoint 2007, and Word 2007, and five sessions of each Access 2007 and Excel 2007.

Benefits:

• Efficiently use MS Office 2007 applications.
• Make your daily tasks flow smoothly and quickly.
• Enhance your personal productivity and promotional value.

Access 2007
Session 1

• Understanding Access
• Getting Started
• Using the Navigation Pane Effectively
• Data Entry
• Database Design
• Creating Databases and Tables

Session 2

• Working With Tables
• Field Properties
• Lookup Fields
• Relationship Theory
• Creating Relationships
• Analyzing Design
• Sub Datasheets and Filters

Session 3

• Query Basics
• Intermediate Queries
• Calculation in Queries
• Special Queries
• Action Queries
• Concatenation

Session 4

• Importing/Exporting Data
• Using Mail Merge
• Basic Forms
• Form Controls
• Form Design
• Special Forms
• Reports

Session 5

• Controlling Display and Data Entry
• Access Automation
• Custom Automation
• Working With the File
• Security
• Sharing Information

Excel 2007
Session 1

• Introduction
• Creating and Manipulating Data
• Managing Worksheets
• Data Integrity
• Modifying Cell Content
• Changing Views

Session 2

• Formatting Data
• Modifying Rows and Columns
• Formatting Numbers
• Formatting Text and Tables
• Understanding Formulas

Session 3

• Referencing Formulas
• Ranges and Dates
• Subtotals
• Lookups
• Conditional Logic
• More Conditional Logic

Session 4

• Financial Formulas
• Text Formulas
• Introduction to Charts
• Formatting Charts
• Conditional Charts
• Conditional Formatting
• Adding Graphics to Spreadsheets

Session 5

• Outlining, Sorting, and Filtering
• PivotTables
• Protecting Data
• Collaboration
• Saving a Workbook
• Printing

Outlook 2007
Session 1

• Learning to be Efficient
• Outlook Interface
• Outlook Today
• Configuring E-mail Accounts
• Creating E-mail
• E-mail Extras
• Hyperlinks and Quick Parts
• Setting E-mail Defaults
• Securing E-mail

Session 2

• Receiving E-mail
• Working Offline
• Changing Views
• Organizing Information
• Managing Junk Mail
• Customizing Folders
• Managing Data
• Rules and Alerts

Session 3

• Archiving
• Searching
• Contact Basics
• Advanced Contacts
• Calendars and Scheduling
• Calendar Defaults and Permissions
• Collaboration
• Meetings
• Tasks and Journal

PowerPoint
Session 1

• Introduction to PowerPoint
• Effective Presentations
• Creating Presentations
• Creating Initial Content
• Themes
• Customizing Slide Masters
• Working With Text
• Working With Lists

Session 2

• Using Existing Content
• Charts
• Tables
• Shape Properties
• Drawing Tools
• SmartArt Diagrams
• Pictures and Photo Albums
• Backgrounds and Watermarks

Session 3

• Multimedia
• Animations
• Customizing Slide Shows
• Save for Web Viewing
• Delivery Formats
• Proofing and Reviewing
• Prepare and Protect
• Prepare for the Presentation

Word 2007
Session 1

• Getting Familiar
• Document Navigation Tips
• Manipulating Text
• Themes and Templates
• Quick Parts
• Preparing Documents for Printing

Session 2

• Formatting Characters
• Formatting Paragraphs
• Organizing Content
• Tabs, Columns, and Charts
• Links, Headers, and Footers
• References

Session 3

• Mail Merge
• Visual Content
• Reviewing Documents