MS Office 2010

Course Overview

Microsoft Office 2010 is the successor to Office 2007 and has introduced new features in the interface. This course provides introductory and advanced training on the full suite of products.

Course Outline

Access 2010 Basic – 4 hrs, 31 mins

  •  Getting Started with Access 2010
  •  The Essential Access Building Block: Tables
  •  Working with Tables
  •  Queries
  •  Designing Forms
  •  Generating Reports

Access 2010 Intermediate – 2 hrs, 4 mins

  •  Enhancing Tables
  •  Using a Variety of Query Types
  •  Charting
  •  Pivot Tables and Pivot Charts
  •  Macros

Access 2010 Advanced – 2 hrs, 35 mins      

  •  Advanced Tools in the Database
  •  Using Access with Other Applications
  •  Reports
  •  Queries
  •  Forms

Business Contact Manager 2010 – 3 hrs, 55 mins

  •  Basic Elements of Business Contact Manager
  •  Contacts and Accounts
  •  Opportunities and Marketing Campaigns
  •  Communications History And Linking
  •  Managing Databases
  •  Reports and Charts
  •  Project Tasks
  •  Business Projects
  •  Leads
  •  Customizing Elements in Business Contact Manager

Excel 2010 Basic – 3 hrs, 54 mins

  •  Basic Excel Elements
  •  Basic Excel Details
  •  Selecting and Editing Techniques
  •  Data Entry Techniques
  •  Performing Calculations
  •  Formatting with Fonts and Alignments
  •  Formatting Cells
  •  Working with the Excel Data

Excel 2010 Intermediate – 3 hrs, 47 mins

  •  Multiple Pages, Worksheets and Workbooks
  •  Creating Charts
  •  Intermediate Formula Techniques
  •  Applying Additional Formatting Techniques
  •  Organizing Worksheet and Table Data
  •  Inserting Graphic Objects
  •  Analyzing Data with Pivot Tables and Pivot Charts
  •  Finishing Details

Excel 2010 Advanced – 2 hrs, 38 mins

  •  Recording and Using Macros
  •  Advanced Functions
  •  Collaborating with Others
  •  Working with Data Tools
  •  Managing Data

InfoPath 2010 Basic – 2 hrs, 50 mins

  •  Getting Started with InfoPath 2010
  •  Using the InfoPath Filler 2010
  •  Designing with Tables
  •  Adding Basic Controls
  •  Working with Labels and Fields
  •  Editing and Formatting Techniques

InfoPath 2010 Intermediate – 2 hrs, 18 mins                     

  •  Form Layout
  •  Views
  •  Controls
  •  Customizing and Formatting
  •  Publishing Forms

InfoPath 2010 Advanced – 2 hrs, 50 mins               

  •  Repeating Controls, Optional Controls and Properties
  •  Working with Data
  •  Advanced Control Topics
  •  Changing the Form
  •  Creating Buttons, Tabs and Clickable

OneNote 2010 – 5hrs, 15 mins

  •  Getting Started with OneNote
  •  Working with Notes
  •  Transforming Items
  •  Adding Elements
  •  Using the Drawing Tools
  •  Using Formats
  •  Applying Additional Techniques
  •  Sharing Notebooks with Other Applications

Outlook 2010 Basic – 2 hrs, 36 mins

  •  Outlook Basics
  •  Message Composition
  •  Message Organization
  •  Contacts
  •  Appointments
  •  Meetings
  •  Tasks and Notes

Outlook 2010 Intermediate – 1 hr, 29 mins         

  •  Calendar Options
  •  Message Options
  •  The Journal
  •  Task Management
  •  Folder Sharing
  •  Outlook Environment Customization
  •  Finding Outlook Items

Outlook 2010 Advanced – 1 hr, 52 mins    

  •  Email Personalization
  •  Item Organization
  •  Outlook Data File Management
  •  Contacts
  •  Email Saving and Archiving
  •  Custom Forms
  •  Offline and Remote Working Environments

PowerPoint 2010 Basic – 2 hr, 15 mins

  •  Getting Started
  •  New Presentations
  •  Formatting Slides
  •  Using Drawing Objects
  •  Proofing and Delivering Presentations

PowerPoint 2010 Advanced – 1 hr, 39 mins

  •  Using Graphics and Multimedia
  •  Action Button, and Custom Slide Shows
  •  Distributing Presentations

Project 2010 Outline – 4 hrs, 1 mins

  •  Getting Started with Access 2010
  •  Creating a Project
  •  Entering Project Tasks
  •  Working with Project Tasks
  •  Resources in a Project Plan
  •  Finalizing the Project Plan

Project 2010 Advanced – 2 hrs, 12 mins

  •  Tracking a Project
  •  Project and Other Applications
  •  Printing and Reporting in Project
  •  Multiple Projects and the Sharing of Resources
  •  Displaying Appropriate Data and Making Data Look Great

SharePoint 2010 Designer – 2 hrs, 57 mins

  •  Introducing SharePoint 2010
  •  Creating a SharePoint 2010 Intranet
  •  Administering and Automating SharePoint
  •  Configuring Content Management
  •  Configuring Authentication

SharePoint 2010 Advanced – 1 hr, 50 mins

  •  Securing Content
  •  Managing SharePoint Customizations
  •  Configuring Services and Service Applications
  •  User Profiles and Social Networking
  •  Administering and Configuring SharePoint Search

Visio 2010 Basic – 2 hrs, 58 mins

  •  Getting Started with Visio 2010
  •  Creating a New Diagram
  •  Using Text
  •  Formatting Shapes
  •  Using Basic Visio Tasks

Visio 2010 Intermediate – 3 hrs.

  •  Finishing the Drawing
  •  Optimizing Design Tools
  •  Applying Additional Techniques
  •  Working with Stencils and Layers
  •  Creating Different Drawings

Visio 2010 Advanced – 2 hrs, 23 mins

  •  Clarifying Structure
  •  Working with Shapes, Multiple Pages and Shape Sheets
  •  Integrating Visio with Other Applications
  •  Introducing Data Graphics
  •  Running Reports and Modifying Elements

Word 2010 Basic – 2hrs, 27 mins    

  •  Word Basics
  •  Text Editing
  •  The Font Group
  •  Paragraph Formats
  •  Tables
  •  Graphics Objects
  •  The Look of the Page
  •  Document Proofing

Word 2010 Intermediate – 4 hrs, 32 mins              

  •  Handling Lists
  •  Charts and Tables
  •  Custom Table Styles and Themes
  •  Pictures
  •  Graphic Objects Options and Modifications
  •  Adding Quick Parts
  •  Text Flow Configurations
  •  Document Templates
  •  Mail Merging
  •  Macros

Word 2010 Advanced – 2 hrs, 38 mins                    

  •  Word and Other Programs
  •  Working with Other People
  •  Versions of Documents
  •  Reference Points
  •  Ease of Use Add-Ons
  •  Document Security