LearnKey Training

Office 2010 Series

Office 2010 Series

Back to Product Page


Office 2010 Series

0 Sessions -
55 Hours of Interactive Training

The Office 2010 certification training series from LearnKey is packed with information covering the Office 2010 new features. This series is ideal for professionals who are looking to improve their proficiency with Office or for any individuals who are looking to enhance their skill set with the MOS certifications offered by Microsoft. Create your competitive edge with the knowledge of Microsoft Office 2010. This series provides three sessions each of Outlook 2010, PowerPoint 2010, and Word 2010, and five sessions each of Access 2010 and Excel 2010.

Benefits
  • Efficiently use Office 2010
  • Enhance your productivity
  • Increase promotional value

Access 2010 Course (77-885)
Session 1

Section A: Introduction

  • Database Defined
  • Available Database Platforms
  • Access Advantages and Disadvantages

Section B: Access 2010 Tour

  • Opening Access and Databases
  • Interface Overview
  • Quick Access Toolbar
  • Introduction to Backstage
  • Getting Help
  • Understanding Database Parts

Section C: Working with Tables and Forms

  • Navigating Tables
  • Sorting and Filtering Table Data
  • Entering and Editing Table Data
  • Navigating Forms
  • Entering and Editing Form Data
  • Form Types
  • Working with Multiple Items

Section D: Working with Queries and Reports

  • Running Queries
  • Running Reports

Section E: Database Organization Techniques

  • Using the Navigation Pane
  • Access Naming Conventions
  • Copying and Renaming Objects
  • Deleting Objects

Section F: Customizing Access

  • Customizing Quick Access Toolbar
  • Customizing the Ribbon
  • Backstage Customization Options
  • Additional Backstage Options

Section G: Understanding Relational Databases

  • Flat vs. Relational Databases
  • Relational Database Rules

Section H: Planning a Database

  • Defining Database Needs
  • Mapping Out a Database

Access 2010 Course (77-885)
Session 2

Section A: Building a Database

  • Database Options
  • Database from Template
  • Database from Scratch

Section B: Building Tables

  • Application Parts
  • Using Application Parts
  • Using Naming Conventions
  • Tables from Scratch
  • Create Table in Design View

Section C: Table Design Basics

  • Good Table Design Basics
  • Defining the Data Type
  • Yes/No Data Type
  • Other Data Types
  • Saving and Testing Tables

Section D: Adjusting Table Design

  • Understanding Field Properties
  • Database Adjustment Feedback
  • Edit Field Size
  • Removing Fields
  • Text vs. Numeric Field Options
  • Adding Descriptions
  • Renaming Fields
  • Importance of Field Consistency
  • Required Fields

Section E: Data Validation and Input Masks

  • Validation Rules
  • Building the Rule
  • Specify Validation Text
  • Testing Validation Rule
  • Input Masks
  • Input Mask Wizard

Section F: Lookups

  • Lookups Defined
  • Creating a Lookup
  • Using the Lookup Wizard
  • List-Based Lookups

Section G: Table Relationships

  • Understanding Table Relationships
  • Creating a Table Relationship
  • Referential Integrity
  • Determine Relationship Options
  • Manually Create Table Relationship

Section H: Importing Data

  • Importing Data into a New Table
  • Importing Data into an Existing Table
  • Troubleshooting Import Errors
  • Linked Tables

Access 2010 Course (77-885)
Session 3

Section A: Building Forms Automatically

  • Introduction to Forms
  • Creating a Standard Form
  • Form View Options
  • Creating a Split Form
  • Using the Form Wizard
  • Creating a Form/Subform

Section B: Building Forms Manually

  • Creation Process Defined
  • Creating Forms in Design View
  • Creating a Blank Form
  • Create Form using Application Parts
  • Manage Active Content and Security
  • Customizing Forms in Design View

Section C: Customizing and Personalizing Forms

  • Form Customization Techniques
  • Using and Customizing Themes
  • Alternating Row Color
  • Form Personalization Techniques
  • Inserting an Image
  • Adding Background Images
  • Conditional Formatting

Section D: Working with Form Layout

  • Form Design Options
  • Using the Layout View
  • Using Stacked Layout
  • Converting Layouts
  • Controlling Margins and Padding
  • Unstacking a Layout

Section E: Working with Form Design

  • Using the Design View
  • Object Property Considerations
  • Getting the Form Properties
  • Controlling Tab Order

Section F: Adding Controls to Forms

  • Controls Defined
  • Adding a Button
  • Adding a Combo Box
  • Adding a Text Box

Section G: Filtering Data with Forms

  • Form-Based Filtering
  • Right-Click Filter Options
  • Filtering By Selection
  • Filtering By Form
  • Using Wildcards
  • Filtering Across Multiple Fields
  • Either/Or Filters

Section H: Building Navigation Forms

  • Understanding Switchboards
  • Using the Switchboard Manager
  • Editing Switchboard Items
  • Running the Switchboard
  • Creating a Navigation Form

Access 2010 Course (77-885)
Session 4

Section A: Building a Query with a Wizard

  • Purpose of Queries
  • Building a Query
  • Simple Query Wizard
  • Query Design Window
  • Using Other Wizards

Section B: Building a Query from Scratch

  • Defining a Queried Table
  • Adding Fields to a Query
  • Testing the Query
  • Hiding and Rearranging Fields
  • Joining Tables in Queries
  • Inner vs. Outer Joins
  • Convert Inner to Outer Join

Section C: Basic Criteria

  • Criteria Types
  • Filtering Data with Criteria
  • Using AND and OR Criteria
  • Using the IN Criteria

Section D: Comparison Criteria

  • Building a Comparison Query
  • Using < and >
  • Using BETWEEN
  • Using NULL and NOT
  • Querying using Wildcards
  • Using Single Character Wildcards

Section E: Performing Calculations

  • Understanding Calculations
  • Building a Calculated Field
  • Using Expression Builder
  • Understanding Expression Builder
  • Writing and Formatting Expressions
  • Concatenating Fields

Section F: Working with Calculated Totals

  • Using the Total Row
  • Performing Queries Using Aggregates
  • Calculated Total Considerations

Section G: Advanced Select Queries

  • Crosstab Query Defined
  • Crosstab Query Example
  • Editing Query Properties
  • Parameter Query Defined
  • Parameter Query Example

Section H: Action Queries

  • Action Query Defined
  • Enabling Active Content
  • Make-Table Query Example
  • Running an Action Query
  • Append-Table Query Example
  • Update Query Example
  • Update Query Errors
  • Run Update Query
  • Delete Query Example

Access 2010 Course (77-885)
Session 5

Section A: Reports

  • Building Reports
  • Report Button
  • Report Wizard
  • Reports from Scratch
  • Viewing Options

Section B: Report Formatting

  • Report Themes
  • Modifying Report Themes
  • Conditional Formatting
  • Expression Builder

Section C: Basic Report Design

  • Report Design Concepts
  • Adding Footer Information
  • Arranging Report Fields
  • Customizing a Report Layout
  • Adding Hyperlinks
  • Adding Charts

Section D: Grouping Data on Reports

  • Adding Totals to Reports
  • Adding Calculated Fields to Reports
  • Building an IF Statement

Section E: Controlling Page Layout

  • Report Layout Considerations
  • Working with Page Breaks
  • Using Print Preview
  • Modifying and Resizing Fields
  • Changing Page Size
  • Controlling Margins and Page Layout

Section F: Building Specialized Reports

  • Parameter Reports Defined
  • Building a Parameter Report
  • Enter a Different Paramenter
  • Building a Mailing Labels Report
  • Building a Multi-Column Report

Section G: Introduction to Macros

  • Macros Defined
  • Form Data Validation Macros
  • Report Data Validation Macros
  • Table Data Validation Macros

Section H: Finalizing the Database

  • Exporting the Database
  • Saving Export Steps
  • Publishing the Database
  • Saving the Database as a Template

Excel 2010 Course (77-882)
Session 1

Section A: Introduction

  • Course Overview
  • Excel 2010 Introduction
  • Quick Access Toolbar
  • Toolbar Customization
  • Additional Customization Buttons

Section B: Navigating Excel

  • Ribbon Organization
  • Function Grouping
  • Multiple Function Access
  • The Document Window
  • Basic Navigation
  • Workbook Options

Section C: Excel 2010 Shortcuts

  • Best Practice Guidelines
  • Common Hot Keys
  • Speed Keys
  • Function Keys
  • CTRL Keys
  • ALT Keys
  • Visible Speed Keys

Section D: Creating and Manipulating Data

  • Entering Data
  • Auto Fill a Series
  • Creating Custom Lists
  • Fill Adjacent Cells
  • Fill Non-Adjacent Cells
  • Auto Fill on Multiple Sheets

Section E: Managing Worksheets

  • Copying/Moving Worksheets
  • Renaming Worksheets
  • Inserting/Deleting Worksheets
  • Hiding Worksheets

Section F: Data Validation

  • Range Criteria
  • List Criteria
  • Extending the List
  • Input Message
  • Validation Error Alerts
  • Validation by Character

Section G: Modifying Cell Content

  • Copy/Paste Options
  • Paste
  • Inserting Columns
  • Transporting Data
  • Copy Cell Formatting
  • Removing Duplicates

Section H: Changing Views

  • Zoom
  • Workbook Views
  • Page Layout
  • Freeze Panes
  • Split Windows
  • Viewing Multiple Windows

Excel 2010 Course (77-882)
Session 2

Section A: Formatting Data

  • Formatting Worksheets
  • Cell/Font Color
  • Background Images
  • Watermarks
  • Worksheet Tab Color

Section B: Formatting Numbers

  • Modifying Cell Formats
  • Format Painter
  • Date Formatting
  • Formatting Multiple Cells
  • Numerical Cell Values
  • Special Formats

Section C: Formatting Text and Tables

  • Formatting Fonts / Fills
  • Cell Height/Width
  • Noncompatible Commands
  • Cell Alignment
  • Inserting Comments
  • Merge and Center
  • Tables

Section D: Understanding Formulas

  • Operations
  • Arithmetic Operations
  • Additional Operation Symbols
  • SUM Function
  • Ranges in Functions
  • AutoSum
  • Average
  • Min/Max Functions
  • Count Formula
  • AutoCalculate
  • Modifying AutoCalculate
  • Copying Formulas
  • Cell Multiplication
  • Relative Cell References
  • Absolute Cell References

Excel 2010 Course (77-882)
Session 3

Section A: Referencing Formulas

  • Totaling Multiple Sheets
  • AutoFit Multiple Cells
  • Linked Formulas
  • Grand Totals
  • Sparkline Graphics
  • Sparkline Colors
  • Consolidation
  • Consolidating Data
  • Linking to Source Data
  • Hierarchical Outline
  • Consistency

Section B: Ranges and Dates

  • Naming Ranges
  • Adding Named Ranges
  • Dates
  • Date Speed Keys
  • Formula Calculations
  • Formula Auditing
  • The Watch Window
  • Formula Evaluation

Section C: Subtotals

  • Using Subtotals
  • Subtotal Options
  • Using Data Hierarchy
  • Selecting Visible Data

Section D: Using VLOOKUP

  • VLOOKUP
  • VLOOKUP Type I
  • VLOOKUP's Three Arguments
  • VLOOKUP Type I Methodology
  • VLOOKUP Type II

Section E: Using Nested Formulas

  • Nested Formulas
  • Absolute Numbers
  • Nested Absolutes
  • Nested Formula Logic
  • FIND
  • INDIRECT
  • ROW/COL

Section F: Conditional Logic

  • The IF Formula
  • The IF Statement
  • Nested IF
  • Nested IF Syntax

Section G: More Conditional Logic

  • Insert Wizard
  • AND
  • OR
  • NOT
  • IFERROR
  • SUMIF / AVERAGEIF / COUNTIF
  • SUMIFS
  • AVERAGEIFS
  • COUNTIFS

Excel 2010 Course (77-882)
Session 4

Section A: Financial Formulas

  • Working with Financial Formulas
  • Future Value Function
  • Function Categories
  • Calculating Interest Rate
  • Calculating Total Payment
  • Calculating Monthly Payment
  • Using Goal Seek

Section B: What-If Functions

  • Solver Add-in
  • Using Solver
  • Constraints
  • Reports
  • Comparing Options
  • Scenario Manager
  • Scenario Report
  • Data Tables
  • Applying Data Tables
  • Comparing Data Tables

Section C: Working with Text Formulas

  • Concatenate
  • Text to Columns
  • Extraction Formulas
  • Combining with Previous Formulas
  • UPPER/LOWER/PROPER
  • Converting Formulas with Function Keys

Section D: Paste Special

  • Pasting Values
  • Pasting Formats
  • Quick Multiplication
  • Addition
  • TRIM
  • Substitute

Section E: Introduction to Charts

  • Charts
  • Chart Types
  • Instant Chart
  • Updating Charts
  • Add Secondary Y/Value Axis
  • Adding Data Labels
  • Fill
  • Picture Fill
  • Line/Scatter Charts

Section F: Formatting Charts

  • Chart Styles
  • 3-D Charts
  • Quick Layouts
  • Formatting Chart Labels
  • Layout
  • Chart Title
  • Legends

Section G: Conditional Formatting

  • Conditional Formatting Options
  • Selecting Cells to Format
  • Top/Bottom Rules
  • Data Bars/Color Scales/Icon Sets
  • Managing Rules
  • Wildcards
  • Alternative Row Shading via Formulas

Section H: Adding Graphics to Spreadsheets

  • Inserting Pictures
  • Modifying Pictures
  • Inserting Shapes
  • Inserting SmartArt
  • Modifying SmartArt
  • Themes

Excel 2010 Course (77-882)
Session 5

Section A: Outlining, Sorting, and Filtering

  • Grouping
  • Ungrouping
  • Sorting Data
  • Sorting Levels
  • Filtering Data
  • Selecting Filtered Rows
  • Advanced Filtering

Section B: PivotTables and PivotCharts

  • PivotTables
  • Creating PivotTables
  • PivotTable Layout
  • Defaults
  • Updating/Modifying Data
  • Calculated Fields
  • Calculated Items
  • Filtering PivotTables
  • Slicer
  • PivotCharts

Section C: Protecting Data

  • Locking Cells
  • Protect Workbook
  • Hiding Cells
  • Hiding Worksheets

Section D: Introduction to Backstage

  • Document Properties
  • Titles/Tags/Categories
  • Related Dates / People
  • Formatting Comments
  • Document Inspector
  • Sparklines/Slicer
  • Compatibility Checker
  • Document Inspection

Section E: Collaboration

  • Sharing Documents
  • Sharing Workbooks
  • Protecting Shared Workbooks
  • Tracking Changes
  • Accept/Reject Changes
  • Information Rights Management
  • Document Signature
  • Mark as Final

Section F: Saving Workbooks

  • Save as Previous Version
  • File Sharing with Previous Excel Version
  • Customization/Compatibility
  • Excel Options
  • Templates
  • Opening/Deleting Templates
  • Save as a Web Page
  • Single File Web Page

Section G: Printing Workbooks

  • Page Orientation
  • Margins
  • Print Area/Page Breaks
  • Page Sailing
  • Headers/Footers
  • Row/Column Headings
  • Other Print Options

Section H: Macros with VB for Applications

  • Macros
  • Recordable Macros
  • Non-Recordable Macros
  • Creating a Macro
  • Naming Macros
  • Shortcut Keys
  • Storage Options
  • Recording a Macro
  • Testing Macros
  • Editing Macros with Visual Basic
  • Testing Edited Macros
  • Relative Reference Macros
  • Assigning Buttons to Macros
  • Modifying Button Icons
  • Macro-Enabled Workbooks
  • Save Workspace

Outlook 2010 Course (77-884)
Session 1

Section A: Getting Started

  • Introduction
  • Configuring Outlook
  • Adding an E-mail Account
  • POP and IMAP Settings
  • Interface Overview
  • Startup Options

Section B: Manipulate Outlook Options

  • General Options
  • Customizing the Quick Access Toolbar
  • Customizing the Ribbon
  • Language Options

Section C: Managing Outlook Views

  • The Navigation Pane
  • Arranging Content Panes
  • The Reading Pane
  • To-Do Bar Options
  • Screen Resolution Considerations

Section D: E-mail Organization Techniques

  • Organizing with Custom Folders
  • Using Categories
  • Read vs. Unread
  • Viewing Message Properties
  • E-mail Follow Up

Section E: Search and Filter Tools

  • Basic Searches
  • Changing Search Options
  • Recent Searches
  • Search Folders

Section F: Create and Format E-mails

  • Composing E-mail
  • Message Themes
  • Theme or Stationery Options
  • Formatting Text
  • Changing Sentence Case
  • Font Style and Justification

Section G: Insert Content and Graphical Elements

  • Quick Parts
  • Inserting Images
  • Inserting Charts
  • Paste Special
  • Inserting Hyperlinks
  • Inserting Symbols and Horizontal Lines
  • Creating a Signature
  • Managing Signatures

Section H: Message Send Options

  • Addressing Options
  • AutoComplete
  • Hiding Receiver Addresses
  • Specifying Sender Account
  • Sent Items Folder
  • Drafts Folder
  • Flagging Messages
  • Delivery Options
  • Voting and Tracking Options

Outlook 2010 Course (77-884)
Session 2

Section A: Managing E-mails and Mailboxes

  • Working with Attachments
  • Attaching Files to E-mail
  • Mailbox Size Considerations
  • Mailbox Cleanup
  • Save Attachments
  • Remove Attachments
  • Recover Attachments
  • Lost Attachments
  • Backing Up Outlook Data Files
  • Restore Outlook Data Files

Section B: Managing Conversations

  • Conversations View
  • Ignore Conversations
  • Clean Up Conversations

Section C: Managing Rules

  • Creating Mail Rules
  • Rule Exceptions
  • Manage and Edit Rules

Section D: Quick Steps

  • Quick Steps vs. Macros
  • Creating Quick Steps
  • Manage and Edit
  • Edit, Delete, and Duplicate
  • Reset to Defaults

Section E: Managing Junk Mail

  • Junk Mail
  • Junk E-mail Options
  • Safe Senders
  • Safe Recipients
  • Blocked Senders
  • International Options
  • Allow Specific Messages

Section F: RSS Feeds and Social Networking

  • RSS
  • RSS Subscription
  • Unsubscribe RSS Feeds
  • People Pane
  • Connect to Social Networks
  • Text Messaging
  • Third-Party Providers

Outlook 2010 Course (77-884)
Session 3

Section A: Working with Contacts

  • Contact Mode
  • Create New Contact
  • Add Contact Information
  • Contact List View Options
  • Forward Contacts
  • Update a Contact
  • Suggested Contacts
  • Import Contact List

Section B: Business Cards and Contact Groups

  • Modify a Business Card
  • Create New Contact Group
  • Manage Contact Groups
  • Forward Contact Groups
  • Update Contacts and Groups
  • Add Notes to Groups

Section C: Working with the Calendar Pane

  • Arrange Calendar Views
  • Calendar Options
  • Holidays
  • Calendar Color
  • Display and Hide Calendars
  • E-mail Calendars
  • Calendar Groups

Section D: Managing Appointments and Events

  • Create a New Appointment
  • Appointment Viewing Options
  • Recurring Appointments
  • Set Reminders
  • Add Mail to Calendars
  • Forward Appointments

Section E: Meeting Requests

  • Create Meeting Request
  • Attach File
  • Add Attendees
  • Add Resources
  • Change Meeting Time
  • Set Response Options
  • Update Meeting Request
  • Cancel Meeting
  • Propose New Meeting Time

Section F: Managing Tasks

  • Task Options
  • Create a New Task
  • Assign Task
  • Task Status Report
  • Update Assigned Task
  • Move to Another Folder
  • Task Views
  • Saved Views

Section G: Working with Notes

  • Launch Notes
  • Create and Save Notes
  • Organize Notes
  • Notes Views
  • Categorize Notes

Section H: Working with Journals

  • Launch the Journal
  • Manual Journal Entry
  • Journal Options
  • Journal Views
  • Edit Journal Entries
  • Memory Options

Section I: Spelling and Printing

  • Spell Check
  • Spell Check Language Options
  • Spell Check Options
  • Print E-mail
  • Print Outlook Items
  • Print Attachments

PowerPoint 2010 Course (77-883)
Session 1

Section A: Building Effective Presentations

  • Preparation and Organization
  • AIM
  • Audience
  • Intent
  • Message
  • Sensory Levels
  • Presentation Structure
  • Using Visuals
  • Vocal Emphasis
  • Attire
  • Filler Words
  • Body Language and Eye Contact
  • Presentation Tips

Section B: PowerPoint 2010 Overview

  • Launching PowerPoint
  • Interface Layout
  • Understanding the Ribbon
  • Customizing the Quick Access Toolbar

Section C: Creating Presentations

  • New Presentations
  • Using Templates
  • Keyboard Speed Keys
  • Slide vs. Outline View
  • Changing Views
  • Slide Sorter View
  • Reading and Presentation Views
  • Navigation Tips
  • Saving a Presentation
  • File Extensions
  • Slide Design Process

Section D: Creating Initial Content

  • Understanding Layouts
  • Adding Slide Content
  • Changing Case Keyboard Shortcut
  • Selecting Text Tip
  • Increasing and Decreasing Font Size
  • Adding Slides
  • Arranging Slides
  • Copying and Pasting
  • Copying and Pasting Windows Rule
  • Using Paste Special

Section E: Design Themes

  • Theme Sets
  • Customizing Themes
  • Theme Colors
  • Editing Themes
  • Theme Fonts
  • Theme Effects
  • Saving Themes

Section F: Slide Masters

  • Using Masters
  • Slide Layout Masters
  • Duplicate Default Masters
  • Preserve Master Option
  • Creating New Layouts
  • Headers and Footers
  • Save As Template

Section G: Working with Text

  • Mini Toolbar
  • Paragraph Formatting
  • Font Formatting
  • Editing the Slide Master
  • Synonyms and Thesaurus
  • Inserting and Formatting Text Boxes

Section H: Working with Lists

  • Default Bullet Styles
  • Applying Bullets Based on Themes
  • Bullets and Numbering Options
  • Modifying Bullets
  • Numbered Bullet Options
  • Customizing Bullets
  • Using Pictures as Bullets
  • Using the Ruler
  • Setting and Removing Tabs
  • Applying Indents

PowerPoint 2010 Course (77-883)
Session 2

Section A: Using Existing Content

  • Outlines
  • Working In Outline View
  • Rearranging Slides
  • Slides from Word Document
  • Preparing Text for Import
  • Slides from Notepad Document
  • Saving as RTF
  • Reusing Slides
  • Publish to Slide Library

Section B: Embedded Charts

  • Inserting Charts
  • Defining Chart Data
  • Understanding Chart Types
  • Quick Layouts
  • Chart Styles
  • Editing Chart Data
  • Layout and Formatting Options
  • Save As Template

Section C: Excel Charts

  • Using Excel Charts
  • Importing into PowerPoint
  • Using Paste Special
  • Updating Linked Data
  • Capturing Excel Data as an Image

Section D: Working with Tables

  • Inserting Tables
  • Table Style Options
  • Table Styles Gallery
  • Customizing Theme Colors and Options
  • Table Effects
  • Merging Cells
  • Entering Text
  • Add, Delete, Resize Columns and Rows
  • Adjusting Table Alignment

Section E: Shapes and Effects

  • Drawing Techniques
  • Shape Types
  • Formatting Shapes
  • Shape Fill Options
  • Text Fills, Effects, and Styles
  • More Fill Options

Section F: Clip Art and Images

  • Working with Clip Art
  • Editing Clip Art
  • Working with Images
  • Manipulating Images
  • Picture Quick Styles
  • Picture Effects and SmartArt
  • 3-D Rotation
  • 3-D Emboss Effect

Section G: Moving, Arranging, and Distributing

  • Object Moving Techniques
  • Duplicating Objects
  • Rotating Objects
  • Arranging Objects
  • Using the Selection Pane

Section H: SmartArt Diagrams

  • Converting Bulleted Lists
  • Rearranging Bullet Order
  • Recoloring SmartArt Objects
  • SmartArt Styles
  • Resetting Graphics
  • Formatting SmartArt
  • More SmartArt Categories
  • Adding SmartArt Shapes

Section I: Backgrounds, Watermarks, and Photo Album

  • Creating Photo Albums
  • Customizing Album Options
  • Preview the Photo Album
  • Edit Photo Album
  • Inserting Screenshots
  • Compressing Pictures
  • Inserting Backgrounds
  • Hiding Background Objects
  • Creating Watermarks
  • Save as Picture
  • Using Watermarks as Backgrounds
  • Silk Screen Effect

PowerPoint 2010 Course (77-883)
Session 3

Section A: Multimedia

  • Supported File Types
  • Inserting Audio
  • Fade In/Out
  • Trim Audio
  • Additional Copy/Insert Options
  • Inserting Video
  • Poster Frame/Video Trim

Section B: Animations

  • Adding Animations
  • Entrance Effects
  • Emphasis Effects
  • Exit Effects
  • Animating Text
  • Animation Pane
  • Effect Options
  • Rolling Marquee Effect
  • Re-Order Animations
  • Animating Images
  • Motion Paths
  • Animating Charts

Section C: Customizing Slide Shows

  • Slide Shows
  • Applying Transitions
  • Individual Transitions
  • Transition Effect Options
  • Hiding Slides
  • Action Settings
  • Hyperlinks
  • Actions
  • Creating Custom Shows
  • Defining Custom Shows
  • Previewing Custom Shows

Section D: Delivery Formats

  • Printing
  • Media Compression
  • Version Control
  • PowerPoint Show
  • PDF/XPS
  • Recording Presentations
  • Packaging for CD
  • Creating a Video
  • Publishing to the Web

Section E: Proofing and Reviewing

  • Visual Check
  • Spell Check
  • Research Options
  • Adding Comments

Section F: Prepare and Protect

  • Compatibility Mode
  • Document Properties
  • Document Inspector
  • On-Slide/Off-Slide Content
  • Presentation Notes
  • Encryption and Passwords
  • Information Rights Management
  • IRM Document Protection
  • Digital Signatures
  • Mark as Final

Section G: Delivering the Presentation

  • Printing Tips
  • Optimization
  • Show Setup
  • Downsizing File Size
  • Presenting a Show
  • Pointer to Pen
  • Slide Show Help
  • Pointer Options
  • Navigation Techniques
  • Speaker's Notes
  • Slide Show Setup
  • Rehearse Slide Show Timing
  • Using Presenters View

Word 2010 Course (77-881, 77-887)
Session 1

Section A: Introduction

  • Exploring the New Layout
  • Understanding Backstage View
  • Understanding Application Layout
  • Insert Tab
  • Page Layout Tab
  • References Tab
  • Mailings Tab
  • Review Tab
  • View Tab
  • Hiding the Ribbon
  • Status Bar
  • Version Comparison

Section B: Navigating Documents

  • Show/Hide Paragraph Marks
  • Using CTRL+END/HOME
  • Word-by-Word Navigation
  • Paragraph Navigation
  • Page Navigation
  • Selecting Text
  • Views Defined
  • Print Layout/Full Screen Reading Views
  • Customizing View Options
  • Web Layout and Outline Views
  • Contextual Tabs
  • Working in Outline View
  • Draft View
  • Customizing the Status Bar

Section C: Using Backstage

  • Document Information
  • Document Permissions
  • Manage Versions
  • Recent, New, and Print Options
  • Save & Send Options
  • Change File Type on Save
  • Compatibility Check
  • Using Help
  • ALT Keyboard Shortcuts
  • File Management
  • File Sorting

Section D: Managing Document Design

  • Using Built-In Themes
  • Customizing Themes
  • Saving Themes
  • Using Quick Parts
  • Creating and Inserting AutoText
  • Document Property
  • Field Quick Parts
  • Building Blocks Organizer

Section E: Preparing Documents for Printing

  • Spelling and Grammar Checking
  • Adding Words to Dictionary
  • Using the Thesaurus
  • Proofing Options
  • AutoCorrect Options
  • Using AutoCorrect
  • Readability Statistics
  • Using Find
  • Replacing Text
  • Find Options
  • Creating Comments
  • Navigating Comments

Section F: Printing

  • Print Preview in Backstage
  • Print Options
  • Help Options
  • Office.com Help

Word 2010 Course (77-881, 77-887)
Session 2

Section A: Working with Templates

  • Built-in Templates
  • New from Template
  • Creating a Template
  • Office.com Templates

Section B: Formatting Text

  • Font Formatting Shortcuts
  • Mini Formatting Toolbar
  • Set Font Defaults
  • Format Text Effects
  • Working with Text Effects
  • Formatting Tools
  • Using Format Painter

Section C: Formatting Paragraphs

  • Paragraph Formatting Shortcuts
  • Paragraph and Page Defaults
  • Indentation
  • First Line Indents
  • Tab Stop Types
  • Creating Tab Stops
  • Dot Leader
  • Justification
  • Reset Paragraph Formatting

Section D: Organizing Data

  • Tables Defined
  • Creating Tables
  • Drawing Tables
  • Inserting Quick Tables
  • Nested Tables
  • Adjusting Table Layout
  • Converting Text to Tables
  • Adjusting Table Alignment
  • Inserting Formulas in Tables

Section E: Bulleted and Numbered Lists

  • Using Bulleted Lists
  • Using Numbered Lists
  • Multilevel Lists

Section F: Manipulating Page Layout

  • Using Sections
  • Inserting a Cover Page
  • Inserting a Blank Page
  • Inserting Breaks
  • Column Breaks
  • Inserting Column Breaks
  • Column Width
  • Page Size

Section G: Manipulating Page Backgrounds

  • Page Color
  • Page Borders
  • Watermarks
  • Customized Watermark
  • Manipulating Background Colors

Section H: Headers and Footers

  • Inserting and Removing Headers
  • Inserting Footers
  • Navigating Headers and Footers
  • Header and Footer Options

Word 2010 Course (77-881, 77-887)
Session 3

Section A: Working with Visual Content

  • Inserting Pictures
  • Formatting Pictures
  • Cropping Images
  • Inserting Clip Art
  • Image Text Wrapping
  • Adjust Wrapping
  • Working with Quick Styles

Section B: Shapes, SmartArt, and Charts

  • Inserting Shapes
  • Shape Styles
  • Shadow Effects
  • 3-D Effects
  • Adding Text to Shapes
  • Inserting SmartArt
  • Customizing SmartArt
  • SmartArt Tools
  • Inserting Charts
  • Chart Quick Layout
  • Inserting Screenshots
  • Inserting Text Boxes
  • Customizing Text Boxes
  • Selection Pane
  • Saving Text Boxes

Section C: Customizing Document Styles

  • Applying Styles
  • Creating and Saving Styles
  • Table of Contents
  • Hyperlinks
  • Links within a Document
  • E-mail Links

Section D: Citing References

  • Adding Captions
  • Table of Figures
  • Inserting Footnotes
  • Bibliography Style
  • Inserting a Bibliography
  • Creating an Index
  • Table of Authorities

Section E: Mail Merge

  • Mail Merge Process
  • Step by Step Wizard
  • Add or Filter Recipients
  • Writing Your Letter
  • Completing the Merge

Section F: Document Collaboration

  • Track Changes
  • Send for Review
  • Compare Documents
  • Document Protection
  • AutoSave Options
  • Managing Versions