Office 2007 Training

Microsoft Office 2007 Training Essentials: Course Description

The Office 2007 Training course is a comprehensive Office 2007 training solution centered on increasing user productivity with Microsoft Office Excel, Word, PowerPoint, Outlook and Access 2007.  And, who can't use that?

You read that right -- it's Office 2007 Training for 5 courses rolled neatly into one online bundle.

Here's what you'll Get... In a Nutshell

• 800+ video topics with related articles designed to boost productivity
• Over 40 hours of recorded Office Training
• Exercises and Quizzes to increase retention
• 24/7 access with our fresh learning platform that merges the best Learning Management Systems (LMS) and knowledgebase features into a slick enterprise-wide Software as a Service (SaaS) application

Each application has its own set of Office 2007 Training videos, but we've kept it all within a common thread. For instance, as you progress through the Office 2007 Training for Word (and every other course), you'll have access to the topics across three levels: Beginner, Intermediate and Advanced. So, even though you can learn about SmartArt in Word, if you already watched that video in Excel or PowerPoint, you can skip that topic and move right on to the topics that do interest you, like Section Breaks, Columns or tips for working in long or complex documents.

Are you still reading? Good. Because there's more.

Continue your journey with Office 2007 Training for Excel and get a jump start on your own powerful, number-crunching spreadsheets using functions like PivotTables, Data Validation and Conditional Formatting.

Then, move over to the Office 2007 Training on PowerPoint, where you'll learn how to add flair to your presentations with features like Custom Animation, Action Buttons and Charts.

In the Office 2007 Training course for Outlook, you can start learning how to send a message, if you'd like. Or, you can jump right to learning about those features that will save you time, like Creating a Task Request that delegates assignments to others on your team or finding, filtering and flagging messages to stop that incessant scrolling just to find that one email you need... now.

And, of course, there's Access. Are you ready to become a database developer? In the Office 2007 Training for Access, we can take you from knowing next to nothing about creating a database to developing custom tables, forms, queries and reports. Be careful though, once others find out about your new database development skills, your Inbox will be full of new requests.

Then, point others in your organization to the same training and even suggest specific articles and videos.  It's the training you need, when you need it!

That's because this Office 2007 Training is best enhanced when viewed in our fresh learning platform that merges the best Learning Management Systems (LMS) and knowledgebase features into a slick enterprise-wide Software as a Service (SaaS) application.

Point others to the same training and even suggest specific articles and videos.  It's the training you need, when you need it!

That's because this Office 2007 Training is best enhanced when viewed in our fresh learning platform that merges the best Learning Management Systems (LMS) and knowledgebase features into a slick enterprise-wide Software as a Service (SaaS) application.

What does that mean for you?

• Online, 24/7 access to full Office 2007 Training course content that is also available as searchable, bite-sized training articles and videos that can be quickly found when needed through a handy, quick search feature.  (Training you need, when you need it)
• Customized Office 2007 Training for users of all skill levels that starts with topic introduction, continues through real-world exercises to practice what you learned and wraps up with a quiz to test your recall.  (Start where you want, practice what you see, prove your new skills)
•  With just over 500 Office 2007 Training topics to choose from across 42+ hours of recorded instruction, we're pretty confident that youíll learn something new, and if not, call us; we may have a teaching job for you.  (Every Office 2007 Training video has a matching article)

The Complete Office 2007 Training Solution
(because you need a plan)

We think our training solutions are great, but we'd love it if you thought so, too.  We could go on and on about the benefits of training and how it positively impacts user productivity ultimately resulting in a net gain of getting more done in a shorter amount of time. But, you already know all of that.

What you don't know is what makes us different.

KeyStone Learning Systems offers comprehensive Office 2007 Training for enterprise clients. What does that mean? If you're a company looking for high quality end-user training you can track and assign with the ability to customize the off-the-shelf content, we can help.

The next you get a request for Office 2007 training, you can open your web browser, assign a user to a course and they have access…immediately. Then, our system tracks your users, what courses they’ve taken and sends that usage data right back to you.

Did we mention there's no software to buy or install? The news just keeps getting better. Does your organization have Internet access? Silly question, we know. But, if you have that, you can have KeyStone OnDemand.

Basically, you license it and we stream it.

That's 24/7 access for you and your company with no hidden IT, support or other technology costs that we all know tend to add up pretty quickly. We think it's revolutionary, but we wouldnít mind hearing your opinion.

Did we mention?

• Our trainers are MCTs with a passion for training that you'll feel from the first video
• We offer unlimited Tier 1 support via email for licensed users
• We provide complete training, migration and roll out support packages including Quick Reference Cards, Webinars, Posters, Pre and Post Assessments, Custom Introduction Videos (from your Management team), Awareness Campaigns, and Helpdesk Support Features.
• Your company could be up and running with our training within 2-4 business hours (there are some time zone requirements here, but you get the idea)
• You can add your own training content to our existing, and fabulous, off-the-shelf training

Learning Objectives for Office 2007 Training

Office 2007 Training is such a big course and has so much content; we can't possibly list all of the learning objectives here. For that, check out the outline. But, here are some things that we think are pretty cool and will likely save you time.

• Make the transition from the old menu-based system to the new Ribbon in Word, Excel and PowerPoint (and, to a lesser extent, in Outlook) to reduce the decrease in productivity many experience when making this upgrade
• Learn common Office 2007 features like Themes, WordArt, SmartArt, and Charts
• In Excel, create and use interactive PivotTables to take those huge lists and summarize them in a format even your boss can decipher
• Learn basic Excel formulas like Sum and finish with formulas that ultimately save you time by entering information into your sheet for you, like HLOOKUP and DSUM
• Keep your audience engaged by breathing life into your presentation with custom animations, color, texture and transitions
• Brand your presentations with custom layouts and slides, saving the whole thing as a template so you get the next presentation done even faster
• In Word, you'll move beyond one page letters to create long and complex documents that include bookmarks, footnotes, a table of contents and, if you want, a table of figures
• Use Word for official purposes and compare documents with the legal blackline option or add a table of authorities
• Find the training you need when you need it in Outlook... stop scrolling and start working
• Reduce the amount of junk mail and spam you see on a regular basis using new junk e-mail filters.
• Learn just enough about the theory of database development (it isn't too boring, we promise) to create a robust database of your own
• Work with select, action and parameter queries to view and update small segments of your stored data

Office 2007 Training Essentials: Outline*

Microsoft Office 2007 Training for Excel: Beginner

• 1.    Getting Started in Microsoft Office 2007 Training for Excel 2007
• 1.1.    Launching Microsoft Office Excel 2007
• 1.2.    Touring the Microsoft Office Excel 2007 Window
• 1.3.    Understanding the Microsoft Office 2007 Menu
• 1.4.    The Quick Access Toolbar
• 1.5.    Save vs. Save As
• 1.6.    File and Folder Management
• 1.7.    Opening and Closing Files
• 1.8.    Getting Help

• 2.    Entering Data
• 2.1.    Navigation and Selection Techniques
• 2.2.    Data Entry Techniques
• 2.3.    AutoFill
• 2.4.    AutoComplete
• 2.5.    Undo and Redo
• 2.6.    Exiting Excel 2007

• 3.    Changing Worksheet Layout
• 3.1.    Inserting Rows, Columns and Cells
• 3.2.    Deleting Rows, Columns and Cells
• 3.3.    Adjusting Column Widths and Row Heights
• 3.4.    Hiding Columns and Rows
• 3.5.    Moving and Copying Data
• 3.6.    Create, Modify and Delete Named Ranges
• 3.7.    Go To, Find and Replace

• 4.    Entering Formulas
• 4.1.    Anatomy of a Formula
• 4.2.    The Formula Tab
• 4.3.    AutoSum
• 4.4.    Basic Functions
• 4.5.    Copying Formulas

• 5.    Formatting
• 5.1.    The Home Tab
• 5.2.    The Quick Format Mini Toolbar
• 5.3.    Number Formats
• 5.4.    Format as a Table
• 5.5.    Merging and Splitting Cells
• 5.6.    Applying Worksheet Backgrounds

• 6.    Office 2007 Themes and Styles
• 6.1.    Applying Themes
• 6.2.    Custom Themes
• 6.3.    Applying Styles
• 6.4.    Custom Styles

• 7.    Printing
• 7.1.    Understanding the Page Layout Tab
• 7.2.    Changing Margins and Page Orientation
• 7.3.    Exploring Worksheet Views
• 7.4.    Adding Headers and Footers
• 7.5.    Adding Print Titles and a Print Area
• 7.6.    Viewing and Setting Page Breaks
• 7.7.    Printing

• 8.    Charts
• 8.1.    The Insert Tab
• 8.2.    Creating a Chart
• 8.3.    Understanding the Chart Contextual Tabs
• 8.4.    Creating a Chart Sheet
• 8.5.    Adding and Removing Chart Data
• 8.6.    Format and Resize Charts

• 9.    Microsoft Office 2007 Training for Excel: Resources
• 9.1.    Excel 2007 Beginner Exercises
• 9.2.    Excel 2007 Beginner Sample Files
• 9.3.    Excel 2007 Beginner Knowledge Checks
• 9.4.    Excel 2007 Beginner Training KeyNotes

Microsoft Office 2007 Training for Excel: Intermediate

• 1.    Managing Microsoft Office 2007 Excel Workbooks
• 1.1.    Creating New Workbooks from a Template
• 1.2.    Rename and Move Workbook Tabs
• 1.3.    Insert and Delete Worksheets
• 1.4.    Copy and Paste Worksheets
• 1.5.    The View Tab
• 1.6.    Splitting Your Worksheet View
• 1.7.    Freezing and Unfreezing Your View

• 2.    Tables and Data Management
• 2.1.    Table Guidelines
• 2.2.    The Data Tab
• 2.3.    Sorting
• 2.4.    Grouping and Outlining Data
• 2.5.    AutoFilter
• 2.6.    Filter Using Single Criteria
• 2.7.    Filter Using Multiple Criteria
• 2.8.    Automatic Subtotals

• 3.    Cell References
• 3.1.    Relative Cell References
• 3.2.    Absolute Cell References
• 3.3.    Mixed Cell References

• 4.    Auditing
• 4.1.    About Auditing
• 4.2.    Tracing Precedents
• 4.3.    Tracing Dependents
• 4.4.    Tracing Errors

• 5.    Creating Web Pages from Workbooks
• 5.1.    Publishing a Web Page
• 5.2.    Viewing Your Published Web Page

• 6.    Using Excel with Other Applications
• 6.1.    Importing Data to Excel 2007
• 6.2.    Exporting Data from Excel 2007
• 6.3.    About XML

• 7.    Customizing Excel 2007
• 7.1.    Customizing the Quick Access Toolbar
• 7.2.    Modifying Excel 2007 Options

• 8.    Scenarios and Watching Cells
• 8.1.    Defining and Displaying Scenarios
• 8.2.    Editing and Removing Scenarios
• 8.3.    Summarizing Scenarios
• 8.4.    The Watch Window

• 9.    PivotTables and PivotCharts
• 9.1.    About PivotTables and PivotCharts
• 9.2.    Creating a PivotTable
• 9.3.    Modifying a PivotTable
• 9.4.    Creating a PivotChart
• 9.5.    Modifying a PivotChart

• 10.    Microsoft Office 2007 Training for Excel: Resources
• 10.1.    Excel 2007 Intermediate Exercises
• 10.2.   Excel 2007 Intermediate Sample Files
• 10.3.    Excel 2007 Intermediate Knowledge Checks
• 10.4.    Excel 2007 Intermediate Training KeyNotes

Microsoft Office 2007 Training for Excel: Advanced

• 1.    Collaborating
• 1.1.    Inserting and Deleting Comments
• 1.2.    Viewing and Printing Comments
• 1.3.    Protecting Workbooks, Worksheets and Cells
• 1.4.    Enabling Workbook Security
• 1.5.    Sharing Workbooks

• 2.    Advanced Formulas and Functions
• 2.1.    IF Functions
• 2.2.    Nested IF Functions
• 2.3.    The VLOOKUP Function
• 2.4.    The HLOOKUP Function
• 2.5.    The DSUM Function

• 3.    Data Consolidation
• 3.1.    About Data Consolidation
• 3.2.    Three Dimensional Formulas
• 3.3.    Data Consolidation by Position
• 3.4.    Data Consolidation by Category

• 4.    SmartArt
• 4.1.    About SmartArt
• 4.2.    Building a List
• 4.3.    Setting a Hierarchy
• 4.4.    Creating a Pyramid
• 4.5.    Editing SmartArt

• 5.    Track Revisions
• 5.1.    Tracking Changes
• 5.2.    Accepting and Rejecting Changes

• 6.    Data Validation and Conditional Formatting
• 6.1.    Data Validation Rules
• 6.2.    Set Conditional Formatting
• 6.3.    Use Expressions in Conditional Formatting

• 7.    Setting Up Templates
• 7.1.    Excel 2007 Pre-Defined Templates
• 7.2.    Creating and Modifying a Template

• 8.    Macros
• 8.1.    Create a Macro
• 8.2.    Run a Macro
• 8.3.    Edit a Macro

• 9.    Microsoft Office 2007 Training for Excel: Resources
• 9.1.    Excel 2007 Advanced Exercises
• 9.2.    Excel 2007 Advanced Sample Files
• 9.3.    Excel 2007 Advanced Knowledge Checks
• 9.4.    Excel 2007 Advanced Training KeyNotes

Microsoft Office 2007 Training for Word: Beginner

• 1.    Getting Started in Microsoft Office 2007 Training for Word
• 1.1.    Launching Microsoft Office Word 2007
• 1.2.    Touring the Microsoft Office Word 2007 Window
• 1.3.    Understanding the Microsoft Office 2007 Menu
• 1.4.    The Quick Access Toolbar
• 1.5.    Getting Help

• 2.    New Documents in Word 2007
• 2.1.    Starting a New Document
• 2.2.    Editing Text
• 2.3.    Saving Your Work
• 2.4.    Preview and Print a Document
• 2.5.    Starting in a Template
• 2.6.    Exiting Word 2007

• 3.    Editing Existing Documents
• 3.1.    Opening a Document
• 3.2.    Navigating a Document
• 3.3.    Multiple Page Documents

• 4.    Essential Word 2007 Skills
• 4.1.    Selecting Text
• 4.2.    Moving and Copying Text
• 4.3.    Clipboard Task Pane
• 4.4.    Undo, Redo and Repeat
• 4.5.    AutoCorrect

• 5.    Formatting Text and Paragraphs
• 5.1.    The Home Tab
• 5.2.    The Quick Format Mini Toolbar
• 5.3.    Text Formatting
• 5.4.    Line and Paragraph Spacing
• 5.5.    Format Painter
• 5.6.    Adding Symbols and Special Characters

• 6.    Proofing Tools
• 6.1.    Spelling and Grammar
• 6.2.    The Thesaurus and Other Research Options
• 6.3.    Checking Character and Word Count
• 6.4.    The Custom Dictionary
• 6.5.    Editing in Print Preview

• 7.    Changing Your Page Appearance
• 7.1.    The Page Layout Tab
• 7.2.    Changing Margins and Page Orientation
• 7.3.    Page Breaks
• 7.4.    Adding Line Numbers

• 8.    Microsoft Office 2007 Training for Word: Resources
• 8.1.    Word 2007 Beginner Exercises
• 8.2.    Word 2007 Beginner Sample Files
• 8.3.    Word 2007 Beginner Knowledge Checks
• 8.4.    Word 2007 Beginner Training KeyNotes

Microsoft Office 2007 Training for Word: Intermediate

• 1.    Managing Microsoft Office Documents
• 1.1.    Document Views
• 1.2.    The View Tab
• 1.3.    Managing Multiple Documents
• 1.4.    Saving Your Word Document as a Web Page

• 2.    Additional Editing Tools
• 2.1.    Go To, Find and Replace
• 2.2.    Format Painter
• 2.3.    AutoCorrect

• 3.    Paragraph Formatting
• 3.1.    Bullets and Numbering
• 3.2.    Tabs and Indents
• 3.3.    Borders and Shading
• 3.4.    Styles

• 4.    Introduction to Graphics
• 4.1.    Inserting ClipArt and Pictures
• 4.2.    Inserting Watermarks
• 4.3.    Format Tabs
• 4.4.    AutoShapes
• 4.5.    Editing Images
• 4.6.    Captions
• 4.7.    Text Boxes
• 4.8.    WordArt

• 5.    Document Formatting
• 5.1.    Section Breaks
• 5.2.    Headers and Footers
• 5.3.    Page Backgrounds and Page Borders
• 5.4.    Drop Caps
• 5.5.    Columns

• 6.    Tables
• 6.1.    Creating Tables
• 6.2.    Table Contextual Tabs
• 6.3.    Navigating and Selecting in a Table
• 6.4.    Inserting and Deleting Columns and Rows
• 6.5.    Sorting
• 6.6.    Formatting Tables
• 6.7.    Performing Calculations in a Table
• 6.8.    Converting a Table to Text

• 7.    Customizing Word 2007
• 7.1.    Customizing the Quick Access Toolbar
• 7.2.    Customizing Word 2007 Options

• 8.    Microsoft Office 2007 Training for Word: Resources
• 8.1.    Word 2007 Intermediate Exercises
• 8.2.    Word 2007 Intermediate Sample Files
• 8.3.    Word 2007 Intermediate Knowledge Checks
• 8.4.    Word 2007 Intermediate Training KeyNotes

Microsoft Office 2007 Training for Word: Advanced

• 1.    Document Templates
• 1.1.    Creating and Editing a Template
• 1.2.    Creating Forms
• 1.3.    Protect and Restrict Forms and Documents

• 2.    Mail Merge
• 2.1.    The Mail Merge Process
• 2.2.    The Mailing Tab
• 2.3.    Using a Data Source
• 2.4.    Setting Up Form Letters
• 2.5.    Designing Envelopes
• 2.6.    Formatting Labels

• 3.    Macros
• 3.1.    Creating a Macro
• 3.2.    Running a Macro
• 3.3.    Editing a Macro

• 4.    Office 2007 Themes
• 4.1.    Office 2007 Themes
• 4.2.    Custom Themes

• 5.    SmartArt
• 5.1.    About SmartArt
• 5.2.    Building a List
• 5.3.    Setting a Hierarchy
• 5.4.    Creating a Pyramid
• 5.5.    Editing SmartArt

• 6.    Long or Complex Documents
• 6.1.    The References Tab
• 6.2.    Bookmarks
• 6.3.    Footnotes and Endnotes
• 6.4.    Table of Contents and Index
• 6.5.    Table of Figures and Table of Authorities

• 7.    Collaborating
• 7.1.    The Review Tab
• 7.2.    Using Track Changes
• 7.3.    Inserting Comments
• 7.4.    Compare and Combine Document Versions
• 7.5.    Ways to Secure a Document
• 7.6.    Attaching Digital Signatures

• 8.    Using Word 2007 with Other Programs
• 8.1.    Linking vs. Embedding
• 8.2.    Word 2007 and Excel 2007
• 8.3.    Word 2007 and PowerPoint 2007
• 8.4.    Word 2007 and Outlook 2007

• 9.    Working with XML in Microsoft Office Word 2007
• 9.1.    Overview of XML
• 9.2.    Saving as XML

• 10.    Microsoft Office 2007 Training for Word: Resources
• 10.1.    Word 2007 Advanced Exercises
• 10.2.   Word 2007 Advanced Sample Files
• 10.2.    Word 2007 Advanced Knowledge Checks
• 10.3.    Word 2007 Advanced Training KeyNotes

Microsoft Office 2007 Training for Outlook: Beginner

• 1.    Getting Started in Microsoft Office 2007 Training for Outlook
• 1.1.    Launching Microsoft Office Outlook 2007
• 1.2.    Touring the Microsoft Office Outlook 2007 Window
• 1.3.    The Navigation Pane
• 1.4.    Exploring the To-Do Bar

• 2.    Reading and Sending E-mail in Outlook 2007
• 2.1.    Writing and Sending an E-mail Message
• 2.2.    The Message Tab
• 2.3.    The Address Book
• 2.4.    Saving a Message as a Draft
• 2.5.    Adding an Attachment to an E-mail Message
• 2.6.    Reading Messages
• 2.7.    Viewing Attachments

• 3.    Replying to and Forwarding Messages
• 3.1.    Reply vs. Reply to All
• 3.2.    Forwarding a Message
• 3.3.    Understanding Message Icons in Your Inbox

• 4.    Formatting Messages
• 4.1.    The Format Text Tab
• 4.2.    The Quick Format Mini Toolbar
• 4.3.    Marking Message Importance
• 4.4.    Styles
• 4.5.    The Zoom Feature
• 4.6.    Find and Replace

• 5.    Working with E-mail Addresses
• 5.1.    Adding and Editing a Contact
• 5.2.    The Contact Tab
• 5.3.    Adding a Contact from an E-mail Message
• 5.4.    Sending a Message from Contact View
• 5.5.    Distribution Lists
• 5.6.    Exporting E-mail Addresses
• 5.7.    Importing E-mail Addresses

• 6.    Managing Mail
• 6.1.    Deleting Messages
• 6.2.    Emptying Your Deleted Items Folder
• 6.3.    Using Folders to Manage Your E-mail
• 6.4.    Move and Copy Messages to a Folder
• 6.5.    Renaming a Folder

• 7.    Printing E-mail Messages
• 7.1.    The Print Dialog Box
• 7.2.    Printing in Table vs. Memo Style
• 7.3.    Printing Attachments

• 8.    Microsoft Office 2007 Training for Outlook: Resources
• 8.1.    Outlook 2007 Beginner Exercises
• 8.2.    Outlook 2007 Beginner Sample Files
• 8.3.    Outlook 2007 Beginner Knowledge Checks
• 8.4.    Outlook 2007 Beginner Training KeyNotes

Microsoft Office 2007 Training for Outlook: Intermediate

• 1.    The Outlook 2007 Calendar
• 1.1.    Setting an Appointment
• 1.2.    The Appointment Tab
• 1.3.    Setting a Recurring Appointment
• 1.4.    Editing an Appointment
• 1.5.    Setting Appointment Reminder Options
• 1.6.    Calendar View Options
• 1.7.    Printing Your Calendar

• 2.    Planning Meetings and Appointments
• 2.1.    Scheduling and Sending a Meeting Request
• 2.2.    The Meeting Tab
• 2.3.    Responding to a Meeting Request
• 2.4.    Updating a Meeting Request
• 2.5.    Searching for Appointments

• 3.    Contact Options
• 3.1.    Viewing Contacts
• 3.2.    Searching for Contacts
• 3.3.    Sorting Contacts
• 3.4.    Forwarding Contacts
• 3.5.    Printing Contacts

• 4.    Outlook Tasks
• 4.1.    Scheduling a Task
• 4.2.    The Task Tab
• 4.3.    Editing, Sorting and Viewing Tasks
• 4.4.    Scheduling a Recurring Task
• 4.5.    Sending a Task Request
• 4.6.    Responding to a Task Request
• 4.7.    Marking a Task as Complete

• 5.    Outlook Notes
• 5.1.    Writing Notes
• 5.2.    Editing, Viewing and Sorting Notes
• 5.3.    Formatting Notes

• 6.    Mail Message Options
• 6.1.    Spell Check
• 6.2.    Writing and Editing Signatures
• 6.3.    Stationery

• 7.    Office 2007 Themes
• 7.1.    Office 2007 Themes
• 7.2.    Designing Custom Themes

• 8.    Microsoft Office 2007 Training for Outlook: Resources
• 8.1.    Outlook 2007 Intermediate Exercises
• 8.2.    Outlook 2007 Intermediate Sample Files
• 8.3.    Outlook 2007 Intermediate Knowledge Checks
• 8.4.    Outlook 2007 Intermediate Training KeyNotes

Microsoft Office 2007 Training for Outlook: Advanced

• 1.    Filtering, Finding and Flagging Messages
• 1.1.    Filtering Messages
• 1.2.    Finding Messages
• 1.3.    Flagging Messages
• 1.4.    Completing and Clearing a Flag

• 2.    Archiving Outlook 2007 Data
• 2.1.    About Archiving Data
• 2.2.    Enabling and Disabling AutoArchive
• 2.3.    Running the Manual Archive

• 3.    Personal File Folders
• 3.1.    About Personal File Folders
• 3.2.    Setting Up a Personal File Folder
• 3.3.    Moving and Copying Messages

• 4.    The Outlook Journal
• 4.1.    Writing a Journal Entry
• 4.2.    Automatic Journal Entries
• 4.3.    Editing a Journal Entry

• 5.    Organizing Your Outlook 2007 Items
• 5.1.    Setting Rules
• 5.2.    Editing and Deleting Rules
• 5.3.    Conditional Formatting
• 5.4.    Grouping Items

• 6.    Custom Forms
• 6.1.    Creating a Custom Form
• 6.2.    Custom Forms

• 7.    Pictures and Shapes
• 7.1.    The Insert Tab
• 7.2.    Inserting ClipArt and Pictures
• 7.3.    Drawing AutoShapes
• 7.4.    The Format Tabs
• 7.5.    Resizing Objects
• 7.6.    Layering Objects

• 8.    WordArt and SmartArt
• 8.1.    Inserting a WordArt Object
• 8.2.    Editing a WordArt Object
• 8.3.    About SmartArt
• 8.4.    Building a List
• 8.5.    Setting a Hierarchy
• 8.6.    Creating a Pyramid
• 8.7.    Editing SmartArt

• 9.    Customizing Microsoft Office Outlook 2007
• 9.1.    The Quick Access Toolbar
• 9.2.    Microsoft Office Outlook 2007 Options
• 9.3.    Customizing Toolbars

• 10.    Microsoft Office 2007 Training for Outlook: Resources
• 10.1.    Outlook 2007 Advanced Exercises
• 10.2.   Outlook 2007 Advanced Sample Files
• 10.3.    Outlook 2007 Advanced Knowledge Checks
• 10.4.    Outlook 2007 Advanced Training KeyNotes

Microsoft Office 2007 Training for PowerPoint: Beginner

• 1.    Getting Started with Microsoft Office 2007 Training for PowerPoint
• 1.1.    Launching Microsoft Office PowerPoint 2007
• 1.2.    Touring the Microsoft Office PowerPoint 2007 Window
• 1.3.    Understanding the Microsoft Office PowerPoint 2007 Menu
• 1.4.    The Quick Access Toolbar
• 1.5.    Getting Help
• 1.6.    Opening and Closing Files

• 2.    Opening a New Presentation
• 2.1.    Starting a New Presentation from a Template
• 2.2.    Creating a New Presentation from Scratch
• 2.3.    The Home Tab
• 2.4.    Adding and Editing Text
• 2.5.    Undo, Redo and Repeat
• 2.6.    Save vs. Save As
• 2.7.    File and Folder Management
• 2.8.    Exiting PowerPoint 2007

• 3.    Viewing Presentations
• 3.1.    Navigating Through a Presentation
• 3.2.    Presentation Views
• 3.3.    Slide Show View

• 4.    Modifying an Existing Presentation
• 4.1.    Slide Basics
• 4.2.    Choosing a Design Theme
• 4.3.    Text Boxes
• 4.4.    Formatting Text
• 4.5.    Bullets and Numbering
• 4.6.    Indents and Line Spacing
• 4.7.    AutoCorrect

• 5.    Preparing a Presentation for Delivery
• 5.1.    Spell Check
• 5.2.    The Thesaurus and Research Panes
• 5.3.    Speaker Notes
• 5.4.    Adding a Header and Footer
• 5.5.    Printing Presentations and Handouts

• 6.    Microsoft Office 2007 Training for PowerPoint: Resources
• 6.1.    PowerPoint 2007 Beginner Exercises
• 6.2.    PowerPoint 2007 Beginner Sample Files
• 6.3.    PowerPoint 2007 Beginner Knowledge Checks
• 6.4.    PowerPoint 2007 Beginner Training KeyNotes

Microsoft Office 2007 Training for PowerPoint: Intermediate

• 1.    Outlines
• 1.1.    Adding and Editing Slides in Outline View
• 1.2.    Formatting Slide Text in Outline View
• 1.3.    Exporting a PowerPoint 2007 Outline

• 2.    Pictures and Shapes
• 2.1.    The Insert Tab
• 2.2.    Inserting ClipArt and Pictures
• 2.3.    AutoShapes
• 2.4.    The Format Tabs
• 2.5.    Grouping and Ungrouping Objects
• 2.6.    Layering Objects

• 3.    Presentation Colors
• 3.1.    The Design Tab
• 3.2.    Applying Themes
• 3.3.    Custom Themes

• 4.    Animation
• 4.1.    The Animations Tab
• 4.2.    Adding Entrance and Exit Animation
• 4.3.    Adding Emphasis
• 4.4.    Motion Paths
• 4.5.    Assigning the Order of Animation Effects

• 5.    Organizing and Enhancing Your Presentation
• 5.1.    Duplicating and Deleting Slides
• 5.2.    Hiding Slides
• 5.3.    Rearranging Slides
• 5.4.    Adding Slide Transitions

• 6.    Managing Presentations
• 6.1.    Inserting Slides from Other Presentations
• 6.2.    Find and Replace

• 7.    Customizing PowerPoint 2007
• 7.1.    Customizing the Quick Access Toolbar
• 7.2.    Modifying PowerPoint 2007 Options

• 8.    Microsoft Office 2007 Training for PowerPoint: Resources
• 8.1.    PowerPoint 2007 Intermediate Exercises
• 8.2.    PowerPoint 2007 Intermediate Sample Files
• 8.3.    PowerPoint 2007 Intermediate Knowledge Checks
• 8.4.    PowerPoint 2007 Intermediate Training KeyNotes

Microsoft Office 2007 Training for PowerPoint: Advanced

• 1.    Office 2007 Tables
• 1.1.    Adding a Table to a Slide
• 1.2.    Table Contextual Tabs
• 1.3.    Navigating and Selecting in a Table
• 1.4.    Inserting and Deleting Columns and Rows
• 1.5.    Formatting a Table
• 1.6.    Inserting a Microsoft Excel Table

• 2.    Office 2007 Charts
• 2.1.    Creating a Chart
• 2.2.    The Chart Tab
• 2.3.    Adding and Removing Chart Data
• 2.4.    Formatting and Resizing Charts

• 3.    WordArt and SmartArt
• 3.1.    Insert a WordArt Object
• 3.2.    Editing a WordArt Object
• 3.3.    About SmartArt
• 3.4.    Building a List
• 3.5.    Setting a Hierarchy
• 3.6.    Creating a Pyramid
• 3.7.    Editing SmartArt

• 4.    Office 2007 Templates, Masters and Custom Layouts
• 4.1.    Creating and Editing a Custom Template
• 4.2.    Masters
• 4.3.    Custom Layouts

• 5.    Saving Presentations for the Web
• 5.1.    Adding a Hyperlink to a Slide
• 5.2.    Publishing a Presentation to the Web

• 6.    Collaboration
• 6.1.    The Review Tab
• 6.2.    Inserting, Viewing and Editing Comments

• 7.    Advanced Presentation Delivery Options
• 7.1.    Action Buttons
• 7.2.    Annotating a Presentation
• 7.3.    Slide Timings
• 7.4.    Slide Show Options

• 8.    Microsoft Office 2007 Training for PowerPoint: Resources
• 8.1.    PowerPoint 2007 Advanced Exercises
• 8.2.    PowerPoint 2007 Advanced Sample Files
• 8.3.    PowerPoint 2007 Advanced Knowledge Checks
• 8.4.    PowerPoint 2007 Advanced Training KeyNotes

Microsoft Office 2007 Training for Access: Beginner

• 1.    Getting Started in Microsoft Office 2007 Training for Access
• 1.1.    About Relational Databases and Access 2007
• 1.2.    Launching Microsoft Office Access 2007
• 1.3.    Touring the Microsoft Office Access Environment
• 1.4.    Understanding the Microsoft Office Access 2007 Menu
• 1.5.    Database Components
• 1.6.    The Navigation Pane
• 1.7.    Getting Help
• 1.8.    Opening and Closing Access Databases
• 1.9.    Building an Access Database Using a Preloaded Template

• 2.    Working with an Existing Table
• 2.1.    Exploring Datasheet View
• 2.2.    Editing and Selecting Table Data
• 2.3.    Adding and Deleting Records
• 2.4.    Find and Replace
• 2.5.    Undo and Redo

• 3.    Working with an Existing Form
• 3.1.    Exploring Form View
• 3.2.    Editing and Selecting Form Data
• 3.3.    Adding and Deleting Records
• 3.4.    Find and Replace

• 4.    Sorting and Filtering
• 4.1.    Sorting a Table and a Form
• 4.2.    About Filters
• 4.3.    Common Filters
• 4.4.    Filter by Selection
• 4.5.    Filter by Form
• 4.6.    Custom Filter

• 5.    Designing Select Queries
• 5.1.    The Query Wizard
• 5.2.    Query Design View
• 5.3.    Criteria
• 5.4.    Sorting and Showing Query Fields
• 5.5.    Adding Tables to a Query

• 6.    Form Basics
• 6.1.    The Forms Wizard
• 6.2.    The Form Tool
• 6.3.    Form Design View
• 6.4.    Form Layout View
• 6.5.    Form Controls

• 7.    Report Basics
• 7.1.    The Reports Wizard
• 7.2.    The Report Tool
• 7.3.    Report Design View
• 7.4.    Report Layout View
• 7.5.    Report Controls

• 8.    Printing Database Objects
• 8.1.    Printing Tables or Queries
• 8.2.    Printing Forms
• 8.3.    Printing Reports

• 9.    Microsoft Office 2007 Training for Access: Resources
• 9.1.    Access 2007 Beginner Exercises
• 9.2.    Access 2007 Beginner Sample Files
• 9.3.    Access 2007 Beginner Knowledge Checks
• 9.4.    Access 2007 Beginner Training KeyNotes

Microsoft Office 2007 Training for Access: Intermediate

• 1.    Planning and Designing a Database
• 1.1.    Database Design Process
• 1.2.    Setting Up a Database Using a Wizard
• 1.3.    Creating a Database from Scratch

• 2.    Building and Modifying Tables
• 2.1.    Setting Up a Table Using a Table Template
• 2.2.    About Data Types
• 2.3.    Creating a Table in Datasheet View
• 2.4.    Creating a Table in Design View
• 2.5.    Field Templates
• 2.6.    Setting Primary Keys

• 3.    Working with Relationships
• 3.1.    Types of Relationships
• 3.2.    Referential Integrity
• 3.3.    Cascading Updates and Deletes
• 3.4.    Multi-Valued Fields
• 3.5.    Printing Relationships

• 4.    Sharing Your Data
• 4.1.    Export Your Access 2007 Report to Word 2007
• 4.2.    Export Your Access 2007 Table to Excel 2007
• 4.3.    Import Your Excel 2007 Spreadsheet into Access 2007
• 4.4.    Copying the Table Structure and Data

• 5.    Enhancing Your Forms
• 5.1.    The Field List Task Pane
• 5.2.    The Forms Controls Group
• 5.3.    Adding and Formatting Labels
• 5.4.    Adding Graphics
• 5.5.    Adding Command Buttons

• 6.    Enhancing Your Reports
• 6.1.    The Reports Control Group
• 6.2.    Adding Graphic Details
• 6.3.    White Space and Report Width

• 7.    Microsoft Office 2007 Training for Access: Resources
• 7.1.    Access 2007 Intermediate Exercises
• 7.2.    Access 2007 Intermediate Sample Files
• 7.3.    Access 2007 Intermediate Knowledge Checks
• 7.4.    Access 2007 Intermediate Training KeyNotes

Microsoft Office 2007 Training for Access: Advanced

• 1.    Preventing Data Entry Errors
• 1.1.    The Lookup Wizard
• 1.2.    Data Validation
• 1.3.    Combo Boxes
• 1.4.    List Boxes

• 2.    Advanced Table Design
• 2.1.    Field Properties
• 2.2.    Input Masks
• 2.3.    The Datasheet Total Row
• 2.4.    Rich Text in the Memo Field

• 3.    Advanced Query Design
• 3.1.    Defining a Calculated Field
• 3.2.    Setting Up a Crosstab Query

• 4.    Advanced Form Design
• 4.1.    Split Forms
• 4.2.    The Property Sheet
• 4.3.    Changing Control Tab Order
• 4.4.    Conditional Formatting
• 4.5.    Adding Tab Pages

• 5.    Advanced Report Design
• 5.1.    Groups and Total Reports
• 5.2.    Total Fields
• 5.3.    Adding Calculated Controls to a Report

• 6.    Managing Databases
• 6.1.    Identify Object Dependencies
• 6.2.    Database Documenter

• 7.    Microsoft Office 2007 Training for Access: Resources
• 7.1.    Access 2007 Advanced Exercises
• 7.2.    Access 2007 Advanced Sample Files
• 7.3.    Access 2007 Advanced Knowledge Checks
• 7.4.    Access 2007 Advanced Training KeyNotes

Microsoft Office 2007 Training for Access: Expert

• 1.    Expertly Designed Select Queries
• 1.1.    Single Parameter Queries
• 1.2.    Multiple Parameter Queries
• 1.3.    Query Joins

• 2.    Action Queries
• 2.1.    Types of Action Queries
• 2.2.    Update Queries
• 2.3.    Append Queries
• 2.4.    Make Take Queries
• 2.5.    Delete Queries

• 3.    Expertly Designed Forms
• 3.1.    Creating a Lookup Field
• 3.2.    Using a Bitmap as a Form Background
• 3.3.    Adding Calculated Controls to a Form

• 4.    Expertly Designed Reports
• 4.1.    Setting Section Properties
• 4.2.    Adding Graphics
• 4.3.    Arranging Report Data Into Columns

• 5.    Macros
• 5.1.    Create a Macro
• 5.2.    Edit a Macro
• 5.3.    Attach a Macro to a Command Button

• 6.    Database Security
• 6.1.    About Database Security
• 6.2.    Applying a Database Password

• 7.    Microsoft Office 2007 Training for Access: Resources
• 7.1.    Access 2007 Expert Exercises
• 7.2.    Access 2007 Expert Sample Files
• 7.3.    Access 2007 Expert Knowledge Checks
• 7.4.    Access 2007 Expert Training KeyNotes

*Outline, Topics, and Resources subject to change

Office 2007 Training Instructor

Deanna Reynolds

MCTS, Technical Trainer, Published Author

Deanna is an author and technical instructor residing in Bellingham, Washington. For close to 20 years, Deanna has trained students in all arenas, specializing in delivering enterprise training. Throughout her career, Deanna has led hundreds of computer productivity training sessions, from beginner through advanced levels.  These days, Deanna’s technical training has extended beyond the classroom to include more than 20 courses for KeyStone Learning Systems and three published books: Excel 2010: No Problem! (Wiley), Word 2007 Pocket Book (Prentice Hall), and Managing Projects with Microsoft Office Project 2007 (Microsoft Press).

In Office 2007 Training, Deanna will guide users of all levels to better desktop productivity through a complete understanding of Office 2007. 

Some Quick Office 2007 Training Tips

Run the Compatibility Checker

Since you can't guarantee that everyone will be running the same version of any program that you are, you can use the Compatibility Checker to see if your file will lose any data or features if it were opened in an older program. From your program's Office menu, select the Prepare option. Then, click Run Compatibility Checker. This allows you to see if your file contains any features not supported in earlier versions of the program. (Office 2007 Training Tips: © KeyStone Learning Systems)

Add a Shortcut Key to a Symbol

You can't customize too many shortcuts in Office 2007, but you can add a shortcut key to many of the available symbols and the Symbol dialog is fairly easy to access from the ribbon's Insert tab in Word or Outlook by choosing the Symbol option, and then clicking More Symbols. First, select the symbol you want to affect and second, click the Shortcut Key button. Finally, press the shortcut key combination you want to be able to use. Just make sure you don't use another shortcut when you assign this new one. To be sure, look for the Currently assigned to designation and find a key combination that is currently unassigned. (Office 2007 Training Tips: © KeyStone Learning Systems)

Where did Microsoft place AutoCorrect?

It's still there, we promise. And, it's still shared among all of the Office programs. But, it's a little more difficult to find. Try looking under the Office menu and choose Options to open any program's Options dialog. Once there, select Proofing in the left-side Navigation Pane and then click the AutoCorrect Options dialog. Now you're back in business. (Office 2007 Training Tips: © KeyStone Learning Systems)

What the heck happened to my dialog boxes?

If you need to get oriented to the Office 2007 user interface quickly and can't afford a lot of down time, the single best thing you can do is acquaint yourself with the dialog box launcher arrows. These are small arrows located on the lower-right corners of the ribbon groups. When clicked, they open you old favorites -ñ the same dialog boxes you used in Office 2003. Now, isn't that better? (Office 2007 Training Tips: © KeyStone Learning Systems)

Other Resouces on the Web

Free Webinars:

Click Here to sign up for a free webinar on how you can reduce Office 2007 Training cost with KeyStone OnDemand! 

Professional Groups:

LinkedIn's Microsoft Learning Professionals Group
This is a group for Microsoft learning and training professionals, including desktop support managers, project managers, instructional designers, learning officers and classroom trainers.