Microsoft Office Suite

Office Workspace Basics
• Basic Window Elements
• Exploring Office Backstage
• Working with the Ribbon
• Customizing the Quick Access Toolbar
• Using the Status Bar

Introduction to Word
• What is Word?
• How to Open a Document
• Changing Views
• Navigating Documents
• How to Create Documents
• Using Templates
• Saving Documents
• How to Close Documents

Creating and Editing Text
• Entering Text
• How to Select Text
• Moving and Copying Text
• Using Repeat, Undo, and Redo
• Using AutoCorrect
• Inserting Symbols
• Inserting Fields

Formatting Text
• Introduction to Formats and Styles
• Applying Font Formats
• Text Alignment
• Changing Indents and Spacing
• Working with Tabs
• Applying Styles
• Modifying Styles
• Revealing and Clearing Formats
• Using the Format Painter

Designing Page Layouts
• Exploring Page Layout Options
• Changing Margins
• Adding Sections and Page Breaks
• Creating Columns
• Adding Bullets and Numbering
• Applying Borders and Shading

Mail Merge
• Envelopes
• Labels
• Merging Letters

Collaborating on Documents
• Adding Comments
• Tracking Document Changes
• Reviewing Tracked Changes
• E-Mailing Documents for Review
• Combining Reviewed Documents
• Using the Document Inspector
• Creating Folders

Printing and Converting Documents
• Using Print Preview
• Printing Documents
• Printing Envelopes and Labels
• Saving Documents in Different Formats
• Saving Documents as Web Pages

Working with Graphics
• Pictures, Inserting
• Inserting Pictures
• Resizing and Moving Pictures
• Inserting Shapes
• Adding Text Boxes
• Creating Charts
• Inserting SmartArt

Lists
• Creating Ordered and Unordered Lists
• Multilevel List

Columns
• Using and Formatting Columns

Creating and Formatting Tables
• Creating a Table
• Converting Text to a Table
• Formatting a Table
• Modifying the Table Layout
• Using Table Templates

Refining Document Content
• Exploring the Research Task Pane
• Using the Thesaurus
• How to Find and Replace Text
• Correcting Spelling and Grammar
• Using Word Count
• Working with Document Properties
• Adding a Hyperlink

Office Workspace Basics
• Basic Window Elements
• Exploring Office Backstage
• Working with the Ribbon
• Customizing the Quick Access Toolbar
• Working with KeyTips
• Using the Status Bar

Introduction to Excel
• What is Excel?
• Getting to Know the Excel Window
• Moving the Cell Selector
• Opening a Workbook
• Navigating a Workbook
• Selecting Cells
• Creating Workbooks
• Saving and Closing a Workbook

Entering and Editing Data
• Entering Text, Numbers, and Dates
• Editing Data
• Using AutoComplete and AutoFill
• Copying Data
• Moving and Clearing Data
• Using Undo and Redo
• Finding and Replacing Data

Introduction to Formulas and Functions
• What are Formulas and Functions?
• Entering Formulas
• Entering Functions
• Using the Insert Function Tool
• Using AutoSum
• Copying and Moving Formulas

Working with Functions
• Using Functions
• Testing Conditions with IF
• Using Date and Time Functions
• Using Linked Values in Formulas
• Copying Formula Values
• Controlling Automatic Calculations
• Conditional Formatting
• Vlookup and Hlookup
• PIvot Tables and Charts

Formatting Data
• Introduction to Formatting
• Applying Number Formats
• Applying Font Formats
• Changing Cell Alignment
• Applying Cell Styles
• Copying Formats
• Clearing Formats
• Finding and Replacing Formats

Formatting Worksheets
• Inserting and Deleting Rows and Columns
• Inserting and Deleting Cells
• Adjusting Column and Row Sizes
• Hiding Worksheet Components
• Inserting and Deleting Worksheets
• Copying and Moving Worksheets
• Customizing Sheet Tabs
• Adding a Worksheet Background

Adding Charts and Graphics
• Creating a Chart
• Enhancing a Chart
• Modifying Chart Data
• Changing Chart Types
• Drawing Shapes
• Inserting Pictures
• Creating SmartArt

Viewing and Printing Workbooks
• Changing View Options
• Splitting and Freezing a Worksheet
• Sorting and Filtering Data
• Customizing the Page Layout
• Adding Headers and Footers
• Modifying Page Breaks
• Previewing and Printing the Worksheet

Managing Workbooks
• Arranging Multiple Workbooks
• Adding Hyperlinks
• Working with Comments
• Saving Workbooks

Office Workspace Basics
• Basic Window Elements
• Exploring Office Backstage
• Working with the Ribbon
• Customizing the Quick Access Toolbar
• Working with KeyTips
• Using the Status Bar
• Getting Help

Introduction to PowerPoint
• What is PowerPoint?
• Opening a Presentation
• Changing Views
• Using Grids and Guides
• Saving and Closing a Presentation
• Managing Files and Folders

Adding and Formatting Text
• Creating a New Presentation
• Entering Text on a Slide
• Changing Text Formats
• Using the Format Painter
• Formatting Bullets
• Aligning Text
• Working with Tabs

Customizing Presentations
• Using Templates
• Adding a Slide
• Changing a Slide Layout
• Adding a Picture
• Customizing Templates
• Using the Slide Master
• Adding Headers and Footers
• Adding Speaker Notes
• Arranging Slides

Working with Shapes and Pictures
• Introduction to Drawing Tools
• Inserting Shapes
• Adding Text to Shapes
• Formatting Shapes
• Inserting and Formatting Picture Files
• Arranging Objects
• Adding an Action Button

Adding Objects and Effects
• Adding a Table
• Adding a Chart
• Adding SmartArt
• Adding a Hyperlink
• Adding Transition Effects
• Adding Animation Effects
• Adding a Sound Clip
• Adding a Video

Useful Tools
• Working in Outline View
• Importing an Outline from Word
• Finding and Replacing Text
• Using Proofing Tools
• Using AutoCorrect
• Printing Your Presentation

Delivering Your Presentation
• Creating a Custom Show
• Rehearsing a Slide Show
• Collaborating on Presentations
• Packaging a Presentation
• Running a Slide Show
• Broadcasting a Presentation to the Web

Office Workspace Basics
• Basic Window Elements
• Exploring Office Backstage
• Working with the Ribbon
• Customizing the Quick Access Toolbar
• Working with KeyTips
• Using the Status Bar
• Getting Help

Introduction to Access
• What is an Access Database?
• Opening a Database File
• Exploring Database Objects
• Creating a Database
• Changing Views
• Printing Database Objects
• Saving and Closing a Database File

Working with Tables
• What is a Table
• Working with Datasheets
• Moving Among Records
• Updating Records
• Adding Records to a Table
• Selecting Rows and Columns
• Finding Records
• Sorting Records
• Filtering Records

Designing Tables
• Adding a Table to a Database
• Adding Fields to a Table
• Adding a Lookup Field
• Setting a Primary Key
• Saving Design Changes
• Importing Data
• Exporting Data
• Performing Database Maintenance

Creating and Running Queries
• What is a Query?
• Creating a Query
• Working with Queries
• Saving and Running a Query
• Creating Calculated Fields
• Understanding Query Properties
• Creating Multi-Table Select Queries
• Joining Tables
• Enforcing Referential Integrity

Using Forms
• What is a Form?
• Using the Form Tool
• Creating a Form with the Form Wizard
• Working in Design View
• Changing the Form Layout
• Using Calculated Controls
• Working with Records on a Form

Generating Reports
• What is a Report?
• What is a Report Tool?
• Previewing and Printing a Report
• Saving a Report
• Designing a Report
• Changing a Report Layout
• Understanding Controls
• Using a Calculated Control
• Analyzing Dependencies

Completing the Desktop Application
• Designing the Navigation Form
• Creating a Database Password
• Creating a Backup of Database

Office Workspace Basics
• Basic Window Elements
• Exploring Office Backstage
• Working with the Ribbon
• Customizing the Quick Access Toolbar
• Using the Status Bar
• Getting Help

Introduction to Outlook
• What is Outlook?
• Using the Navigation Pane
• Working with Folders
• Exploring the Inbox
• Reading Your E-Mail
• Replying to an E-Mail Message
• Forwarding a Message
• Sending a New Message
• Adding an Attachment
• Viewing Sent Items

Managing Messages
• Flagging Messages for Follow Up
• Using Multiple E-Mail Accounts
• Adding a Signature
• Formatting Messages
• Setting Message Priorities
• Setting Delivery Options
• Using the Rules Wizard
• Printing Your E-Mail
• Saving Messages

Maintaining Contacts
• Adding Contacts
• Viewing Contact Information
• Modifying and Deleting Contacts
• Creating a Contact Group
• Sending a Message to a Contact
• Using Outlook to Call a Contact
• Printing Contact Information
• Exporting Contact Information
• Importing Contact Information

Coordinating Calendars
• Viewing Calendar Information
• Scheduling Appointments
• Adding Recurring Appointments
• Exploring Calendar Settings
• Planning a Meeting
• Scheduling a Meeting
• Responding to Meeting Requests
• Printing Your Calendar

Scheduling Tasks
• Creating Tasks
• Using the Task Form
• Viewing Tasks
• Assigning Tasks to Others
• Responding to Task Requests
• Keeping Notes

Organizing Information
• Managing Folders
• Copying Items among Folders
• Locating Items
• Creating Categories
• Arranging Items
• Controlling Junk E-mail
• Design Custom Views

Introduction to OneNote
• What is OneNote?
• Using OneNote
• Getting Started with OneNote
• Exploring the OneNote User Interface
• Working with the Ribbon
• Understanding Backstage View
• Customizing the Quick Access Toolbar
• Getting Help

Collecting Information
• Creating and Configuring Notebooks
• Creating Pages and Subpages
• Taking and Saving Notes
• Entering Content onto a Page
• Formatting Notes
• Spellchecking Notes

Adding and Annotating Content
• Adding and Organizing Sections and Pages
• Copying Content to Notebooks
• Attaching Files
• Adding Screen-clippings to Notebooks
• Adding Pictures
• Introducing Penmode
• Converting Handwriting
• Adding Equations
• Working with Audio and Video
• Tagging Notes

Formatting and Sharing Notebooks
• Working with Notebook Templates
• Setting Default Templates to Sections
• Changing Backgrounds
• Printing Notebook Content
• Saving and Converting Notebooks