Office 2010 - Collection CBL58: Lab Assisted Training for Skills Training for Microsoft Office 2010 Online Training (Word, Excel, PowerPoint, Outlook)

Lab Assisted Microsoft Learning for Skills Training for Office 2010 (Word, Excel, PowerPoint, Outlook)


Paying for class:

Joining this class 7 days earlier is preferable. If you cancel this class the $75 value of the the Microsoft Online Subscriptions cannot be refunded. This Online Learning must be purchased for you before the class can begin. It is good for up to one year. You will be able to learn online, or use it for the next scheduled class with us - at which time you will receive the discount for the class equal to the Subscription paid.

Pre-requisite for Excel - 2003 Excel training if you have no previous Excel skills

Summary:


Course 4697 - New ribbon training
Course 10394 - Excel Certification 77-888
Course 10392 - Word Certification 77-887
Collection 10349 - Microsoft Outlook Certification - 77-885
Collection 10351 - Microsoft Power Point Certification - 77-883
Collection 10357 - Advanced training for Word
Beginner/Intermediate - Certification 77-881
Collection 77-882 - Advanced training for Excel for Beginner/Intermediate


You Will Receive

The Microsoft Online Subscription for these courses and collections so you can practice for up to a year from the date SmartPath LLC purchased it for you. Value: $75.00.

30 hours of lab assisted training from an instructor. Included in these hours are approximately 24 hours of Microsoft Online Training.

This is the course work you need to complete Office Certification for all the areas listed above.

Coffee, Tea & Snacks are free.

Parking is free.

Where: SmartPath LLC, 2018 156th Ave NE, Bellevue

Time & Date: Please click on the arrow down menu above

You will be sent directions to training once you join.

Author: Microsoft
ISBN 13: 5038470033612
Pub Date: 07/2010
Publisher: MICROSOFT LEARNING
User Level: Beginner/Intermediate

Product Information

This collection will you teach you core skills and knowledge on Word, Excel, PowerPoint and Outlook 2010.

This collection contains the following:
Course 4697: Introduction to the New Microsoft Office Fluent User Interface
Collection 10357: Skills Training for Microsoft Word 2010
Collection 10358: Skills Training for Microsoft Excel 2010
Collection 10351: Skills Training for Microsoft PowerPoint 2010
Collection 10350: Skills Training for Microsoft Outlook 2010

Student Prerequisites:
Learners familiar with Office 2003 or earlier should complete Course 4697: Introduction to the New Microsoft Office Fluent User Interface before taking the

other courses in this collection.

System Requirements:
Pentium II 400 MHz or higher
256MB RAM or more
Microsoft Internet Explorer 6.0 or higher
256k connection (broadband recommended)
Windows XP, 2000 or higher
Flash Player 7.0 or higher
Speakers and soundcard
To use the local labs included with the course, you will also need Office 2010 installed on your computer.

Subscription: 1 year.

Table Of Contents

Course 4697: Introduction to the New Microsoft Office Fluent User Interface

Exploring the New Office Fluent User Interface
Lesson Introduction
The Elements of the New Office Fluent User Interface
How to Find Commands in the New Office Fluent User Interface
Self Test

Using the Ribbon
Lesson Introduction
Microsoft Office Button
How to Modify Application Settings
How to Use the Tabs
What Are Contextual Tabs?
Self Test

Working with Galleries
Lesson Introduction
How to Use Galleries
How to Customize Galleries
Self Test

Working with Quick Access Toolbar, Mini Toolbar, and New Items on the Status Bar
Lesson Introduction
How to Customize the Quick Access Toolbar
How to Use the Mini Toolbar
How to Use the New Items on the Status Bar
Self Test
Module Summary

Collection 10357: Skills Training for Microsoft Word 2010

Course 10294: Beginner Skills in Microsoft Word 2010

Creating and Managing Documents
Introduction
Introducing Word 2010
Creating a Document
Create a Word 2010 Document
Viewing a Document
Document Views
The Formatting Options
Browsing a Document
Formatting and Replacing Content in a Document
Self Test

Enhancing Documents
Introduction
The Page Setup Options
Inserting Page Numbers and Page Breaks
Setting Up the Page and Inserting Page Numbers
Applying Quick Styles to a Document
Applying Themes to a Document
Creating a New Quick Style and Theme
Enhancing Images
Editing and Enhancing Images in a Document
Self Test

Reviewing and Sharing Documents
Introduction
Using the Proofing Features
The Language Features
Specifying a Preferred Language and Checking Spellings
Printing and Sharing a Document
Self Test

Module Summary


Glossary

Course 10391: Intermediate Skills in Microsoft Word 2010

Customizing Word 2010 Introduction Customizing Word Options Customizing the Quick Access Toolbar Customizing the Saving Options Self Test

Enhancing and Reviewing Documents Introduction Setting Up the Pages in a Document Reorganizing a Document Inserting Section Breaks in a Document Adding Tables and Captions Enhancing a Document and Inserting a Table Inserting Graphical Elements Reviewing a Document Managing Tracked Changes and Deleting Comments Self Test

Sharing and Protecting Documents Introduction Co-authoring a Document Viewing Documents on the Web Working with Documents by Using Word Mobile 2010 Protecting a Document Protecting a Word 2010 Document Self Test

Creating Complex Documents Introduction Inserting Table of Contents and Footnotes Creating a Mail Merge Using the Mail Merge Feature Self Test

Module Summary

Glossary

Course 10392: Advanced Skills in Microsoft Word 2010

Creating and Enhancing Documents
Introduction
Customizing the Ribbon
Introduction to Text Building Blocks
Embedding Objects in a Document
Adding References and Citations
Inserting an Equation
Embedding an Object and Adding Citation
Self Test

Reviewing and Finalizing Documents
Introduction
Comparing and Combining a Document
Combining Different Versions of a Document
Checking for Issues Before Sharing a Document
Checking for Issues
Editing Documents on the Web and a Mobile Device
Publishing a Document with Word Mobile 2010
Self Test

Creating Interactive Documents
Introduction
Creating a Master Document and Subdocuments
Creating a Master Document
Inserting an Index in a Document
Working with Interactive Documents
Adding Content Controls to a Document
Adding Content Controls
Using XML Tools
Self Test

Module Summary


Glossary

Collection 10358: Skills Training for Microsoft Excel 2010

Course 10296: Beginner Skills in Microsoft Excel 2010

Creating and Editing Worksheets
Introduction
Introduction to Excel 2010
Setting Excel Options
Creating a New Workbook
Adding and Moving Data in a Worksheet
Lab: Creating a Worksheet and Adding Data
Modifying a Worksheet
Working with Worksheets
Adding Formulas
Lab: Manipulating Worksheets
Printing a Worksheet
Self Test

Formatting Worksheet Data
Introduction
Modifying the Formatting of Cells
Using Borders and Margins
Lab: Formatting Cell Data
Introduction to Excel Table Styles
Sorting and Filtering a Data List
Reviewing Workbook Data
Using Proofing Tools
Self Test

Working with Charts and Graphics
Introduction
Creating and Editing Charts
Formatting Charts
Lab: Creating and Formatting Charts
Working with Shapes
Inserting Graphics
Inserting Objects in a Worksheet
Lab: Adding Graphics to a Worksheet
Self Test

Module Summary


Glossary


Course 10393: Intermediate Skills in Microsoft Excel 2010

Managing Workbooks in Excel 2010
Module Overview
Enhancing Workbooks
Introduction
Modifying Worksheets
Adding Headers and Footers
Editing Worksheets
Working with Office Themes
Formatting and Editing Cells
Conditional Formatting
Inserting Hyperlinks
Formatting Cell Data
Self Test

Working with Data
Introduction
Extending a Data Series
Analyzing Data by Using Data Lists
Cleaning Up and Outlining Data Lists
Using What-If Analysis
Performing Calculations
Working with Data Lists
Self Test

Working with Tables and Charts
Introduction
Creating and Editing Pivot Tables
Formatting PivotTables
Analyzing PivotTable Data
Working with a PivotTable
Working with PivotCharts
Editing Charts
Using Table Styles
Using PivotTables
Self Test

Working with Advanced Features of Excel 2010
Introduction
Setting Excel Options
Setting Workbook Properties
Customizing the Ribbon
Customizing the Quick Access Toolbar
The Track Changes Feature
Linking and Embedding Objects
Sharing a Workbook
Working with the Advanced Features
Self Test

Module Summary


Glossary


Course 10394: Advanced Skills in Microsoft Excel 2010

Working with Advanced Features of Excel 2010
Module Overview

Customizing Excel 2010
Introduction
Setting Excel 2010 Options
Defining Workbook Protection Levels
Customizing Worksheet Views
Self Test

Working with Worksheet Data
Introduction
Manipulating Worksheet Data
Creating Named Ranges
Managing Named Ranges
Inserting Equations
Analyzing Data
Working with a PowerPivot Workbook
Lab: Working with Worksheet Data
Self Test

Working with External Data
Introduction
Defining and Editing External Data Connections
Working with XML Data
Creating and Editing Web Queries
Lab: Working with External Data
Self Test

Working with Tables and Charts
Introduction
Working with Charts
Creating a Sparkline Chart
Creating Different Types of Charts
Adding Trendline to a Chart
Analyzing Pivot Table Data
Lab: Working with Tables and Charts
Self Test

Automating Workbooks
Introduction
Introduction to Macros
Creating a Macro
Editing a Macro
Running and Deleting a Macro
Lab: Working with Macros
Self Test

Module Summary


Glossary

Collection 10351: Skills Training for Microsoft PowerPoint 2010

Course 10295: Beginner Skills in Microsoft PowerPoint 2010

The PowerPoint 2010 Environment
Introduction
Managing the PowerPoint Environment
Using Different Presentation Views
Working with the PowerPoint Windows
Using the PowerPoint Environment
Self Test

Creating a Basic PowerPoint Presentation
Introduction
Using Templates
Creating a Basic Presentation
Working with Text and Text Boxes
Inserting and Modifying WordArt
Inserting and Formatting a Table
Working with Custom Animation
Organizing Slides into Sections
Creating a PowerPoint Presentation
Self Test

Working with Images, Illustrations, and Media
Introduction
Inserting and Modifying a Picture
Inserting and Modifying a Shape
Inserting and Modifying a SmartArt Graphic
Inserting and Formatting a Chart
Adding Video Clips
Adding Images and Illustrations
Self Test

Finalizing and Delivering a Presentation
Introduction
Running Spell Check
Sending a Slide Show for Review
Working with Comments
Saving a PowerPoint Presentation
Preparing a Slide Show for Delivery
Delivering a Presentation
Finalizing a Presentation
Self Test

Module Summary


Glossary


Course 10523: Intermediate Skills in Microsoft PowerPoint 2010

Working with Text Boxes, Tables, and Multimedia
Introduction
Working with Text Boxes
Drawing and Formatting a Table
Modifying a Picture
Inserting and Formatting a Chart
Inserting and Formatting a SmartArt Diagram
Working with Videos
Creating a Multimedia-Rich Presentation
Self Test

Finalizing and Delivering a Presentation
Introduction
Modifying Color and Font Schemes
Filling Backgrounds
Setting Headers and Footers
Delivering a Presentation
Finalizing a Slide Show
Self Test

Module Summary


Glossary


Course 10386: Advanced Skills in Microsoft PowerPoint 2010

Customizing the PowerPoint 2010 User Interface and Elements
Introduction
Changing the Default Options in PowerPoint 2010
Customizing the Quick Access Toolbar and the Ribbon
Creating a Slide Master
Creating a Theme
Customizing Slide Master and Creating New Layout
Self Test

Adding Information, Multimedia, and Animation Enhancements
Introduction
Incorporating Existing Content
Working with Clip Art, Images, and Illustrations
Editing a Video
Assigning Action Settings to Content
Working with Multimedia
Self Test

Finalizing and Delivering a Presentation
Introduction
Saving and Printing a Slide Show
Setting the Slide Show Options
Creating a Custom Slide Show
Broadcasting a Slide Show
Collaborating by Using PowerPoint 2010
Recording a Presentation
Self Test

Module Summary


Glossary

Collection 10350: Skills Training for Microsoft Outlook 2010

Course 10293: Beginner Skills in Microsoft Outlook 2010

Working with Outlook Views and Items
Introduction
Customizing User Interface Elements
Customizing Program Elements
Using Help in Outlook 2010
Viewing and Arranging Outlook Items
Sorting Messages in a List View
Organizing E-Mail Messages in Folders
Locating and Filtering Items
Working with Outlook Views and Items
Self Test

Exploring E-Mail Communication
Introduction
Creating and Sending an E-Mail Message
Printing a Message
Creating an E-mail Signature
Viewing Messages and Attachments
Responding to a Message Sender
Interacting with a Message Sender
Composing and Sending a Message
Self Test

Connecting with Contacts
Introduction
Creating and Managing Contact Records
Viewing Contact Information
Communicating with Saved Contacts
Connecting with Other Outlook Users
Working with Contacts
Self Test

Planning and Scheduling Work
Introduction
Creating and Managing Appointments
Creating Meeting Requests
Managing Meeting Requests
Responding to a Meeting Request
Creating and Managing Tasks
Creating and Managing Notes
Creating and Managing Journal Entries
Scheduling Your Work
Self Test

Module Summary


Glossary


Course 10524: Intermediate Skills in Microsoft Outlook 2010

Enhancing E-Mail Communication
Introduction
Working with a Nonstandard E-Mail Message
Adding Design and Media Elements
Working with Tables and WordArt Objects
Creating and Managing Quick Parts
Reviewing E-Mail Messaging Features
Taking Actions on a Message
Managing Automatic Replies
Managing Junk E-Mail Messages
Cleaning Up the Mailbox
Creating a Nonstandard E-Mail Message
Self Test

Managing Contacts and Schedules
Introduction
Managing Outlook Item Tags
Working with Contacts
Working with Contact Groups
Customizing the Calendar View
Managing Meeting Requests
Customizing the To-Do Bar
Planning a Meeting
Self Test

Module Summary


Glossary


Course 10385: Advanced Skills in Microsoft Outlook 2010

Managing E-Mail Accounts
Introduction
Adding E-Mail Accounts in Outlook 2010
Adding a Microsoft Exchange E-Mail Account Manually
Removing an E-Mail Account
Modifying E-Mail Account Settings
Using Outlook Web Application
Creating an Outlook Data File
Managing Microsoft Add-ins
Managing Trust Center Settings
Adding a Microsoft Exchange E-Mail Account
Self Test

Optimizing E-Mail Communication
Introduction
Managing Send/Receive Operations
Configuring Outlook Options
Customizing Message Settings
Configuring Message Properties
Defining Print Styles
Creating and Managing Quick Steps
Reviewing E-Mail Messaging Features
Configuring Send/Receive Settings
Self Test

Module Summary


Glossary