MS Office Training

Office 2013 Essentials Product Catalogue

Access 2013 Essentials

This workshop is designed to teach you a deeper understanding of Access 2013 in a practical way. The participants will learn how to use the basic features of Access to help them better manage a database. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advance features right on a computer.

This workshop is meant to provide a safe learning environment where they can practice and learn Access 2013 Essentials functions without worrying about making mistakes. Access 2013 features a new framework that is designed for one purpose enable users to create data-centric web applications. Taking the time to learn the basic features of Access 2013 will increase their knowledge on how databases work and make creating and managing an Access 2013 database easier for everyone.

Outline

Module One: Getting Started

Housekeeping Items Parking Lot Pre-Assignment Review Workshop Objectives Action Plans

Module Two: Opening and Closing Access

Opening Access
Using the Recent List and Opening Files
Understanding Security Warnings
Understanding the Ribbon and the Status bar (minimize and unpin the ribbon) About Your Account (and feedback)
Closing Files vs. Closing Access
Module Two: Review Questions

Module Three: An Introduction to Databases

About Common Database Terms (relational database, record, field, field value, key, etc.) Using the Navigation Pane
Understanding Tables and Table Relationships
Understanding Queries

Understanding Forms Understanding Reports
Closing Database Objects Module Three: Review questions

Module Four: Sharing Data using Apps

About Apps vs. Desktop Databases Creating a New App Using a Template Selecting a Table Template
Launching the App

Entering Data
Understanding the App Layout Uploading Your Changes Module Four: Review questions

Module Five: Working in Your App

Using the Search Box
Using the Action Bar for Predefined Actions (Add, Edit, Delete, Save, Cancel Changes) About Automatically Generated Controls (Related Data Control, Autocomplete Control) Viewing Related Items
Using AutoComplete to Look Up a Related Item
Grouping and Summarizing Data
Module Five: Review questions

Module Six: An Introduction to Desktop Databases

Opening a Table in Datasheet View About Keys
About Data Types
Entering and Editing Data Selecting Records

Deleting Records
About Fields
Module Six: Review questions

Module Seven: Understanding Basic Table Tasks

Entering a New Record
Saving Records
Using the Clipboard (Cut, Copy and Paste) Formatting Text
Adding a Field by Entering Data
Module Seven: Review Questions

Module Eight: Working With Fields

Adding a Specific Type of Field (basic) Changing Field Name, Caption, or Description Changing the Data Type
Changing Field Format
Deleting a Field
Module Eight: Review Questions

Module Nine: Navigating Records

Filtering Records
Sorting Records (including remove sort) Searching for Records Using the Search Box Finding and Replacing Text
Navigating Records
Module Nine: Review Questions

Module Ten: An Introduction to Queries, Forms, and Reports

Types of Queries
Creating a Query with the Wizard Executing a Query
About the Different Form Views Viewing a Report
Using Print Preview
Module Ten: Review Questions

Module Eleven: Protecting Your Data

Planning Backups
Backing Up a Database
Restoring a Database
Restoring Objects in a Database Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise Parking Lot
Action Plans and Evaluations

Excel 2013 Essentials

Your participants will learn how to use the basic features of Excel 2013. This workshop is designed to provide a basic understanding of Excel 2013. Participants will be shown a practical way of learning with a hands-on and customizable approach. They will also get a chance to experience some of the new features that are offered in Excel 2013.

Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen that makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive – and better information leads to better decision-making!

Outline

Module One: Getting Started

Housekeeping Items Parking Lot Pre-Assignment Review Workshop Objectives Action Plans

Module Two: Opening Excel

Opening Excel
Using the Recent List
Opening Files
Creating a Blank Workbook
Creating a Workbook from a Template Module Two: Review Questions

Module Three: Working with the Interface

Understanding the Ribbon and the Status Bar About Your Account
Using Backstage View
Understanding Worksheets vs. Workbooks Closing Files

Closing Excel
Module Three: Review Questions

Module Four: Your First Worksheet

Entering Data
Using Flash Fill
Using Auto Fill
Editing Data
Adding Rows and Columns Checking Your Spelling
Module Four: Review Questions

Module Five: Viewing Excel Data

An Overview of Excel’s Views Switching Views
Creating Custom Views Using Zoom

Switching Between Open Files Module Five: Review Questions

Module Six: Building Formulas

The Math Basics of Excel
Building a Formula
Editing a Formula
Copying a Formula
Relative vs. Absolute References
Using the Status Bar to Perform Calculations Module Six: Review Questions

Module Seven: Using Excel Functions

Formulas vs. Functions
Using AutoComplete
Using the SUM Function
Using Other Basic Excel Functions Understanding the Formulas Tab Understanding the Function Names Module Seven: Review Questions

Module Eight: Using Quick Analysis

Formatting Tables
Creating Quick Analysis Charts Calculating Totals
Creating Quick Analysis Tables Using Sparklines
Module Eight: Review Questions

Module Nine: Formatting Your Data

Changing the Appearance of Text (include borders and fill)
Changing the Appearance of Numbers
Working with Alignment Options /Using the Wrap Command/Using Merge Removing Formatting
Module Nine: Review Questions

Module Ten: Using Styles, Themes, and Effects

Using Conditional Formatting Using Table Styles
Using Cell Styles
Formatting Cells

An Overview of the Page Layout Tab Changing the Theme
Module Ten: Review Questions

Module Eleven: Printing and Sharing Your Workbook

Setting up Your Page
Previewing and Printing Your Workbook Inviting People
E-Mailing Your Workbook
Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

OneNote 2013 Essentials

Your participants will learn how to use OneNote 2013. This workshop is designed to provide a basic understanding of OneNote 2013. Participants will be shown a practical way of learning with a hands-on and customizable approach. They will also get a chance to experience some of the new features that are offered in OneNote 2013.

OneNote 2013 allows you to track appointments, take meeting notes, record research, and keep to-do items all in one place. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of OneNote. OneNote 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive – and better information leads to better decision making!

Outline

Module One: Getting Started

Housekeeping Items Parking Lot Pre-Assignment Review Workshop Objectives Action Plans

Module Two: Your First Notebook

Opening OneNote
About Your Notebooks and the Cloud/ About Universal Access to Notebooks Understanding the Interface
Understanding Your Notebook
Saving Notebooks
Module Two: Review Questions

Module Three: Working with Text

Typing Text and Titles Using Copy and Paste Using Undo and Redo Adding Extra Writing Space Deleting Text

Formatting Text
Module Three: Review Questions

Module Four: Working with Pages and Sections

Adding Pages and Sub-Pages
Using the Templates Pane
Adding Sections and Section Groups Moving, Renaming, and Deleting Pages Working with Sections and Section Groups Module Four: Review Questions

Module Five: Staying Organized

The Navigation Bar
Drag and Drop
View Recent Edits
Working with Page Versions Using Authors

Using the Notebook Recycle Bin Module Five: Review Questions

Module Six: Tagging and Searching Notes

Using Instant Search
Tagging Notes
Creating a New Tag
Working with Outlook Tasks Module Six: Review Questions

Module Seven: Using the OneNote Clipping Tool

About the Quick Notes Section Taking a Screen Clipping Sending to OneNote
Creating a New Quick Note Module Seven: Review Questions

Module Eight: Inserting Basic Objects

Inserting a Table
Adding a File
Adding Images
Inserting a Link
Inserting an Equation
Using the Calculator
Module Eight: Review Questions

Module Nine: Drawing in OneNote

Using OneNote with a Touchscreen Choosing a Pen, Color and Thickness Drawing Freehand or Handwriting Drawing Shapes

Selecting, Panning and Erasing Objects Converting Ink to Text
Module Nine: Review Questions

Module Ten: Reviewing Your Notes

Using OneNote Views Checking Your Spelling
Using the Thesaurus
Time Stamping Items
Module Ten: Review Questions

Module Eleven: Sharing Your Notes

Inviting People
Sending A Link
Using the OneNote Web App Printing Your Notes
Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise Parking Lot
Action Plans and Evaluations

Outlook 2013 Essentials

Your participants will learn how to use the basic features of Outlook 2013. This workshop is designed to provide a good understanding of Outlook 2013. Participants will be shown a practical way of learning with a hands-on and customizable approach. They will get a chance to experience some of the new features that are offered in Outlook 2013.

Outlook 2013 helps you manage your busy life through its calendar and social connectors. With Outlook 2013 you are given a sleeker more efficient way to organize and communicate. With a new and improved user interface and a more powerful search tool your participants will increase their productivity, as they will be able to manage their information more efficiently!

Outline

Module One: Getting Started

Housekeeping Items Parking Lot Pre-Assignment Review Workshop Objectives Action Plans

Module Two: Opening and Closing Outlook

Opening Outlook
Setting up an E-mail Account
Understanding the Ribbon and the Status Bar Using Backstage View
About Your Office Account
Closing Outlook
Module Two: Review Questions

Module Three: Understanding the Interface

About the Folders Pane
About the Reading Pane
About the To-Do Bar Pane
About the People Pane
Peeking at Other Modes
About the View Tab
Module Three: Review Questions

Module Four: Working with the Message List and the Reading Pane

Previewing Messages
About the Reading Pane Opening or Saving Attachments Filtering and Sorting Messages Using Inline Replies
Module Four: Review Questions

Module Five: Using Message List Commands

Flagging Messages
Deleting Messages
Marking Messages as Read or Unread Ignoring E-mail
Module Five: Review Questions

Module Six: Creating a New E-mail

Creating an E-mail Addressing an E-mail Attaching a File
Sending the Message
Module Six: Review Questions

Module Seven: Managing E-mail

Printing a Message
About the Folder Pane
Creating Folders
Moving Messages to Folders
Renaming, Moving, and Deleting Folders Working with Favorite Folders
Sending and Receiving Mail
Module Seven: Review Questions

Module Eight: Searching for Items

Understanding Search Folders Setting Up and Using Search Folders Using Instant Search
Using Advanced Search
Using Contact Search
Module Eight: Review Questions

Module Nine: An Introduction to the Calendar

Getting Started
Using the Weather Bar Creating an Appointment Changing Your Calendar View Editing an Appointment Managing Reminders
Module Nine: Review Questions

Module Ten: An Introduction to Tasks

Getting Started
Creating a New Task
Editing a Task
Updating Task Status
Basic Task Views
Module Ten: Review Questions

Module Eleven: An Introduction to Contacts

Getting Started
Creating a New Contact
Editing a Contact
Organizing Contacts
Basic Contact Views
Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise Parking Lot
Action Plans and Evaluations

PowerPoint 2013 Essentials

Your participants will learn how to use the standard features of PowerPoint 2013. This workshop is designed to get into the basic features of PowerPoint 2013. Participants will be shown a practical way of learning with a hands-on and customizable approach. They will get a chance to experience some of the new features that are offered in PowerPoint 2013.

PowerPoint 2013 is the world’s premier presentation software. With PowerPoint 2013 you are provided a new landing screen that makes launching and creating documents easier than previous versions. There is also an improved Presentation View with gives your presentations that extra focus. PowerPoint 2013 also has an improved user interface with an array of powerful tools to help you share your presentations through Skydrive!

Outline

Module One: Getting Started

Housekeeping Items Parking Lot Pre-Assignment Review Workshop Objectives Action Plans

Module Two: Opening PowerPoint

Opening PowerPoint
Opening Recent and Other Files
Creating a New Presentation Using a Template Creating a New Presentation Using a Theme Creating a New Blank Presentation
Module Two: Review Questions

Module Three: Working with the Interface

Understanding the Ribbon and the Status Bar About Your Account
Using Backstage View
Saving Files

Closing Files vs. Closing PowerPoint Module Three: Review Questions

Module Four: Your First Presentation

About Slide Types
Adding Slides
Using the Slides Tab
About Types of Content
Using a Content Placeholder Module Four: Review Questions

Module Five: Working with Text

Adding Text
Selecting, Editing, and Deleting Text Using Cut, Copy, and Paste
Using the Office Clipboard
Using Undo and Redo
Finding and Replacing Text
Module Five: Review Questions

Module Six: Formatting Text and Paragraphs

Formatting Fonts
Clearing Formatting
Using the Font Dialog
Adding Bullets and Numbering Using the Paragraph Dialog Module Six: Review Questions

Module Seven: Adding Pictures

Inserting a Picture from a File or Online Adding Screenshots
An Introduction to the Picture Tools Tab Resizing, Moving, and Deleting a Picture Module Seven: Review Questions

Module Eight: Advanced Formatting Tasks

Using the Format Painter Changing Slide Layout
Changing the Theme and Variants About Slide Sizes

Changing to Standard or Widescreen Slide Size Module Eight: Review Questions

Module Nine: Working with Transitions and Animations

Adding a Slide Transition Setting Slide Advance Options Add a Basic Animation
Using the Animation Painter Module Nine: Review Questions

Module Ten: Setting Up Your Slide Show

Previewing Your Slide Show Using the Set Up Show Dialog Recording a Narration
Timing Your Show

Hiding Slides
Module Ten: Review Questions

Module Eleven: Showtime!

Our Top Five PowerPoint Tips Starting a Show
About the In Show Tools Changing Your Pointer
Switching to a Blank Screen Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise Parking Lot
Action Plans and Evaluations

 

Publisher 2013 Essentials

Your participants will learn how to use the basic features of Publisher 2013. This workshop is designed to get into the more standard features of Publisher 2013. Participants will be shown a practical way of learning with a hands-on and customizable approach. They will get a chance to experience some of the new features that are offered in Publisher 2013.

Publisher 2013 gives you the ability to create any type of publication. With Publisher 2013 you are provided a new landing screen that makes launching and creating documents easier than previous versions. A new set of templates along with improved graphic editing tools are included with Publisher 2013. Users are also given an improved interface with an array of powerful tools to help you share your publications through Skydrive!

Outline:

Module One: Getting Started

Housekeeping Items Parking Lot Pre-Assignment Review Workshop Objectives Action Plans

Module Two: Opening Publisher

Opening Publisher
Opening Recent and Other Files
Creating a New Publication Using a Template Creating a New Blank Publication
Module Two: Review Questions

Module Three: Working with the Interface

Understanding the Ribbon and the Status Bar (minimize and unpin the ribbon) About Your Account (and feedback)
Editing Your Business Information (Intro to the Backstage View)
Saving Files

Using the Pages Pane
Closing Files vs. Closing Publisher Module Three: Review Questions

Module Four: Your First Publication

Adding Pictures
Adding Text
Adding Hyperlinks
Adding Page Parts
Adding Business Information Adding a New Page

Module Four: Review Questions

Module Five: Working with Pictures

Adding More Than One Picture at a Time (working with the scratch area) Inserting a Picture Placeholder
Swapping Pictures
An Introduction to the Picture Tools Tab

Adding a Picture Caption
Resizing, Moving, and Deleting a Picture Module Five: Review Questions

Module Six: Basic Editing Tasks

Selecting, Editing, and Deleting Text Using Cut, Copy, and Paste
Using the Office Clipboard
Using Undo and Redo

Finding and Replacing Text Module Six: Review Questions

Module Seven: Formatting Fonts

Changing Font Fact and Size Changing Font Color
Adding Font Enhancements Using the Font Dialog Clearing Formatting

Module Seven: Review Questions

Module Eight: Formatting Paragraphs

Changing Line Spacing and Paragraph Spacing Setting the Alignment
Indenting Text
Adding Bullets and Numbering

Using the Paragraph Dialog Applying Styles
Module Eight: Review Questions

Module Nine: Working with Objects

Drawing Shapes
An Introduction to the Drawing Tools Tab Inserting Tables
Linking Text Boxes
Formatting Objects
Aligning and Distributing Objects
Module Nine: Review Questions

Module Ten: Working with Pages

Using Color and Font Schemes
Working with Page Backgrounds and Picture Backgrounds Changing the Page Setup
Working with the Header & Footer Options
Deleting, Moving, and Renaming Pages
Module Ten: Review Questions

Module Eleven: Publishing Your Work

Proofing Your Publication
Printing or Previewing Your Publication
Sharing Your Publication
Saving for Photo Printing or a Commercial Printer Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise Parking Lot
Action Plans and Evaluations

Word 2013 Essentials

Your participants will learn how to use the basic features of Word 2013. This workshop is designed to get into the standard features of Word 2013. Participants will be shown a practical way of learning with a hands-on and customizable approach. They will get a chance to experience some of the new features that are offered in Word 2013.

Word 2013 now has the ability to edit PDF files without the need to convert. With Word 2013 you are also provided a new landing screen which makes launching and creating documents easier than ever. A new set of templates and design tools are included with Word 2013. Users are also given an improved interface with an array of powerful tools to help you share your documents through Skydrive!

Outline:

Module One: Getting Started

Housekeeping Items The Parking Lot Workshop Objectives Action Plans

Module Two: Opening Word

Opening Word
Using the Recent List
Opening Files
Creating a Blank Document
Creating a Document from a Template Module Two: Review Questions

Module Three: Working with the Interface

Understanding the Ribbon and the Status Bar (minimize and unpin the ribbon) About Your Account (and feedback)
Using Backstage View
Saving Files

Closing Files
Closing Word
Module Three: Review Questions

Module Four: Your First Document

Typing Text
Selecting Text with the Mouse or Keyboard Editing and Deleting Text
Dragging and Dropping Text
Inserting a Symbol or Number
Starting a New Page (insert/page break) Module Four: Review Questions

Module Five: Basic Editing Tasks

Using Cut, Copy, and Paste Using Undo and Redo
Finding and Replacing Text Setting Paste Options Checking Your Spelling
Module Five: Review Questions

Module Six: Working with Font Formatting

Understanding Levels of Formatting Changing Font Face and Size Changing the Font Color Highlighting Text

Adding Font Enhancements Module Six: Review Questions

Module Seven: Advanced Formatting Tasks

Changing Case
Using the Format Painter
Using the Font Dialog
Clearing Formatting
Module Seven: Review Questions

Module Eight: Formatting Paragraphs

Changing Spacing
Setting the Alignment
Using Indents and Tabs
Adding Bullets, Numbering, and Multilevel Lists Adding Borders and Shading
Using the Paragraph Dialog
Module Eight: Review Questions

Module Nine: Working with Styles

About Styles
Applying a Style
Changing the Theme
Changing the Style Set (on Design tab now) Changing Theme Colors and Fonts
Module Nine: Review Questions

Module Ten: Formatting the Page

Formatting Text as Columns Changing Page Orientation Changing the Page Color Adding a Page Border
Adding Headers and Footers Module Ten: Review Questions

Module Eleven: Sharing Your Document

Previewing and Printing Your Document Inviting People (Share/Invite People) E-Mailing Your Document
Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise Parking Lot
Action Plans and Evaluations

Office 2013 Advanced Access 2013 Advanced

This workshop is designed to teach you a deeper understanding of Access 2013 in a practical way. The participants will learn how to use the advance features of Access to help them better manage a database. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advance features right on a computer.

This workshop is meant to provide a safe learning environment where they can practice and learn Access 2013 Advanced functions without worrying about making mistakes. Access 2013 features a new framework that is designed for one purpose―enable users to create data-centric web applications. Taking the time to learn the advanced features of Access 2013 will increase their knowledge on how databases work and make creating and managing an Access 2013 database easier for everyone.

Outline

Module One: Getting Started

Housekeeping items Pre-Assignment Review Parking Lot
Workshop Objectives Action Plans

Module Two: Using App Views

Understanding Views
Adding a New View
Editing a View
Deleting a View
Adding a Popup View
Module Two: Review Questions

Module Three: Customizing Apps (I)

Checking Your Database Name or Server Location Modifying the Action Bar
Opening a Table for Editing
Moving, Resizing, or Deleting Controls

Module Three: Review Questions

Module Four: Customizing Apps (II)

Adding Controls from the Ribbon Adding Controls from the Field List Changing Control Properties Module Four: Review Questions

Module Five: Advanced Record Tasks

Showing Totals
Adding from Outlook
Saving a Record as an Outlook Contact Adjust Row Height
Hiding and Un-hiding Fields
Freezing and Unfreezing Fields Formatting Text
Module Five: Review Questions

Module Six: Adding Other Types of Fields

Adding Rich Text and Long Text Fields Adding Attachment Fields
Adding Hyperlink Fields
Adding Lookup & Relationship Fields Adding Calculated Fields

Module Six: Review Questions

Module Seven: Advanced Field Tasks

Adjusting the Field Size/Width Setting Field Default Value
Working with More Fields
Working with Field Validation Options Using the Field List

Module Seven: Review Questions

Module Eight: Working in Table Design View

Opening Design View
Working with Field Properties Setting the Primary Key
Using the Properties Sheet Working with Table Properties Viewing Table Relationships Using Relationship Tools Viewing Object Dependencies Module Eight: Review Questions

Module Nine: Working with External Data

Linking Data
Importing Data
Using the Table Analyzer Refreshing Data
Exporting Data
Module Nine: Review Questions

Module Ten: Creating Queries

Creating a Select Query Creating a Make Table Query Creating an Append Query Creating a Cross tab Query Showing and Removing Tables Module Ten: Review Questions

Module Eleven: Creating Forms and Reports

Creating a Form with the Form Wizard Creating a Report with the Report Wizard Modifying Form Layout
Navigating the Field List

Key Features on the Form Tools Tabs Key Features on the Report Tools Tabs Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise Parking Lot
Action Plans and Evaluations

Excel 2013 Advanced

Your participants will learn how to use the advanced features of Excel 2013. This workshop is designed to get into the more advanced features of Excel 2013. Participants will be shown a practical way of learning with a hands-on and customizable approach. They will get a chance to experience some of the new features that are offered in Excel 2013.

Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen that makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive – and better information leads to better decision-making!

Outline

Module One: Getting Started

Housekeeping Items Parking Lot Pre-Assignment Review Workshop Objectives Action Plans

Module Two: SmartArt and Objects

Inserting SmartArt
Editing the Diagram
Adding Pictures
Adding Text Boxes
Drawing Shapes
About the Contextual Tabs Module Two: Review Questions

Module Three: Auditing

Tracing Precedent cells
Tracing the Dependents of a Cell
Displaying Formulas Within the Sheet
Adding, Displaying, Editing ,and Removing Comments Module Three: Review Questions

Module Four: Creating Charts

Using Recommended Charts Inserting a Chart
Overview of the Chart Tools Tabs Understanding the Parts of a Chart Resizing and Moving the Chart Module Four: Review Questions

Module Five: Working with Charts

Using Chart Elements
Using Chart Styles and Colors Changing the Chart Style Using Chart Filters
Working with Data Labels Module Five: Review Questions

Module Six: Creating Pivot Tables and Pivot Charts

Inserting a PivotTable using Excel Recommendations

Choosing Fields and Grouping Data (using one field list to create different types of PivotTables)

Overview of the Pivot Table Tools Tabs
Changing the Data Displayed and Refreshing the PivotTable
Creating a Pivot Chart from a Pivot Table or Data (including a stand-alone) Some Real-life Examples
Module Six: Review Questions

Module Seven: Macros

Displaying the Developer Tab
Recording and Running macros
Changing the Security Level
Customizing and Changing the Quick Access Toolbar Module Seven: Review Questions

Module Eight: Solving Formula Errors

Using Named Ranges Understanding Formula errors Using the Trace Errors Commands Using Error Checking
Evaluating Formulas
Module Eight: Review Questions

Module Nine: Using What If Analysis

Using Goal Seek
Using the Scenario manager Using a One Input Data Table Using a Two Input Data Table Module Nine: Review Questions

Module Ten: Managing Your Data

Transposing Data from Rows to Columns Using the Text to Columns Feature Checking for Duplicates
Creating Data Validation Rules Consolidating Data

Module Ten: Review Questions

Module Eleven: Grouping and Outlining Data

Grouping Data
Adding Subtotals
Outlining Data
Viewing Grouped and Outlined Data Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

OneNote 2013 Advanced

Your participants will learn how to use the advanced features of OneNote 2013. This workshop is designed to provide an in-depth understanding of OneNote 2013. Participants will be shown a practical way of learning with a hands-on and customizable approach. They will also get a chance to experience some of the new features that are offered in OneNote 2013.

OneNote 2013 allows you to track appointments, take meeting notes, record research, and keep to-do items all in one place. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of OneNote. OneNote 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive – and better information leads to better decision making!

Outline

Module One: Getting Started

Housekeeping Items Parking Lot Pre-Assignment Review Workshop Objectives Action Plans

Module Two: Working with Notebooks

What You Need to Know About the New File Format Using the Notebook Migration Tool
Password Protecting Your Notebook
Using OneNote Backups

Module Two: Review Questions

Module Three: Using Additional Notebooks

Creating a New Notebook
Opening Notebooks
Working with Notebook Information and Settings Setting OneNote Options
Module Three: Review Questions

Module Four: Formatting and Editing Your Notes

Applying Styles
Using the Page Setup Group
Using Snap to Grid
About Using Embedded Visio Diagrams Resizing and Moving Objects Arranging and Rotating Objects Module Four: Review Questions

Module Five: Working with Audio and Video

Recording Audio
Recording Video
Working with Playback Settings Module Five: Review Questions

Module Six: Working with Tables

Selecting Rows and Columns Inserting Rows and Columns Deleting Rows and Columns Using Borders and Shading Adjusting Table Alignment Sorting Table Contents Module Six: Review Questions

Module Five: Working with Equations and Excel Spreadsheets

Working with Equations
Understand the Calculator Capabilities Inserting an Excel Spreadsheet
Converting a Table to an Excel Spreadsheet Converting Ink to Math
Module Five: Review Questions

Module Eight: Researching a Topic

Using the Research Task Pane
Make Text in Pictures Searchable
Starting and Finishing a Linked Notes Session View or Remove Linked Notes
Disable and Re-enable Linked Notes
Module Eight: Review Questions

Module Nine: Advanced Review Tasks

Translating Words or Phrases
Using the Mini Translator
Setting Translation and Proofing Languages Password Protecting a Section
Module Nine: Review Questions

Module Ten: Collaborating

Sharing Notebooks with Other Computers and Other Authors Understanding Notebook Synchronization Status
Find By Author
Taking Meeting Notes

Module Ten: Review Questions

Module Eleven: Advanced Sharing Options

Exporting Your Notes
Sending Your Notes
Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise Parking Lot
Action Plans and Evaluations

Outlook 2013 Advanced

Your participants will learn how to use the advanced features of Outlook 2013. This workshop is designed to provide a solid understanding of Outlook 2013. Participants will be shown a practical way of learning with a hands-on and customizable approach. They will get a chance to experience some of the new features that are offered in Outlook 2013.

Outlook 2013 helps you manage your busy life through its calendar and social connectors. With Outlook 2013 you are given a sleeker more efficient way to organize and communicate. With a new and improved user interface and a more powerful search tool your participants will increase their productivity, as they will be able to manage their information more efficiently!

Outline

Module One: Getting Started

Housekeeping Items Parking Lot Pre-Assignment Review Workshop Objectives Action Plans

Module Two: Working with Messages

Formatting Fonts and Paragraphs Using Styles and Themes
Adding Pictures or Screenshots Using Spell Check

Using the Other Review Options (Research, thesaurus, Word Count) Module Two: Review Questions

Module Three: Customizing Your Profile

Setting up a Signature
Changing Stationery Options
Enabling or Disabling Automatic Spell Check Using Categories
Module Three: Review Questions

Module Four: Advanced E-Mail Tasks

Adding Voting Buttons
Setting the Priority
Using Tracking Options Delaying Delivery
Directing Replies
Module Four: Review Questions

Module Five: Managing Junk Mail

About the Junk Mail Filter
Enabling Junk Mail Filtering
Enabling the Phishing Filter
Modifying Safe and Blocked Senders Lists Marking a Message as Junk or Not Junk Module Five: Review Questions

Module Six: Advanced Calendar Tasks

Creating a Recurring Appointment Creating a Meeting Request Tracking Meeting Responses Color-Coding Appointments Changing Calendar Options

About Calendar Groups Module Six: Review Questions

Module Seven: Doing More with Tasks

Create a Recurring Task Assigning a Task
Using the Details Tab
Setting Task Options
Module Seven: Review Questions

Module Eight: Using Notes

Opening the Notes Folder Create a Note
Editing a Note
Color-Coding a Note
Changing Note Views
Module Eight: Review Questions

Module Nine: Viewing RSS Feeds

Adding an RSS Feed
Modifying or Deleting RSS Feeds Viewing a Feed
Working with Feed Items Module Nine: Review Questions

Module Ten: Managing Outlook Data (I)

Cleaning Up Folders
Using Mailbox Cleanup Understanding Data Configurations Archiving Data
Module Ten: Review Questions

Module Eleven: Managing Outlook Data (II)

Backing Up Data
Adding a New PST File
Closing a PST File
Opening a PST File
Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise Parking Lot
Action Plans and Evaluations Appendix
Pre-Assignment

PowerPoint 2013 Advanced

Your participants will learn how to use the improved features of PowerPoint 2013. This workshop is designed to get into the advanced features of PowerPoint 2013. Participants will be shown a practical way of learning with a hands-on and customizable approach. They will get a chance to experience some of the new features that are offered in PowerPoint 2013.

PowerPoint 2013 is the world’s premier presentation software. With PowerPoint 2013 you are provided a new landing screen that makes launching and creating documents easier than previous versions. There is also an improved Presentation View with gives your presentations that extra focus. PowerPoint 2013 also has an improved user interface with an array of powerful tools to help you share your presentations through Skydrive!

Outline

Module One: Getting Started

Housekeeping Items Parking Lot Pre-Assignment Review Workshop Objectives Action Plans

Module Two: Working with Shapes

Inserting a Shape
Using the Drawing Tools Tab Using Shape Fill and Outline Using Shape Effects
Using Smart Guides
Module Two: Review Questions

Module Three: Working with Text Boxes and Pictures

Inserting a Text Box
Resizing, Moving, and Deleting an Object Using Picture Styles
Using Text Fill and Outline
Using the Color-Matching Eyedropper Adding Text Effects
Module Three: Review Questions

Module Four: Adding SmartArt

Inserting SmartArt
Using the SmartArt Tools Tabs
Adding Text to SmartArt
Resizing, Moving, and Deleting SmartArt Module Four: Review Questions

Module Five: Advanced Drawing Tasks

Using Alignment Guides Rotating and Flipping Objects Aligning and Distributing Objects Ordering Objects
Grouping Objects
Module Five: Review Questions

Module Six: Adding Tables

Inserting a Table
Adding Text to a Table
Using the Table Tools Tabs Modifying Rows and Columns Formatting a Table
Module Six: Review Questions

Module Seven: Inserting Audio and Video

Adding a Sound Clip
Recording Audio
Adding a Video Clip
Module Seven: Review Questions

Module Eight: PowerPoint’s Research Tools

Checking Spelling
Using the Research Task Pane Using the Thesaurus
Using Translation ScreenTips Setting the Language
Module Eight: Review Questions

Module Nine: Preparing to Use Presenter View

About Presenter View Adding Notes to Slides Viewing the Notes Page Printing Notes

Creating Handouts (export) Module Nine: Review Questions

Module Ten: Using Slide Masters

Switching to Slide Master View Using the Slide Master Tab Creating a Slide Master Applying a Slide Master Editing a Slide Master

Using Master Guides
Module Ten: Review Questions

Module Eleven: Advanced Presentation Tasks

Inviting People
Presenting Online
Creating a Custom Show
Recording Your Show as a Video Packaging Your Presentation for CD Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise Parking Lot
Action Plans and Evaluations

Publisher 2013 Advanced

Your participants will learn how to use the in-depth features of Publisher 2013. This workshop is designed to get into the more advanced features of Publisher 2013. Participants will be shown a practical way of learning with a hands-on and customizable approach. They will get a chance to experience some of the new features that are offered in Publisher 2013.

Publisher 2013 gives you the ability to create any type of publication. With Publisher 2013 you are provided a new landing screen that makes launching and creating documents easier than previous versions. A new set of templates along with improved graphic editing tools is included with Publisher 2013. Users are also given an improved interface with an array of powerful tools to help you share your publications through Skydrive!

Outline

Module One: Getting Started

Housekeeping Items Parking Lot Pre-Assignment Review Workshop Objectives Action Plans

Module Two: Advanced Content Options

Importing Text from a File Embedding an Object
Creating Word Art
Working with Building Blocks Module Two: Review Questions

Module Three: Working with Text

Wrapping Text Around a Picture Adding Text to a Shape
Working with Word Art Styles Working with Typography Module Three: Review Questions

Module Four: Working with Pictures

Finding the Picture Resolution Cropping Pictures
Inserting Pictures into a Shape Making a Picture Transparent
Using the Format Picture Dialog Box Resetting a Picture

Module Four: Review Questions

Module Five: Working with Shapes

Changing a Shape
Editing a Shape
Adding Shape Effects
Working with Shape Measurements Using the Format Shape Dialog Box Module Five: Review Questions

Module Six: Working with Graphics and Objects

Layering Objects
Grouping Objects
Rotating and Flipping Objects
Snapping Objects to Other Objects on the Page Using the Graphics Manager Task Pane
Using the Building Blocks Library
Module Six: Review Questions

Module Seven: Working with Page Layout

Changing the Template
Using the Page Setup Dialog Box Using a Built-in Ruler Guide Adding a Ruler Guide
Using Grid and Baseline Guides Module Seven: Review Questions

Module Eight: Using Master Pages

Creating a Master Page Applying a Master Page
Editing a Master Page
Managing Master Pages
Closing the Master Page View Module Eight: Review Questions

Module Nine: Working with Merges

Creating a Data Source for a Merge Using the Email or Mail Merge Wizard Working with Recipients
Creating Labels with Postal Code Bars Tracking Effectiveness

Module Nine: Review Questions

Module Ten: Creating a Catalog

Inserting Catalog Pages Creating a Product list Choosing a Catalog Layout Finishing Your Catalog Merge Module Ten: Review Questions

Module Eleven: Working with Publication Information

Using the Design Checker
Managing Embedded Fonts
Setting Publisher Options
Customizing the Ribbon or the Quick Access Toolbar Reducing Publication File Size by Compressing Pictures Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise Parking Lot
Action Plans and Evaluations

Word 2013 Advanced

Your participants will learn how to use the advanced features of Word 2013. This workshop is designed to get into the more in-depth features of Word 2013. Participants will be shown a practical way of learning with a hands-on and customizable approach. They will get a chance to experience some of the new features that are offered in Word 2013.

Word 2013 now has the ability to edit PDF files without the need to convert. With Word 2013 you are also provided a new landing screen which makes launching and creating documents easier than ever. A new set of templates and design tools are included with Word 2013. Users are also given an improved interface with an array of powerful tools to help you share your documents through Skydrive!

Outline:

Module One: Getting Started

Housekeeping Items The Parking Lot Workshop Objectives Action Plans

Module Two: Working with the Word Window

Using Zoom
An Overview of Word’s views
Arranging Windows
Splitting a Document
Using the Navigation Pane
Customizing the Ribbon and the Quick Access Toolbar Module Two: Review Questions

Module Three: Advanced Editing and Formatting Tasks

Using the Office Clipboard and the Selection Pane Using the Phonetic Guide
Using Character Borders and Shading
Enclosing characters

Using Text Effects
Showing Formatting Marks Module Three: Review Questions

Module Four: Working with Illustrations

Inserting a Picture from a File Inserting an Online Picture Adding WordArt
Drawing Shapes

Inserting a Screenshot
Moving or Deleting a Picture Module Four: Review Questions

Module Five: Formatting Pictures

Using the Picture tools Tab
Adding a Border
Removing a Picture’s Background Adding Artistic Effects
Positioning Pictures and Wrapping Text Module Five: Review Questions

Module Six: Adding SmartArt

Inserting SmartArt
Adding Text to SmartArt
Using the SmartArt Tools Tabs Moving and Deleting SmartArt Using SmartArt Layout Options Module Six: Review Questions

Module Seven: Adding Tables

Inserting a Table
Adding Text to a Table
About the Table Tools Tabs Altering Rows and Columns Applying a Table Style
Module Seven: Review Questions

Module Eight: Inserting Special Objects

Adding a Cover Page
Inserting a Text Box
Inserting an App
Inserting Online Media Inserting a Database
Module Eight: Review Questions

Module Nine: Working with Document References

Inserting a Caption
Adding a Table of Contents
Adding Footnotes, Endnotes, and Citations Managing Sources
Inserting a Bibliography
Creating an Index
Module Nine: Review Questions

Module Ten: Reviewing Your Document

Using Define, Thesaurus and Word Count
Using Translation Tools
Setting Proofing Language and Language Preferences Module Ten: Review Questions

Module Eleven: Using Comments and Tracking

Adding a Comment
Reviewing Comments
Tracking Changes
Reviewing Changes
Comparing Documents Combining Documents
Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise Parking Lot
Action Plans and Evaluations

Office 2013 Expert Word 2013 Expert

Your participants will learn how to use the advanced features of Word 2013. This workshop is designed to get into the more in-depth features of Word 2013. Participants will be shown a practical way of learning with a hands-on and customizable approach. They will get a chance to experience some of the new features that are offered in Word 2013.

Word 2013 now has the ability to edit PDF files without the need to convert. With Word 2013 you are also provided a new landing screen which makes launching and creating documents easier than ever. A new set of templates and design tools are included with Word 2013. Users are also given an improved interface with an array of powerful tools to help you share your documents through Skydrive!

Outline:

Module One: Getting Started

Housekeeping Items The Parking Lot Workshop Objectives Action Plans

Module Two: Working with Document Information and Word Customization

Setting Word Options Protecting a Document Checking for Issues
Managing Versions
Working with Properties Module Two: Review Questions

Module Three: Working with Reusable Content

Saving Selection as Autotext Inserting a Quick Part
Creating Customized Building Blocks Editing a Building Block

Module Three: Review Questions

Module Four: Working with Templates

About Templates
Modifying an Existing Template
Creating a New Template
Applying a Template to an Existing Document Managing Template Styles (the organizer) Module Four: Review Questions

Module Five: Working with Sections and Linked Content

Using Sections
Customizing Page Numbers in Sections
Using Multiple Page Formats in a Document
Using Different Headers and Footers in a Document Linking and Breaking Links for Text Boxes
Module Five: Review Questions

Module Six: Managing Versions and Tracking Documents

Merging Different Versions of a Document Tracking Comments in a Combined Document Reviewing Comments in a Combined Document Module Six: Review Questions

Module Seven: Using Cross References

Types of Cross References
Inserting a Bookmark
Inserting a Cross Reference
Updating a Cross Reference
Formatting Cross References using Fields Module Seven: Review Questions

Module Eight: Working with Mail Merges

Creating a Mail Merge
Sending Personalized Email Messages to Multiple Recipients
Using Other Data Sources for Mail Merge (Access, Outlook, Excel, Word tables) Creating Labels
Creating Envelope and Label Forms
Module Eight: Review Questions

Module Nine: Working with Master Documents

Creating a Master Document
Inserting a Subdocument
Creating a Subdocument
Expanding and Collapsing Subdocuments Unlinking a Subdocument

Merging and Splitting Subdocuments Locking a Master Document
Module Nine: Review Questions

Module Ten: Working with Macros

Recording a Macro
Running a Macro
Applying Macro Security
Assigning a Macro to a Command Button or a shortcut key Module Ten: Review Questions

Module Eleven: Working with Forms

Displaying the Developer Tab Using Form Controls
Locking and Unlocking a Form Adding and Removing Fields Linking a Form to a Database Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise
Review of the Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Office 365 Essentials Excel 365 Essentials

Welcome to the Office 365 Excel Essentials workshop. With Office 365, you can access your spreadsheets anywhere, and make some basic changes without using a computer where your desktop Office applications are installed. In the Office 365 Excel web app, you can collaborate on a spreadsheet with anyone, no matter what version of Excel they have, and your changes are automatically saved.

The Office 365 experience is designed to render your documents to look exactly like they would when printed, from nearly anywhere in the world. This tool provides its users the freedom to work from anywhere.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Welcome to Office 365 Excel

The Home Page
The Team Site
Shared Documents
Uploading a Spreadsheet Module Two: Review Questions

Module Three: Worksheets and Workbooks

Opening a Spreadsheet
Overview of the Reading View Understanding Worksheets vs. Workbooks Downloading and Reloading
Closing Spreadsheets
Module Three: Review Questions

Module Four: Working with Excel Files

Using the Find Command Saving a Copy
Editing in Browser
The Excel Web App Interface Opening in Excel

Module Four: Review Questions

Module Five: Editing in the Browser (I)

About Saving and Save As A New File and AutoSaving Entering Data
Editing Data

Using the Wrap Command Module Five: Review Questions

Module Six: Editing in the Browser (II)

Using Undo and Redo
Adding Rows and Columns Deleting Cells
Using Timesaving Shortcuts Module Six: Review Questions

Module Seven: Building Formulas

The Math Basics of Excel Building a Formula
Editing a Formula
Copying a Formula
Relative vs. Absolute References Module Seven: Review Questions

Module Eight: Understanding Functions

Formulas vs. Functions
Using the SUM Function
Using Other Basic Excel Functions Using AutoComplete
Module Eight: Review Questions

Module Nine: Working with Data

Sorting Data
Filtering Data
About Collaborating
About Refreshing External Data Module Nine: Review Questions

Module Ten: Formatting Your Data

Changing the Appearance of Text Changing the Appearance of Numbers Setting Alignment Options
Adding Borders

Adding Fill Color
Module Ten: Review Questions

Module Eleven: The Insert Tools

Inserting Tables
Inserting Charts
Working with Charts
Inserting Links
Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise
Review of the Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Lync 365 Essentials

Lync Online is Microsoft’s premiere online communications software with instant messaging, audio and video calls, and online meetings that include sharing your desktop. Your participants will be well versed in this great tool that will provide a great benefit in their Office 365 usage.

Office 365 Lync Essentials will get your participants started on their path to using Lync for all your communications. We’ll first look at how to sign into Lync Online. Then your participants will learn how to set up Lync to start automatically and configuring their Lync profiles.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Welcome to Office 365

Signing In to Lync
Setting Up Lync to Start Automatically Adding a Picture
Signing Out
Module Two: Review Questions

Module Three: Working with Contacts

Searching for People
Building Your Contacts List Adding a Contact
Tagging or Pinning a Contact Creating Groups
Organizing Contacts
Module Three: Review Questions

Module Four: Working with Presence Indicators

About Presence Indicators Changing Status
Hiding Activity Feed
Changing or Hiding Location Understanding Privacy Relationships Working with Privacy Settings Module Four: Review Questions

Module Five: Working with Instant Messaging

Sending an Instant Message
Sending an Instant Message to a Group
Accepting or Ignoring an Instant Message
Inviting Another Contact to an Instant Message Conversation Using Emoticons and Formatting
Ending a Conversation
Module Five: Review Questions

Module Six: Working with Online Meetings

Starting an Unscheduled Meeting Scheduling a Meeting
Changing Access and Presenter Options Joining a Meeting

Organizer and Presenter Best Practices Module Six: Review Questions

Module Seven: Working with the Lync Online Web Scheduler

Scheduling a Meeting or Call Sending Invitations Customizing Roles
Joining a Meeting

Viewing or Editing Meetings Deleting a Meeting
Module Seven: Review Questions

Module Eight: Working with PowerPoint Presentations

Working with PowerPoint Presentations Controlling Permissions
Changing Presenters
Making Annotations

Saving a Copy of the Annotated File Module Eight: Review Questions

Module Nine: Sharing Your Desktop or a Program

Sharing Your Desktop
Choosing an Open Program to Share Stopping Sharing
Changing Control When Sharing Stopping People from Sharing Requesting Control
Module Nine: Review Questions

Module Ten: Collaborating on a Whiteboard

Opening a Whiteboard
Working with Whiteboard Content Viewing a Whiteboard Privately Closing a Whiteboard
Module Ten: Review Questions

Module Eleven: Using Audio and Video

Making a Lync Call
Making a Video Call
Answering or Declining a Call
Setting Your Ringtones and Sound Options Making a Conference Call
Setting Options
Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise
Review of the Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

OneNote 365 Essentials

Through this workshop your participants will be introduced to the way OneNote is integrated into the 365 Web Apps by discussing the Home Page, the Team Site, and the Shared Documents list. We’ll also explain how to upload one of your existing OneNote notebooks to the site.

With Office 365 OneNote, you can access your OneNote notebooks from the same website where they are stored, and make some basic changes without using a computer where your desktop Office applications are installed.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Welcome to Office 365 Web Apps

The Home Page
The Team Site
Shared Documents
Uploading a Document
Module Two: Review Questions

Module Three: Working with Notebooks

Understanding Your Notebook Opening a Notebook
The OneNote Web App Interface Creating a New Notebook

About Saving
Closing Notebooks
Module Three: Review Questions

Module Four: Working with Pages and Sections

About the Pages Pane Adding Pages
Creating Sub-Pages Moving and Deleting Pages Adding Sections

Module Four: Review Questions

Module Five: Editing in the Browser

Using the Pop Out Minimizing the Ribbon Opening in OneNote Typing Text

Module Five: Review Questions

Module Six: Basic Editing Tasks

Selecting and Editing Text with the Mouse or Keyboard Using Cut, Copy and Paste
Using Undo and Redo
Checking Your Spelling

Setting the Proofing Language Module Six: Review Questions

Module Seven: Formatting Your Text

Understanding Levels of Formatting Changing Font Face and Size Changing the Font Color
Adding Font Enhancements Highlighting Text

Clearing Formatting
Module Seven: Review Questions

Module Eight: Paragraph Formatting, Styles and Tags

Setting the Alignment or Text Direction Using Indents and Tabs
Adding Bullets and Numbering Applying Styles

Tagging Notes
Module Eight: Review Questions

Module Nine: The Insert Tools (I)

Inserting a Table
Adding Text to a Table Working with Tables
Inserting Links
Module Nine: Review Questions

Module Ten: The Insert Tools (II)

Inserting Pictures
Inserting Clip Art
Working with Pictures
Module Ten: Review Questions

Module Eleven: The View Tab

Overview of the Reading View Show Authors
Page Versions
Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise Review of the Parking Lot Lessons Learned
Action Plans and Evaluations

Outlook 365 Essentials

Welcome to the Office 365 Outlook Essentials workshop. With Office 365, you can access your inbox anywhere from any computer that has an internet connection and a web browser. In the Office 365 Outlook web app, you can collaborate and keep up to date with built in tools that Outlook is known for.

The Office 365 experience is designed to render your documents and emails to look exactly like they would when printed, from nearly anywhere in the world. This tool provides its users the freedom to work from anywhere.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Welcome to Office 365 Outlook

The Home Page
Opening Outlook
Understanding the Outlook 365 Interface About IM
Selecting a Theme
Closing Outlook
Module Two: Review Questions

Module Three: Working with Your Inbox (I)

Viewing Your Inbox
Filtering Messages
Checking Messages
Marking an Item Read or Unread
Replying to or Forwarding a Message from the Inbox Ignoring Conversations

Module Three: Review Questions

Module Four: Working with Your Inbox (II)

Changing the View
Creating Folders
Moving Messages to Folders
Renaming, Moving and Deleting Folders Adding to Favorites
About Junk Mail
Module Four: Review Questions

Module Five: Creating a New E-Mail

Creating an E-mail
About the Address Book Finishing Your Message Attaching a File
Inserting a Picture
Sending the Message
Module Five: Review Questions

Module Six: Managing E-Mail Messages

The Received Message Window Opening a Chat Message Viewing Message Details Printing a Message

Deleting an E-Mail
Module Six: Review Questions

Module Seven: Using Outlook’s Organizational Tools

Flagging an Item for Follow-up Using Categories
Performing a Simple Search Performing a Complex Search Creating a Basic Rule

Creating an Advanced Rule Module Seven: Review Questions

Module Eight: Outlook Options

About the Outlook Options Setting Automatic Replies Creating a Group
Creating a Signature
Module Eight: Review Questions

Module Nine: An Introduction to the Calendar

Getting Started
Creating an Appointment
Changing Your Calendar View
Creating a Meeting Request and Using the Scheduling Assistant Editing an Appointment
Managing Reminders
Sharing Your Calendar
Module Nine: Review Questions

Module Ten: An Introduction to Contacts

Getting Started
About Importing Contacts Creating a New Contact Working with Contacts Creating a New Group Working with Groups
Module Ten: Review Questions

Module Eleven: An Introduction to Tasks

Getting Started
Creating a New Task
Setting a Date and Reminder Setting a Repeating Task Forwarding a Task
Updating a Task Status
Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise
Review of the Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

PowerPoint 365 Essentials

While the Office 365 Web Apps are available to anyone who has either a Windows Skydrive account or a SharePoint site, in this course, we will assume that your organization is using the SharePoint site. In this module, we’ll introduce the web apps by discussing the Home Page, the Team Site, and the Shared Documents list. We’ll also explain how to upload one of your existing PowerPoint presentations to the site.

With Office 365 PowerPoint, you (or any of your viewers) can access your presentations anywhere. You can even make a few basic changes right on the same website where you presentation is located.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Welcome to Office 365 PowerPoint

The Home Page
The Team Site
Shared Documents
Uploading a Document
Module Two: Review Questions

Module Three: Viewing Web App Presentations (I)

Opening a Presentation Overview of the Reading View Paging Through Documents Notes
Closing Presentations
Module Three: Review Questions

Module Four: Viewing Web App Presentations (II)

Using the Pop Out
Using the Outline View
Editing in Browser
Opening in PowerPoint
Printing From the Reading View Module Four: Review Questions

Module Five: Working with Slides

A New File
Adding Slides
The PowerPoint Web App Interface Using the Slide Organizer
Hiding Slides
Module Five: Review Questions

Module Six: Editing in the Browser

About Saving
Typing Text
Selecting and Editing Text with the Mouse or Keyboard Using Cut, Copy, and Paste
Using Undo and Redo
Module Six: Review Questions

Module Seven: Formatting Text

Understanding Levels of Formatting Changing Font Face and Size Changing the Font Color
Adding Font Enhancements

Module Seven: Review Questions

Module Eight: Formatting Paragraphs

Adding Bullets and Numbering Changing Alignment
Using Indents and Tabs
Text Direction

Model Eight: Review Questions

Module Nine: The Insert Tools

Inserting Pictures Inserting Clip Art Working with Pictures Using Smart Art Inserting Links

Model Nine: Review Questions

Module Ten: The Finishing Touches

Working with Notes
Printing from the Editing View Accessing the Reading View
Starting a Slide Show in the Browser Module Ten: Review Questions

Module Eleven: Broadcasting Presentations on the Web

About Broadcasting Presentations on the Web Preparing Your Presentation for Broadcast Broadcasting Your Presentation
Viewing a Broadcast Presentation

Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise
Review of the Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

SharePoint 365 Essentials

In this workshop your participants will learn how to sign on to the Microsoft Office 365 portal, and see where their SharePoint content will be stored. They will learn about the home page of the portal, where to sign into the Team Site and the Office 365 web apps, including Outlook.

Through SharePoint Essentials your participants will take a look at the Team Site and how to navigate around and view the SharePoint site. SharePoint Online is the Office 365 answer to collaboration. SharePoint Online will let your participants manage documents and information in one place that customers and colleagues can access from virtually anywhere.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Basic SharePoint Concepts

The Home Page
The Team Site
About Permissions
Changing Site Theme
Module Two: Review Questions

Module Three: Working with My Site

View Your Profile
Update Your Profile
Follow Colleagues
Share Information
Follow Newsfeed and Status Updates Module Three: Review Questions

Module Four: Working with SharePoint Content

About Content Types
Adding an Item to a List Uploading a File to a Library Checking Items In and Out Tracking Versions
Module Four: Review Questions

Module Five: Working with Libraries

Types of Libraries
Viewing Library Items
Creating a New Document in Your Library Editing or Deleting a Library Item Understanding the Library Tools
Create a Library
Module Five: Review Questions

Module Six: Working with Lists

Types of Lists
The List Tool Bars
Viewing Items
Editing or Deleing a List Item Creating a New List
Module Six: Review Questions

Module Seven: Working with Other Types of Lists

Viewing and Adding Announcements Working with an Issues List
Adding a Link
Adding a Task

Searching List Items
Module Seven: Review Questions

Module Eight: Working with Calendars

Viewing and Navigating Calendars Adding a New Event
Managing Events
Connecting to Outlook

Creating a New Calendar Module Eight: Review Questions

Module Nine: Working with Sites and Pages

Editing a Page
Understanding Web Parts Editing and Deleting Web Parts Creating a Site
Module Nine: Review Questions

Module Ten: Working with Views

Sorting and Filtering Lists and Libraries Creating a Column
Creating a Private View
Selecting a View

Modifying a View
Module Ten: Review Questions

Module Eleven: Using Workflows

About Workflows
Types of Workflows
Add a Three-State Workflow to a List Start a Workflow
Monitor a Workflow
Review a Workflow
Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise
Review of the Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Word 365 Essentials

Welcome to the Office 365 Word Web App Essentials workshop. With Office 365, you can access your documents anywhere, and make some basic changes without using a computer where your desktop Office applications are installed.

With Office 365 Word your participants will learn how to edit, share, and publish Word files using the Office 365 interface. The Office 365 experience is designed to render your documents to look exactly like they would when printed, from nearly anywhere in the world. This tool provides its users the freedom to work from anywhere.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Welcome to Office 365 Web Apps

The Home Page
The Team Site
Shared Documents
Uploading a Document
Module Two: Review Questions

Module Three: Viewing Web App Documents (I)

Opening a Document
Overview of the Reading View Paging Through Documents Printing From the Reading View Finding Text in Your Document Closing Documents
Module Three: Review Questions

Module Four: Viewing Web App Documents (II)

Zooming in your Document Using the Pop Out
Editing in Browser
About Converting Documents Opening in Work

Module Four: Review Questions

Module Five: Editing in the Browser

A New File
Saving Files
The Word Web App Interface
Typing Text
Selecting Text with the Mouse or Keyboard Editing and Deleting Text
Module Five: Review Questions

Module Six: Basic Editing Tasks

Using Cut, Copy, and Paste Using Undo and Redo Checking Your Spelling Setting the Proofing Language Printing from the Editing View Accessing the Reading View Module Six: Review Questions

Module Seven: Font Formatting

Understanding Levels of Formatting Changing Font Face and Size Changing the Font Color
Adding Font Enhancements Highlighting Text

Module Seven: Review Questions

Module Eight: Formatting Paragraphs

Setting the Alignment
Using Indents and Tabs
Adding Bullets and Numbering Text Direction
Module Eight: Review Questions

Module Nine: Working with Styles

About Styles
Quick Styles versus the Style Gallery Applying a Style
Clearing Formatting
Module Nine: Review Questions

Module Ten: The Insert Tools (I)

Inserting a Table
Adding Text to a Table Inserting Links
Module Ten: Review Questions

Module Eleven: The Insert Tools (II)

Inserting Pictures
Inserting Clip Art
Working with Pictures
Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise
Lessons Learned
Parking Lot
Completion of Action Plans and Evaluations

Office 2010 Essentials Access 2010 Essentials

Access is the world’s premier database software. You can use Access to create and edit databases — just download a ready-made database template and start typing. It’s that easy. You can create a database of contacts, expenses, household and/or business inventory. In other words, if you have data, you can create a database of that data using Access. Microsoft’s newest version of Access uses the new ribbon interface, and offers significant improvement to its database capability.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Getting Started With Access

Common Database Terms
Opening Access
Understanding the Access New File Screen Creating a Blank Access Database
Creating a Blank Database from a Template

Module Three: Using the Access Interface

Understanding Security Warnings Interface Overview
Overview of the Ribbon Interface Working With the Backstage View Using the Navigation Pane

Module Four: Working with Database Objects

Viewing Database Objects Exporting an Object
Renaming an Object
Sorting and Filtering Your View Understanding Application Parts

Module Five: Creating Tables

Understanding Data Types
Creating a Blank Table in Datasheet View Understanding Lookup Columns
Creating a Blank Table using Design View Saving Your Table
Key Table Tools

Module Six: Working with Tables

Adding Information to a Table Editing Records
Deleting Records
Searching for Records

Module Seven: Creating Forms

Types of Controls
Creating a Form with the Wizard Creating a Form In Layout View Modifying Your Form in Design View Key Features on the Form Tools Tab Creating a Navigation Form

Module Eight: Working with Forms

Common Formatting Tasks Using Themes
Adding Controls
Moving Controls

Deleting Records

Module Nine: Creating Reports

Using The Report Wizard
Using Design View
Adding a Logo
Working with Controls
Key Features on the Report Tools Tab

Module Ten: Creating Queries

Types of Queries
Creating a Query with the Wizard Executing a Query
Viewing the Query
Key Features on the Query Tools Tab

Module Eleven: Managing Your Database

Using Alternate File Formats Printing an Object
Backing Up Your Database Emailing Database Objects

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Excel 2010 Essentials

Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information – and better information leads to better decision making!

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Opening and Closing Excel

Opening Excel Understanding the Interface Using Backstage View Understanding Worksheets Understanding Workbooks

Module Three: Your First Worksheet

Entering Data
Editing Data
Using the Wrap Command Adding Rows and Columns Checking Your Spelling

Module Four: Working with Excel Files

Saving Files
Publishing Files to PDF Sending Files via E-Mail Closing Files
Opening Files

Module Five: Viewing Excel Data

An Overview of Excel’s Views Switching Views
Creating Custom Views Using Zoom

Switching Between Open Files

Module Six: Printing Excel Data

An Overview of the Page Layout Tab Setting Up Your Page
Using Print Preview
Printing Data

Module Seven: Building Formulas

The Math Basics of Excel Building a Formula
Editing a Formula
Copying a Formula
Relative vs. Absolute References

Module Eight: Using Excel Functions

Formulas vs. Functions
Using the SUM Function
Using Other Basic Excel Functions Understanding the Formulas Tab
Using the Status Bar to Perform Calculations Understanding the New Function Names

Module Nine: Using Time Saving Tools

Using AutoFill
Using AutoComplete Sorting Data Filtering Data Adding Sparklines

Module Ten: Formatting Your Data

Changing the Appearance of Text Changing the Appearance of Numbers Setting Alignment Options
Using Merge

Removing Formatting

Module Eleven: Advanced Formatting Tools

Adding Borders
Adding Fill Color
Using Cell Styles
Using Conditional Formatting Changing the Theme

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

 

InfoPath 2010 Essentials

In this workshop, you will learn how to create, manage, and fill out interactive forms. Microsoft InfoPath 2010 has new great features, such as the Office Fluent UI, and the ability to customize SharePoint list forms in just one click. Are you ready to take your organization to the next level with Microsoft InfoPath 2010?

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Opening and Closing InfoPath

Opening InfoPath
Using the Available Form Templates Window Exploring the InfoPath’s Interface
An XML Primer
Closing InfoPath

Module Three: Using the InfoPath Filler 2010

Launching Microsoft InfoPath Filler 2010 Entering Data
Checking Your Spelling
Printing the Form

Saving the Form

Module Four: Designing a Form Framework

Creating a Blank Form
Adding a Table
Adding and Removing Rows or Columns Merging and Splitting Cells
Formatting Tables
Changing Table Properties

Module Five: Adding Labels

Adding Labels
Changing the Font Face and Size Changing the Font Color
Adding Effects
Using the Font Task Pane Aligning Text

Module Six: Adding Controls

Adding a Standard Control
Adding Repeating and Optional Controls Adding File Controls
Adding Picture Controls
Advanced Types of Controls

Module Seven: Formatting Controls

Changing the Visual Properties of a Control Using the Control Properties Dialog
Adding Data Validation Rules
Applying Conditional Formatting

Running the Logic (Rule) Inspector

Module Eight: Working with Data Sources

Viewing Data Source Information Managing Fields and Groups Adding a Data Connection Manually Binding Controls

Module Nine: Creating a View

Creating a Custom View Creating a Print View Setting a View as Default Deleting Views

Module Ten: Finishing the Form

Changing the Color Scheme Checking Your Spelling Using the Design Checker Protecting Your Form Previewing the Form

Module Eleven: Distributing Your Form

Understanding Saving vs. Publishing Using the Publishing Wizard
Printing the Form

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

OneNote 2010 Essentials

OneNote is a program that helps you collect notes about anything. You can store all of your notes – in a variety of formats – in one place. Then you can organize and share your notes. OneNote 2010 provides all of these features and can make your everyday business a lot easier.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Opening and Closing OneNote

Opening OneNote Understanding the Interface Using the Backstage View About the OneNote Icon Docking OneNote
Closing OneNote

Module Three: Working with Notebooks

Understanding Your Notebook Creating a New Notebook Saving Notebooks
Searching Notebooks

Closing Notebooks Opening Notebooks

Module Four: Working with Pages and Sections

Adding Pages
Adding Sub-Pages
Moving, Renaming, and Deleting Pages Using the Templates Pane
Adding Sections
Adding Section Groups
Working with Sections and Section Groups

Module Five: Your First Notebook

Typing Text
Handwriting Text
Using Copy and Paste Adding Extra Writing Space Using the Formatting Toolbar Applying Styles

Module Six: Adding Objects to Your Notebook

Creating Lists
Creating Tables
Inserting Pictures Inserting Screen Clippings Researching in OneNote

Module Seven: Basic Editing Tasks

Using the Page Setup Group Resizing Objects
Moving Objects
Using Undo and Redo Checking Your Spelling

Module Eight: Advanced OneNote Objects

Using the Calculator
Using OneNote with Outlook Tasks and Meetings Inserting Audio
Inserting Video
Attaching Files

Module Nine: Drawing in OneNote

Drawing Shapes Selecting Shapes Formatting Shapes Rotating Shapes Using the Eraser

Module Ten: Managing Notes

Tagging Notes
Using the Unfiled Section Using History
Linking Like a Wiki

Module Eleven: Adding the Finishing Touches

Time Stamping Items
Using OneNote Views
Password Protecting Your Notebook Using OneNote Backups
E-Mailing Your Notes
Printing Your Notes

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Outlook 2010 Essentials

Outlook is a powerful e-mail application. However, it does much more than that to help you stay organized. With contacts, calendars, and tasks, Outlook can help you manage every aspect of your life.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Opening and Closing Outlook

Opening Outlook Understanding the Interface Using Backstage View Setting up an E-mail Account Viewing Your Inbox
Closing Outlook

Module Three: Working with E-mail

Sending and Receiving Mail
Viewing an E-mail
Replying To or Forwarding an E-mail Deleting an E-mail
Ignoring E-mail
Using Quick Steps

Module Four: Creating a New E-mail

Creating an E-mail Addressing an E-mail Creating the Body Attaching a File Sending the Message

Module Five: Managing E-mail

Marking an Item as Read or Unread Printing a Message
Creating Folders
Moving Messages to Folders
Renaming, Moving, and Deleting Folders

Module Six: Managing Junk Mail

About the Junk Mail Filter
Enabling Junk Mail Filtering
Enabling the Phishing Filter
Modifying Safe and Blocked Senders Lists Marking a Message as Junk or Not Junk

Module Seven: Outlook’s Organization Tools

Creating a Basic Rule
Creating an Advanced Rule Using Categories
Flagging an Item for Follow-Up Viewing Favorite Folders

Module Eight: Searching for Items

Understanding Search Folders Setting Up and Using Search Folders Using Instant Search
Using Advanced Search
Using Contact Search

Module Nine: An Introduction to the Calendar

Getting Started
Creating an Appointment Changing Your Calendar View Editing an Appointment Managing Reminders

Module Ten: An Introduction to Tasks

Getting Started Creating a New Task Editing a Task Updating Task Status Basic Task Views

Module Eleven: An Introduction to Contacts

Getting Started Creating a New Contact Editing a Contact Organizing Contacts Basic Contact Views

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

PowerPoint 2010 Essentials

PowerPoint is a powerful presentation for the presentation of visual and graphical items. You can do everything from creating simple handouts to developing an animated presentation with audio.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Opening and Closing PowerPoint

Opening PowerPoint Understanding the Interface Using Backstage View Creating a Blank Presentation Closing PowerPoint

Module Three: Working with Presentations

Saving Files
Opening Files
Closing Files
Creating a Presentation from a Template Using the Recent List

Module Four: Your First Presentation

Adding Text to a Slide Adding Slides
Using a Content Placeholder Using the Slides Tab

Module Five: Working with Text

Using Cut, Copy, and Paste Using the Office Clipboard Using Undo and Redo Finding and Replacing Text

Module Six: Formatting Text

Changing Font Face and Size Changing the Font Color Changing Character Spacing Adding Font Enhancements Clearing Formatting

Using the Font Dialog

Module Seven: Formatting Paragraphs

Adding Bullets and Numbering Changing Alignment
Adjusting the Indent
Using Indents and Tabs Changing Line Spacing

Module Eight: Advanced Formatting Tasks

Using the Format Painter Changing Slide Layout
Changing Slide Design
Changing the Theme
Changing the Background Design

Module Nine: Customizing Slide Elements

Adding a Header or Footer Creating a Standard Animation Creating a Custom Animation Using the Animation Painter Adding a Slide Transition Setting Slide Advance Options

Module Ten: Setting Up Your Slide Show

Working with Sections
Using the Set Up Show Dialog Recording a Narration
Timing Your Show
Hiding Slides

Module Eleven: Showtime!

Our Top Five PowerPoint Tips Starting a Show
Navigating Through the Show Changing Your Pointer Switching to a Blank Screen

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Project 2010 Essentials

Project is a sophisticated project management software that can help project managers with planning, assigning resources, tracking progress, managing budgets, and analyzing workloads for projects.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Opening and Closing Project

Opening Project
Understanding the Interface Creating a Blank Project
Creating a Project from a Template Opening and Closing Files
Closing Project

Module Three: Your First Project

Creating a Basic Project Adding Tasks to Your Project Setting Constraints on Tasks

Module Four: Adding Tasks

Understanding Key Terms Viewing Task Information Sorting and Filtering Tasks Understanding Task Indicators

Module Five: Advanced Task Operations

Splitting Tasks
Linking and Unlinking Tasks Creating Summary and Sub Tasks Creating Recurring Tasks

Module Six: Adding Resources

Understanding Resources Adding Resources
Viewing Resource Information Assigning Resources to Tasks Leveling Resources

Module Seven: Other Ways to View Project Information

The Team Planner Important Task Views Important Resource Views Using the Tools Tabs Formatting the Timescale

Module Eight: Managing Your Project Status

Creating a Baseline
Updating Tasks
Updating the Project
About the Project Status Date

Module Nine: Updating and Tracking Your Progress

Viewing the Critical Path Using Change Highlighting Using the Task Inspector Pane

Module Ten: Creating Reports

Creating Basic Reports Creating a Visual Report Comparing Projects

Module Eleven: Adding the Finishing Touches

Checking Your Spelling Using the Page Setup Dialog Printing a Project
E-mailing a Project
Creating a PDF

Module Twelve: Wrapping Up

Words from the Wise Words from the Wise Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Publisher 2010 Essentials

Publisher is a desktop publishing tool and flexible and powerful authoring software. It goes well beyond what you can produce with word processing software like Word. This course will help you learn to produce high-quality publications for both personal and business use.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Opening and Closing Publisher

Opening Publisher
Creating a Blank Publication Understanding the Interface
Using Backstage View
Creating a Publication from a Template Closing Publisher

Module Three: Working with Publications

Saving Files
Opening Files
Using the Recent List Using the Pages Pane Closing Files

Module Four: Your First Publication

Setting Up Your Business Information Adding Text
Adding Building Blocks
Adding a New Page

Working with Pages

Module Five: Basic Editing Tasks

Using Cut, Copy, and Paste Using the Office Clipboard Using Undo and Redo Finding and Replacing Text

Module Six: Using the Page Design Tab

Choosing a Color Scheme Choosing a Font Scheme Choosing a Background Using the Template Group

Module Seven: Basic Font Formatting

Changing Font Face and Size Changing the Font Color Adding Font Enhancements Using the Font Dialog

Module Eight: Formatting Paragraphs

Changing Spacing
Setting the Alignment Indenting Text
Adding Bullets and Numbering Using the Paragraph Dialog Applying Styles

Module Nine: Working with Objects

Inserting Pictures and Shapes
Inserting Tables
Linking Text Boxes
Moving, Resizing, and Arranging Objects Formatting Objects

Module Ten: Formatting the Page

Creating Columns
Adding Page Numbers Understanding Master Pages Adding Headers or Footers

Module Eleven: Adding the Finishing Touches

Checking Your Spelling Previewing Your Publication Printing Your Publication E-Mailing Your Publication

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

SharePoint Designer 2010 Essentials

SharePoint Designer is a reincarnation of the previous Microsoft FrontPage product. In this workshop, you’ll learn how to create dynamic websites with custom development. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer.

With SharePoint Designer 2010 you are able to edit HTML, create, and modify webpages that run SharePoint Foundation and SharePoint Server. SharePoint Designer 2010 is a great tool and this Essentials course will provide your participants with a solid foundation to start building their SharePoint skill set.

Outline:

Module One: Getting Started

Housekeeping items
The Parking Lot
Workshop objectives
Action plans and evaluation forms

Module Two: Opening and Closing SharePoint Designer

About SharePoint Designer 2010 (permissions, a warning/about customization) Opening SharePoint Designer
Understanding the Interface
Using Backstage View

Closing SharePoint Designer Module Two: Review Questions

Module Three: Creating and Opening Sites

Opening a Site (open and recent list) Creating a New Blank Web Site Creating a Site from a Template Saving Sites

Closing a Site
Module Three: Review Questions

Module Four: Working with Sites

Understanding the Site Tab Understanding the Site Summary Page Creating New Items
Editing or Deleting a Site
Adding Users or Groups to Your Site Managing the Site
Module Four: Review Questions

Module Five: Working with Components (Site Pages, Assets, Lists, and Libraries)

Understanding the Context-Sensitive Component Tabs Understanding the Context-Sensitive Component Summary Pages Working with Lists and Libraries
Working with Site Pages
Working with Site Assets
Adding Content
Module Five: Review Questions

Module Six: Connecting to Data

Understanding the Data Sources Tab Understanding the Data Sources Summary Page Adding a Database as a Data Source
Copying and Modifying a Data Source
Deleting a Data Source Connection
Module Six: Review Questions

Module Seven: Using Content and Master Pages

Understanding Content Types
Creating, Editing, and Deleting Content Types
Adding Columns to a Content Type
About Master Pages and Content Placeholders Understanding the Master Pages Tab and Summary Page Editing Master Pages
Module Seven: Review Questions

Module Eight: Working with Workflows

About Workflows
Understanding the Workflow Tab and Summary Page Editing a Workflow
Copying and Modifying a Workflow
Deleting a Workflow
Changing Workflow Settings
Module Eight: Review Questions

Module Nine: Working with Templates

About Templates (why, what, what is saved, and what can you do) Saving a Site as a Template
Activating a Site Template in the Solution Gallery
Module Nine: Review Questions

Module Ten: Working with Data Views and Forms

Creating a Data View
Adding or Removing Columns Creating a Data Form
Editing a List Form
About Data View/Form Web Parts Customizing Data Views and Forms Module Ten: Review Questions

Module Eleven: Customizing and Managing SharePoint Designer

Customizing the Quick Access Toolbar or the Ribbon About Managing SharePoint Designer
Detaching Pages from the Site Definition
Disabling Master Pages

Understanding the All Files Option Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise
Review of the Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Visio 2010 Essentials

Visio is a drawing application that uses different shapes and stencils to help you draw different types of diagrams. You can use Visio to create simple flowcharts, complicated engineering plans, or even floor plans.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Opening and Closing Visio

Opening Visio Understanding the Interface Using Backstage View Creating a Blank Drawing Closing Visio

Module Three: Working with Files

Saving Files
Opening Files
Closing Files
Switching Between Files

Module Four: Setting Up Your Screen

Showing and Hiding Screen Elements Adding a Guide
Moving or Deleting a Guide Changing Ruler and Grid Settings

Module Five: Your First Drawing

Finding the Required Shape
Placing the Shape in the Drawing Adding Text to a Shape
Resizing, Moving, and Deleting Shapes Using the Tools Group

Module Six: Basic Editing Tasks

Using Cut, Copy, and Paste Duplicating Shapes
Using Undo and Redo Finding and Replacing Text Checking Your Spelling

Module Seven: Formatting Shapes

Changing the Outline Changing the Fill
Adding Shadows
Changing Line Types and Ends Modifying Corners

Module Eight: Formatting Text

Changing Font Face and Size Changing the Font Color Adding Effects
Using the Format Text Dialog

Module Nine: Formatting Blocks of Text

Setting the Alignment Changing the Indent Changing Paragraph Spacing Adding Bullets

Rotating Text

Module Ten: Formatting Your Drawing

Selecting Multiple Objects Using the Format Painter Applying a Theme
Using Backgrounds

Using Borders and Titles Changing Your Layout

Module Eleven: Adding the Finishing Touches!

Validating Your Drawing
Using the Page Setup Group Saving Your Drawing as a Picture Printing Your Drawing
E-mailing Your Drawing

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Word 2010 Essentials

Word is a powerful word processing application. However, it does much more than create simple documents. It includes several desktop publishing features to make your documents look great.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Opening and Closing Word

Opening Word Understanding the Interface Using Backstage View Creating a Blank Document Closing Word

Module Three: Working with Documents

Saving Files
Opening Files
Closing Files
Creating a Document from a Template Using the Recent List

Module Four: Your First Document

Typing Text
Selecting Text with the Mouse or Keyboard Dragging and Dropping Text
Starting a New Page

Module Five: Basic Editing Tasks

Using Cut, Copy, and Paste Using the Office Clipboard Using Undo and Redo Finding and Replacing Text Setting Paste Options Using the Selection Pane

Module Six: Basic Formatting Tasks

Understanding Levels of Formatting Changing Font Face and Size Changing the Font Color
Adding Font Enhancements

Adding a Visual Effect Clearing Formatting

Module Seven: Advanced Formatting Tasks

Highlighting Text Changing Case
Using the Format Painter Using the Font Dialog Setting Open Text Options

Module Eight: Formatting Paragraphs

Changing Spacing
Setting the Alignment
Adding Bullets and Numbering Adding Borders and Shading

Module Nine: Working with Styles

About Styles
Applying a Style
Changing the Style Set Changing the Theme Changing Theme Elements

Module Ten: Formatting the Page

Adding Headers and Footers Formatting Text as Columns Changing Page Orientation Changing the Page Color Adding a Page Border

Using the Page Setup Dialog

Module Eleven: Adding the Finishing Touches

Checking Your Spelling Previewing Your Document Printing Your Document E-Mailing Your Document

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Office 2010 Advanced Access 2010 Advanced

You can use advanced forms and tasks to do even more in Access than you have previously learned. For example, you can use Access to create mailing labels, work with SQL, and publish a Web database— among other things. By the time you finish this course, you will be able to navigate Access 2010 and create reports like a pro. Sit back, relax, and have fun. You are in for a thrilling ride!

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Advanced Table Tasks

Using the Quick Start Group
Using the Property Sheet
Adding, Moving and Removing Controls Formatting Controls
Setting the Primary Key
Using Table Macros

Module Three: Advanced Form Tasks

Creating a Sub Form Creating a Web Form Creating a Split Form Creating a Modal Dialog

Module Four: Advanced Reporting Tasks

Using Report Sections
Using Conditional Formatting Grouping & Sorting Data Adding Calculated Controls Creating Labels

Module Five: Understanding Relationships

Types of Relationships
Viewing Relationships
Editing Relationships
About Referential Integrity Establishing Referential Integrity

Module Six: Advanced Query Tasks

Sorting and Filtering a Query Adding Calculated Fields
Using the Expression Builder Module Seven: Working with SQL What is SQL?

Basic SQL Syntax

Module Eight: Linking Data

Linking to an Excel Spreadsheet Linking to an Access Database Linking to a SharePoint List

Module Nine: Importing Data

Importing From an Excel Spreadsheet Importing From an Access Database Importing from a SharePoint List

Module Ten: Exporting Data

Saving an Object as a PDF Exporting To an Excel Spreadsheet Exporting to a SharePoint List

Module Eleven: Advanced Database Tools

Using the Database Documenter Analyzing Table Performance Analyzing Database Performance Repairing a Database Compacting a Database

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Excel 2010 Advanced

Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information – and better information leads to better decision making!

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: SmartArt and Objects

Inserting SmartArt
Adding Text to the Diagram
Resizing and Moving the Diagram Resetting the Diagram
Adding Pictures from Your Computer Adding Clip Art
Adding Text Boxes
Drawing Shapes
About the Contextual Tabs

Module Three: Auditing

Tracing Precedent Cells
Tracing the Dependents of a Cell
Displaying Formulas Within the Sheet
Adding, Displaying, Editing, and Removing Comments

Module Four: Creating Charts

Inserting a Chart
Overview of the Chart Tools Tab Understanding the Parts of a Chart Changing the Chart Style
Resizing and Moving the Chart

Module Five: Creating Pivot Tables

Inserting a PivotTable
Choosing Fields and Grouping Data Overview of the Pivot Table Tools Tabs

Module Six: Working with PivotTables and PivotCharts

Changing the Data Displayed and Refreshing the PivotTable Applying a Style to Your Pivot Table
Creating a Pivot Chart from a Pivot Table
Creating a Pivot Chart from Data

Some Real-life Examples

Module Seven: Macros

Displaying the Developer Tab
Recording and Running Macros
Changing the Security Level
Customizing and Changing the Quick Access Toolbar

Module Eight: Solving Formula Errors

Using Named Ranges Understanding Formula Errors Using the Trace Errors Commands Using Error Checking
Evaluating Formulas

Module Nine: Using What If Analysis

Using Goal Seek
Using the Scenario Manager Using a One Input Data Table Using a Two Input Data Table

Module Ten: Managing Your Data

Transposing Data from Rows to Columns Using the Text to Columns Feature Checking for Duplicates
Creating Data Validation Rules Consolidating Data

Module Eleven: Grouping and Outlining Data

Grouping Data
Adding Subtotals
Outlining Data
Viewing Grouped and Outlined Data

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

InfoPath 2010 Advanced

InfoPath is a powerful solution for collecting data from users on a variety of platforms. Microsoft InfoPath 2010 has new great features, such as the Office Fluent UI, and the ability to customize SharePoint list forms in just one click. Are you ready to take your organization to the next level with Microsoft InfoPath 2010?

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Types of Controls

Insert Controls on a Form Template Understanding Controls and the Data Source Input Controls
Object Controls
Container Controls
Custom Controls
Remove a Control from a Form Template

Module Three: Repeating and Optional Controls

Using Repeat Tables
Using Repeating Sections Creating an Optional Section

Module Four: Control Tool Properties and Table Tools Tabs

Control Tool Properties Tabs
Using the Control Properties Dialog Box Table Tools Tab

Module Five: Actions

Creating an Action Based on User Input Using Buttons to Switch Views
Applying Conditional Formatting Calculating Fields

Validating Your Form Input Data

Module Six: Importing Form Designs

Importing Designs from Other Applications Importing Word Forms
Importing Excel Forms

Module Seven: Advanced Topics

Cascading List Box
Merging Forms
Adding Resource Files to Your Form Template

Module Eight: Understanding Code

How InfoPath uses XML Technologies InfoPath Form Events
Working with Data Connections Using an Add-In

The Developer Tab

Module Nine: Publishing Forms

Understanding Form Security
Setting Form Template Security Level Network Location
Hosting InfoPath Forms

Module Ten: SharePoint Integration

Form Libraries
Promoting Field Properties
Email Enabling Document Libraries SharePoint Workflow

Module Eleven: Publishing Forms for Use with SharePoint

Publishing To a SharePoint Form Library Publishing To a SharePoint Site as a Content Type Browser Capable Forms
Installable Form Template

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

OneNote 2010 Advanced

Have you ever wished that you could track appointments, take meeting notes, record research, and keep to-do items all in one place? Well, you can do all that and more with OneNote 2010! In this course, we’ll show you how, plus we’ll explore OneNote’s new ribbon-based interface.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Upgrading from OneNote 2007 or 2003?

What You Need to Know About the New File Format New Features in OneNote 2010

Module Three: Staying Organized

The Navigation Bar
Drag and Drop
View Recent Edits
Working with Page Versions

Module Four: Note Taking Tools

Hyperlinks
Translating Words or Phrases
Table Editing Tools
Understand the Calculator Capabilities Working with Equations

Module Five: Text and Page Formatting

Format Using the Mini Toolbar Select a Page Template
Select a Default Template Create a New Template

Module Six: Drawing and Handwriting Notes

The Drawing and Pen Tool Bars OneNote Basics on a Tablet PC Specifying Pen Mode
Convert Ink to Text

Module Seven: Office Integration

Attach Files to Your Notes
Insert Files as Printouts
Print to OneNote from Other Applications Send to Word and Other Formats

Module Eight: Researching a Topic

Side Note Window
Send Web Pages to OneNote The Research Task Pane
Make Text in Pictures Searchable

Module Nine: Linked Notes

Starting and Finishing a Linked Notes Session View or Remove Linked Notes
Disable and Re-enable Linked Notes

Module Ten: Collaborating

About Universal Access to Notebooks
Sharing Notebooks with Other Computers and Other Authors Understanding Notebook Synchronization Status
Find By Author

Module Eleven: Other Tools

Password Protection Audio and Video Options Search Tools

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Outlook 2010 Advanced

In this workshop, we’ll cover some of the more advanced tasks in Outlook 2010, like customizing your Outlook interface and your profile. You’ll learn how to use Word elements in your E-mails. This course explains some of the advanced e-mail, calendar, and task commands, as well as the Notes feature. You’ll also learn about RSS feeds and how to manage and protect your Outlook data.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Customizing Outlook

Customizing the Navigation Pane Changing the Reading Pane Changing the To-Do Bar Resizing Panes

Module Three: Adding Word Elements to an E-mail

Common Formatting Tasks Adding SmartArt
Adding Pictures
Adding Tables

Module Four: Customizing Your Profile

Setting up a Signature
Changing Font Theme
Changing Stationery Options
Enabling or Disabling Automatic Spell Check

Module Five: Advanced E-Mail Tasks

Adding Voting Buttons
Setting the Priority
Changing the Message Format Adding a Follow-Up Flag

Module Six: Advanced Calendar Tasks

Creating a Recurring Appointment Creating a Meeting Request Tracking Meeting Responses Color-Coding Appointments Changing Calendar Options

About Calendar Groups

Module Seven: Doing More with Tasks

Create a Recurring Task Assigning a Task
Using the Details Tab Setting Task Options

Module Eight: Using Notes

Opening the Notes Folder Create a Note
Editing a Note Color-Coding a Note Changing Note Views

Module Nine: Viewing RSS Feeds

Adding an RSS Feed
Modifying or Deleting RSS Feeds Viewing a Feed
Working with Feed Items

Module Ten: Managing Outlook Data(I)

Cleaning Up Folders
Using Mailbox Cleanup Understanding Data Configurations Archiving Data

Module Eleven: Managing Outlook Data(II)

Backing Up Data Adding a New PST File Closing a PST File Opening a PST File

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

PowerPoint 2010 Advanced

PowerPoint is a powerful presentation for the presentation of visual and graphical items. You can do everything from creating simple handouts to developing an animated presentation with audio.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Adding Pictures

Inserting a Picture from a File
Adding Screenshots
Inserting Clip Art
Using the Picture Tools Tab
Resizing, Moving, and Deleting a Picture Removing a Picture’s Background

Module Three: Working with Text Boxes

Inserting a Text Box
Adding Text
Using the Drawing Tools Tab
Resizing, Moving, and Deleting a Text Box Formatting a Text Box

Module Four: Adding SmartArt

Inserting SmartArt
Using the SmartArt Tools Tabs
Adding Text to SmartArt
Resizing, Moving, and Deleting SmartArt

Module Five: Adding Tables

Inserting a Table
Adding Text to a Table
Using the Table Tools Tab Modifying Rows and Columns Formatting a Table

Module Six: Inserting Advanced Objects

Adding a Movie
Adding a Sound Clip
Creating Word Art
Drawing Shapes
About the Drawing Tools Tab

Module Seven: Advanced Drawing Tasks

Using the Grid and Guides Rotating and Flipping Objects Aligning and Distributing Objects Ordering Objects
Grouping Objects

Module Eight: PowerPoint’s Research Tools

Checking Spelling
Using the Research Task Pane Using Translation ScreenTips Setting the Language

Module Nine: Creating Notes and Handouts

Adding Notes to Slides Creating a Notes Master Creating a Handout Master Printing Notes and Handouts

Module Ten: Using Slide Masters

Switching to Slide Master View Using the Slide Master Tab Creating a Slide Master Applying a Slide Master Editing a Slide Master

Module Eleven: Advanced Presentation Tasks

Inserting Slides from Other Presentations Creating a Custom Show
Recording Your Show as a Video Packaging Your Presentation for CD About the PowerPoint Viewer

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Publisher 2010 Advanced

Publisher is one of the Office suite’s hidden gems, offering you the ability to easily create any kind of publication – newsletters, business cards, menus, invitations, and much more! This course will take you through the basics of using Microsoft Publisher 2010. Highlights include using the new ribbon interface, setting up your business information, working with color and font schemes, using the new Getting Started Window, and using page masters.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Working With Text

Import Text from a File
Working with Text Box Overflow
Inserting Symbols, Fractions, or Special Characters Set or Change Tab Stops
Insert Date and Time

Module Three: Working with Pictures

Wrapping Text Around a Picture Cropping Pictures
Inserting a Picture into an AutoShape Converting Pictures to Watermarks Make Pictures Transparent

Module Four: Graphics and Objects

Graphics Manager Task Pane Using the Building Blocks Library Adding Text to a Shape
Graphic File Formats and Filters

Module Five: Moving and Grouping Objects

Moving an Object
Group and Ungroup Objects Align or Distribute Objects Send an Object to the Back

Module Six: Page Layout

Change the Paper Size
Changing Page Size
Scratch Area
Add or Remove Headers and Footers Make an Object Appear on Multiple Pages

Module Seven: Media Files

About Media Files
Adding a File to Microsoft Clip Organizer Add, Change, or Delete Keywords for a Clip Sound and Motion Clips
Animated GIFs

Module Eight: Mail and E-mail Merges

Creating a Data Source for a Mail Merge
The Mail Merge Wizard
Tracking Effectiveness
Creating an Address List for a Mail Merge
Add Postal Bar Codes to Labels or Envelopes in Publisher

Module Nine: Creating a Catalog

Insert Catalog Pages
Create a Product List Choosing a Catalog Layout Finishing Your Catalog Merge

Module Ten: Publication Information

Personalizing Your Publication
Using the Design Checker
Setting Commercial Print Information View or Change Properties

Module Eleven: Save and Send Files

Send Using Email
Save Files in Other Formats
Save as an XPS File
Using the Pack and Go Wizard for Commercial Printing

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Visio 2010 Advanced

This course will help you get up and running with Visio 2010. We’ll show you how to use the new interface, create drawings, add shapes, customize your screen for maximum productivity, and format your drawing.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Exploring Advanced Diagrams (I)

Understanding Visio Definitions Creating Calendars
Creating Maps
Flowcharts

Creating Organization Charts Using Perspective

Module Three: Exploring Advanced Diagrams (II)

Network Diagrams
Marketing Diagrams
Create Work Flow Diagrams
Create Fishbone (Cause and Effect) Diagrams Project Management Diagrams
Gantt Charts
PERT Charts

Module Four: Working with Stencils and Shapes

Creating Custom Stencils Adding Shapes to the Stencil Saving the Stencil Controlling Shape Placement

Module Five: Advanced Custom Shape Design

Using Quick Shapes
Creating New Shapes
Revising Existing Shapes Locking and Protecting Shapes

Module Six: Layers (I)

Understanding Layers
The Layer Properties Dialog Box Working with Existing Layers Hiding or Showing a Layer Activating a Layer

Module Seven: Layers (II)

Creating Layers
Renaming and Removing Layers Assigning Shapes to Layers Assigning Color to a Layer Protecting a Layer from Changes Printing Only the Layers You Want

Module Eight: Multi-Page Drawings

Adding Pages to a Drawing Arranging Pages
Working with Background Pages Hyperlinking Between Pages

Module Nine: Creating Technical Layouts

Drawing with Precision
Setting a Drawing Scale
Working with Building Plan Layouts

Module Ten: Working with Data Graphics

About Data Graphics
Using the Data Selector Wizard Applying Data Graphics
Editing Data Graphics
Data Graphic Legends

Module Eleven: The ShapeSheet

Viewing the ShapeSheet
Modifying ShapeSheet Data
Using a Formula in the ShapeSheet

Module Twelve: Wrapping Up

Words from the Wise Review of Parking Lot Lessons Learned

Completion of Action Plans and Evaluations

Word 2010 Advanced

In this workshop, we’ll cover some of the more advanced tasks in Word 2010, like working with pictures and other objects, using generated tables of contents and indexes, and other research and review tasks.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Working with the Word Window

Using Zoom
An Overview of Word’s Views Arranging Windows
Splitting a Document
Using the Navigation Pane

Module Three: Adding Pictures

Inserting Clip Art
Inserting a Picture from a File Inserting a Screenshot Moving or Deleting a Picture

Module Four: Formatting Pictures

Using the Picture Tools Tab Removing a Picture’s Background Adding Artistic Effects
Changing Picture Layout

Module Five: Adding SmartArt

Inserting SmartArt
Adding Text to SmartArt
Using the SmartArt Tools Tabs Moving and Deleting SmartArt

Module Six: Adding Tables

Inserting a Table
Adding Text to a Table About the Table Tools Tab Altering Rows and Columns Applying a Style
About Quick Tables

Module Seven: Inserting Special Objects

Adding a Cover Page Adding WordArt Drawing Shapes Adding a Text Box

Module Eight: Adding In Document References

Adding a Table of Contents
Adding Footnotes, Endnotes, and Citations Managing Sources
Inserting a Bibliography
Creating an Index

Module Nine: Advanced Research Tasks

Viewing Synonyms
Using the Research Task Pane Using Translation ScreenTips Setting the Language

Module Ten: Reviewing a Document

Adding a Comment Reviewing Comments Tracking Changes Reviewing Changes Comparing Documents

Module Eleven: Customizing Word

Minimizing the Ribbon
Customizing the Quick Access Toolbar Accessing Word’s Options
Changing Word’s Color Scheme

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Office 2010 Expert Access 2010 Expert

Your participants will learn how to use the advanced features of Access 2010. This workshop is designed to go beyond a basic understanding and to explore the more advanced features of Access 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.

You can use advanced forms and tasks to do even more in Access than you have previously learned. For example, you can use Access to create mailing labels, work with queries, and publish a Web database— among other things. By the time your participants finish this course, they will be able to navigate Access 2010 and create reports like a pro. Sit back, relax, and have fun. You are in for a thrilling ride!

Outline:

Module One: Getting Started

Housekeeping Items
The Parking Lot
Workshop Objectives Pre-Assignment
Action Plans and Evaluation Forms

Module Two: Working with the Access Environment

Working with Database Properties Encrypting a Database with a Password Using Save Object As
Module Two: Review Questions

Module Three: Working with Access Options (I)

Setting General Options
Setting Application Options Setting Navigation Options Setting Other Database Options Setting Datasheet Options Module Three: Review Questions

Module Four: Working with Access Options (II)

Setting Object Designers Options Setting Proofing and Language Options Setting Client Settings Options Customizing the Ribbon
Customizing the Quick Access Toolbar Module Four: Review Questions

Module Five: Tables

Hiding and Un-hiding Fields Freezing and Unfreezing Fields Modifying Data types Modifying Field Description Modifying Field Properties Module Five: Review Questions

Module Six: Importing Table Data

Appending Records to an Existing Table Importing Data as a Linked table Module Six: Review Questions

Module Seven: Forms

Creating a Blank Form
Using Themes
Using the Form Controls
Creating a Header and Footer Creating a Navigation Form
Using the Form Design Arrange Tools Using a Background Image

Using Conditional Formatting Module Seven: Review Questions

Module Eight: Queries (I)

Creating a Select Query Creating a Make Table Query Creating an Append Query Creating a Cross tab Query Module Eight: Review Questions

Module Nine: Queries (II)

Using the Show Table Command Using the Remove Table Command Creating Ad Hoc Relationships Using the total Row

Using Group By
Performing Calculations
Using the Expression Builder Module Nine: Review Questions

Module Ten: Reports

Creating a Blank Report Creating a Header and Footer Using the Property Sheet Using the Arrange Tab
Using the Format Tab
Using the Page Setup Tab Module Ten: Review Questions

Module Eleven: Macros and Code

Creating a Macro
Working with the Macro Tools Design Tab Working with the Action Catalog
Creating a Module
Creating a Class Module
About Visual Basic
Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise Review of Parking Lot

Excel 2010 Expert

Your participants will learn how to use the more in-depth features of Excel 2010. This workshop is designed to for the advanced users of Excel 2010. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.

Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information – and better information leads to better decision making!

Outline:

Module One: Getting Started

Housekeeping Items
The Parking Lot
Workshop Objectives Pre-Assignment
Action Plans and Evaluations

Module Two: Working with Permissions and Options

Marking Workbook as Final
Encrypting with a Password and Restricting Permissions Protecting the Current Sheet or the Workbook Structure Adding a Digital Signature
Setting Excel Options
Managing Versions
Saving a Workbook as an Excel Template
Module Two: Review Questions

Module Three: Sharing Workbooks

Inspecting Document Sharing Workbook
Editing a Shared Workbook Tracking Changes

Merging Copies of a Shared Workbook Module Three: Review Questions

Module Four: Performing Advanced Formula and Function Tasks

Using the Watch Window
Setting Calculation Options
Enabling or Disabling Automatic Workbook Calculations Using the IFERROR Function to Evaluation Formulas Module Four: Review Questions

Module Five: Working with Array Formulas

About Array Formulas
About Array Constants
Using One-Dimensional and Two-Dimensional Constants Examples of Basic Array Formulas
Examples of Advanced Array Formulas
Creating an Array Formula that Calculates a Single Result Creating an Array Formula that Calculates Multiple Results Module Five: Review Questions

Module Six: Functions

Working With Statistical Functions Working With Date and Time Functions Working With Financial Functions Working With Text Functions
Working With Cube Functions
Using a SUMIF Function
Module Six: Review Questions

Module Seven: Macros

Assigning Macros to a Command Button on the Ribbon
Run a macro by clicking an area on a graphic object
Configure a macro to run automatically upon opening a workbook Module Seven: Review Questions
Changing a Macro

Module Eight: Forms

Inserting Form Controls
Setting Form Properties
Module Eight: Review Questions

Module Nine: Applying Advanced Chart Features

Using Trend Lines
Using Dual Axes
Using Chart Templates
Module Nine: Review Questions

Module Ten: Working with PivotTables and PivotCharts

Using the Slicer to filter and segment PivotTable data in multiple layers Working with PivotTables Tools
Working with PivotCharts Tools
Using the Slicer to choose data sets from external data connections Module Ten: Review Questions

Module Eleven: Using Automated Analysis Tools (Add-In)

Loading the Analysis ToolPak
About the Analysis ToolPak Options (I) About the Analysis ToolPak Options (II) About the Analysis ToolPak Options (III) Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

InfoPath 2010 Expert

Your participants will learn how to use the advanced features of InfoPath 2010. This workshop is designed to go beyond a basic understanding and to explore the more advanced features of InfoPath 2010 in a practical way. This workshop incorporates a hands-on approach to learning.

InfoPath is a powerful solution for collecting data from users on a variety of platforms. Microsoft InfoPath 2010 has new great features, such as the Office Fluent UI, and the ability to customize SharePoint list forms in just one click. Are you ready to take your organization to the next level with Microsoft InfoPath 2010?

Outline:

Module One: Getting Started

Housekeeping Items
The Parking Lot
Workshop Objectives Pre-Assignment
Action Plans and Evaluation Forms

Module Two: Working with the InfoPath Environment

Setting Options
Setting Form Submission Options Setting Publishing Options
Setting Advanced Form Options Customizing the Ribbon
Customizing the Quick Access Toolbar Viewing Form Template Properties Module Two: Review Questions

Module Three: Working with Digital Signatures

About Trusted Locations
Applying a Digital Signature to a Form Adding Multiple Signatures to a Form Setting Confirmation Messages Disabling Digital Signatures
Digitally Signing Form Templates Module Three: Review Questions

Module Four: Working with Control Properties (I)

Working with Text Box Properties Working with List Box Properties Working with Combo Box Properties Working with Option Button Properties Working with Check Box Properties Module Four: Review Questions

Module Five: Working with Control Properties (II)

Working with Hyperlink Properties Working with Calculated Value Properties Working with Section Properties
Working with Date Picker Properties Working with Picture Properties
Module Five: Review Questions

Module Six: More Control Tasks

Modifying a Control
Setting a Fields Default Value Changing the Binding
Set a Field’s Value Using Rules Filtering Data Displayed in a Control Module Six: Review Questions

Module Seven: Using Commands and Switches

About Commands and Switches Types of Commands and Switches Using a Switch Once
Making a Reusable Switch

Module Seven: Review Questions

Module Eight: Using Formulas and Functions

About Formulas and Functions in InfoPath Using Date and Time Functions
Using Field Functions
Using Math Functions

Using Text Functions
Using URL Functions
Using the username Function Module Eight: Review Questions

Module Nine: Using Action Rules

Creating a Rule to Show a Message
Creating a Rule to Show the Value of a Field or Formula Creating a Rule to Switch Views
Creating a Rule to Set a Field’s Value
Creating a Rule to Open a New Form to Fill
Module Nine: Review Questions

Module Ten: More Action and Formatting Rules

Creating a Rule to Send Data to a WebPart Creating a Rule to Sign a Signature Line Creating a Rule to Close the Form
About Advanced Condition Scenarios Module Ten: Review Questions

Module Eleven: Queries and Data Submission

Using Data Entry Patterns Creating a Rule to Query for Data Creating a Rule to Submit Data Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise Review of Parking Lot

Outlook 2010 Expert

Your participants will learn how to use the advanced features of Outlook 2010. This workshop is designed to go beyond a basic understanding and to explore the more advanced features of Outlook 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.

In this workshop, we’ll cover some of the more advanced tasks in Outlook 2010, like managing automatic content and working with contact groups. You’re participants will learn how to use the Microsoft Word elements in your E-mails. This course explains some of the advanced e-mail, calendar, and task commands, as well as the Notes feature.

Outline:

Module One: Getting Started

Housekeeping Items
The Parking Lot
Workshop Objectives Pre-Assignment
Action Plans and Evaluation Forms

Module Two: Working with the Outlook Environment

Setting Options
Viewing Message Information Using the People Pane
Using List View (show/hide fields) Module Two: Review Questions

Module Three: Printing

Printing Attachments
Printing Calendars
Printing Multiple Messages Printing Multiple Contact Records Printing Tasks

Printing Multiple Notes
Module Three: Review Questions

Module Four: Working with Quick Steps

Creating a Quick Step
Performing a Quick Step
Editing a Quick Step
Deleting a Quick Step
Duplicating a Quick Step
Resetting a Quick Step to Default Settings Module Four: Review Questions

Module Five: Working with Messages

Attaching an Outlook Item
Inserting a Hyperlink
Saving Message Attachments
Saving a Message in Another Format Ignoring a Conversation

Module Five: Review Questions

Module Six: Manipulating Message Properties and Options

The Message Properties Window Showing or Hiding From or BCC Fields Specifying a Sending Account Specifying a Sent Item Folder
Setting Message Delivery Options Setting Permissions
Module Six: Review Questions

Module Seven: Formatting Messages

Using Styles
Using Themes
Using Paste Special
Formatting Graphics
Module Seven: Review Questions

Module Eight: Managing Automatic Content

Managing Signatures
Setting Theme and Font for New HTML Messages Setting Theme and Font for All HTML Messages Setting Reply and Forward Options
Setting the Default Font
Module Eight: Review Questions

Module Nine: Working with the Calendar, Appointments, and Meetings

Printing Appointment Details Forwarding an Appointment
Using the Scheduler
Cancelling a Meeting or Invitation Proposing a New Time for a Meeting Changing the Calendar Color Displaying or Hiding Calendars Module Nine: Review Questions

Module Ten: Working with Contacts and Contact Groups

Modifying a Business Card
Forwarding a Contact
Creating a Contact Group
Managing Contact Group Members
Sending an Email or a Message Invitation to a Contact Group Forwarding a Contact Group

Viewing Group Properties Module Ten: Review Questions

Module Eleven: Working with Tasks and the Journal

Managing Task Details
Sending a Status Report
Moving or Copying a Task to Another Folder Accept or Decline a Task Assignment
Save Current Task View
Automatically Record Entries and Files Editing a Journal Entry
Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise Review of Parking Lot

PowerPoint 2010 Expert

Your participants will learn how to use the advanced features of PowerPoint 2010. This workshop is designed to go beyond a basic understanding and to explore the more advanced features of PowerPoint 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.

PowerPoint 2010 is a powerful presentation for the presentation of visual and graphical items. You can do everything from creating simple handouts to developing an animated presentation with audio.

Outline:

Module One: Getting Started

Housekeeping Items
The Parking Lot
Workshop Objectives Pre-Assignment
Action Plans and Evaluation Forms

Module Two: Working with PowerPoint

About PowerPoint Views
Adjusting the View
Working with Multiple Presentation Windows Adding a Command to the Ribbon
Adding a Command to the Quick Access Toolbar Configuring the PowerPoint Options
Module Two: Review Questions

Module Three: Working with Presentations

Using Custom Slide Sizes
Changing the Orientation
Inserting an Outline
Reusing Slides from the Slide Library Reorganizing Slides

Module Three: Review Questions

Module Four: Formatting Presentations

Formatting Sections
Modifying the Theme
Switching to a Different Slide Layout Using Footers
Working with Slide Fills
Module Four: Review Questions

Module Five: Formatting Text Boxes

Working with Text Box Fills
Working with Shapes and Effects
Setting Text Box Alignment, Internal Margins, and Wrapping Creating a Default Text Box
Using Autofit
Module Five: Review Questions

Module Six: Creating a Photo Album

Adding Captions to Pictures
Inserting an Image as Black and White
Reordering Pictures
Adjusting Image Rotation, Brightness, and Contrast Cropping a Picture
Changing and Resetting a Picture
Compressing Pictures (selected or all)
Module Six: Review Questions

Module Seven: Working with Graphical and Multimedia Elements

Manipulating Graphical Elements Using Styles, Effects and Borders Adding Hyperlinks
Manipulating Images
Manipulating Audio and Video Content Module Seven: Review Questions

Module Eight: Working with SmartArt, Tables and Charts

Working with Word Art Manipulating SmartArt
Working with Tables
Working with Charts
Module Eight: Review Questions

Module Nine: Working with Transitions and Animations

Working with Effects
Working with Paths
Working with Transitions Manipulating Animations Module Nine: Review Questions

Module Ten: Collaborating on Presentations

Working with Comments (insert, edit, and delete) Showing or Hiding Markup
Navigating Comments
Comparing and Combining Presentations

Module Ten: Review Questions

Module Eleven: Delivering Presentations

Saving a Presentation as a Picture Presentation, PDF, XPS or OpenDocument Saving a Slide or Object as a Picture File
Marking a Presentation as Final
Using Password

Using Annotations
Setting up Presenter View Showing Media Controls Rehearsing Timings
Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise Review of Parking Lot

Project 2010 Expert

Your participants will learn how to use the advanced features of Project 2010. This workshop is designed to go beyond a basic understanding and to explore the more advanced features of Project 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.

Project 2010 has been completely redesigned, and we must say, we’re pretty excited! You will be covering some of the more advanced tasks like working with custom fields, in-depth resource management, and performance measurements.

Outline:

Module One: Getting Started

Housekeeping Items
The Parking Lot
Workshop Objectives Pre-Assignment
Action Plans and Evaluation Forms

Module Two: Working with the Project Environment (I)

Setting Project General and Display Options Setting Calendar and Schedule Options
Setting Proofing, Saving, and Language Options Module Two: Review Questions

Module Three: Working with the Project Environment (II)

Customizing the Ribbon
Customizing the Quick Access Toolbar
Setting Default Task Types
Changing the Default Assignment Unit Format Module Three: Review Questions

Module Four: Templates and Other New Project Time Savers

Creating a Template from a Completed Project
Creating a Project from an Existing Project
Creating a Project from a Microsoft SharePoint Task List Creating a Project from a Microsoft Excel Workbook Module Four: Review Questions

Module Five: Working with Custom Fields

About Custom Field Types
Creating a Custom Task Field Creating a Custom Resource Field Creating a Custom Project Field Using a Lookup Table
Creating Basic Formulas
Indicating Graphical Indicator Criteria Module Five: Review Questions

Module Six: Working with Tasks

Displaying the Project Summary Task on a New Project Rearranging Tasks
Creating Milestones
Creating Manually Scheduled Tasks

Using the Task Form View to Create Multiple Tasks Creating a Recurring Task
Cancelling an Unneeded Task
Module Six: Review Questions

Module Seven: Working with Resources (I)

Removing a Resource Assignment
Managing Unassigned Tasks
Resolving Resource Conflicts
Moving Task Assignments from One Resource to Another Printing a View or Report of Resource Information Module Seven: Review Questions

Module Eight: Working with Resources (II)

Add Resources to the Enterprise Resource Pool
Export Resource Data
Import Resource Data
Modifying Resource Information in the Resource Center Viewing Availability Across Multiple Projects

Module Eight: Review Questions

Module Nine: Using the Team Planner

Rolling Up Tasks
Formatting
Using Styles
Preventing Allocations
Showing and Hiding Information Module Nine: Review Questions

Module Ten: Managing Risks and Measuring Performance

Review Differences Between Planned, Scheduled and Actual Work Find Slack in the Schedule
Comparing Two Versions of a Project
Calculating Earned Value Analysis

Module Ten: Review Questions

Module Eleven: Communicating Project Information

About Sharing Information
Copying a .GIF Image of Your Plan Publish a Project to a SharePoint List Attaching Documents
Linking Hyperlinks
Printing Based on a Date Range Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise Review of Parking Lot

Word 2010 Expert

Your participants will learn how to use the advanced features of Word 2010. This workshop is designed for a more in-depth understanding of Word 2010 in a practical way. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.

In this workshop, we’ll cover some of the more advanced tasks in Word 2010, like managing versions, Applying templates, working with macros, pictures and other objects, using generated tables of contents and indexes, and other research and review tasks.

Outline:

Module One: Getting Started

Housekeeping items
The Parking Lot
Workshop objectives
Action plans and evaluation forms

Module Two: Working with Document Information and Word Customization

Understanding Document Information Protecting a Document
Checking for Issues
Managing Versions

Customizing Word Options Module Two: Review Questions

Module Three: Working with Templates

About Templates
Modifying an Existing Template
Creating a New Template
Applying a Template to an Existing Document Managing Templates
Module Three: Review Questions

Module Four: Working with Reusable Content

Creating Customized Building Blocks
Saving a Selection as a Quick Part
Saving Quick Parts after a Document is Saved Inserting a Quick Part
Module Four: Review Questions

Module Five: Working with Sections and Linked Content

Using Sections
Customizing Page Numbers in Sections
Using Multiple Page Formats in a Document
Using Different Headers and Footers in a Document Linking and Breaking Links for Text Boxes
Module Five: Review Questions

Module Six: Tracking Documents

Merging Different Versions of a Document Tracking Comments in a Combined Document Reviewing Comments in a Combined Document Module Six: Review Questions

Module Seven: Using Cross References

Types of Cross References
Inserting a Bookmark
Inserting a Cross Reference
Updating a Cross Reference
Formatting Cross References using Fields Module Seven: Review Questions

Module Eight: Working with Mail Merges

Creating a Mail Merge
Sending Personalized Email Messages to Multiple Recipients
Using Other Data Sources for Mail Merge (Access, Outlook, Excel, Word tables) Creating Labels
Creating Envelope and Label Forms
Module Eight: Review Questions

Module Nine: Working with Master Documents

Creating a Master Document
Inserting a Subdocument
Creating a Subdocument
Expanding and Collapsing Subdocuments Unlinking a Subdocument

Merging and Splitting Subdocuments Locking a Master Document
Module Nine: Review Questions

Module Ten: Working with Macros

Recording a Macro
Running a Macro
Applying Macro Security
Assigning a Macro to a Command Button Module Ten: Review Questions

Module Eleven: Working with Forms

Creating a Form
Using Form Controls
Linking a Form to a Database Locking and Unlocking a Form Adding and Removing Fields Adding Help Content to Form Fields Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise
Review of the Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Office 2007 Essentials Access 2007 Essentials

Access is the world’s premier database software. You can use Access to create and edit databases — just download a ready-made database template and start typing. It’s that easy. You can create a database of contacts, expenses, household and/or business inventory. In other words, if you have data, you can create a database of that data using Access. Microsoft’s newest version of Access uses the new ribbon interface, and offers significant improvement to its database capability.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Opening Access

Common Database Terms
Opening Access
Understanding the Getting Started Window Creating a Blank Database from a Template

Module Three: Using the Access Interface

Understanding Security Warnings Interface Overview
Overview of the Ribbon Interface Using the Navigation Pane

Module Four: Working with Database Objects

Viewing Database Objects Exporting an Object
Renaming an Object
Sorting and Filtering Your View

Module Five: Creating Tables

Creating a Blank Table in Datasheet View Creating a Blank Table from a Template Understanding Data Types Understanding Lookup Columns

Creating a Blank Table using Design View Saving Your Table
Key Table Tools

Module Six: Working with Tables

Adding Information to a Table Editing Records
Deleting Records
Searching for Records

Module Seven: Creating Forms

Types of Controls
Creating a Form with the Wizard Creating a Form In Layout View Modifying Your Form in Design View Key Features on the Form Tools Tab

Module Eight: Working with Forms

Common Formatting Tasks Using AutoFormat
Adding Controls
Moving Controls

Deleting Records

Module Nine: Creating Reports

Using The Report Wizard
Using Design View
Adding a Logo
Working with Controls
Key Features on the Report Tools Tab

Module Ten: Creating Queries

Types of Queries
Creating a Query with the Wizard Executing a Query
Query Views
Key Features on the Query Tools Tab

Module Eleven: Managing Your Database

Understanding Access File Formats Printing an Object
Backing Up Your Database Emailing Your Database

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Excel 2007 Essentials

Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2007, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information – and better information leads to better decision making!

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Opening and Closing Excel

Opening Excel Understanding the Interface Understanding Worksheets Understanding Workbooks Closing Excel

Module Three: Your First Worksheet

Entering Data
Using the Wrap Command Editing Data
Adding Rows and Columns Checking Your Spelling

Module Four: Working with Excel Files

About the New File Format Saving Files
Publishing Files to PDF Closing Files

Opening Files

Module Five: Viewing Excel Data

An Overview of Excel’s Views Switching Views
Using Zoom
Switching Between Open Files

Module Six: Printing Excel Data

An Overview of the Page Layout Tab Setting Up Your Page
Using Print Preview
Printing Data

Module Seven: Building Formulas

The Math Basics of Excel Building a Formula
Editing a Formula
Copying a Formula
Relative vs. Absolute Referencing

Module Eight: Using Excel Functions

Formulas vs. Functions
Understanding the Formulas Tab
Using the SUM Function
Using Other Basic Excel Functions
Using the Status Bar to Perform Calculations

Module Nine: Using Time Saving Tools

Using AutoFill
Using AutoComplete Sorting Data Filtering Data

Module Ten: Formatting your Data

Changing the Appearance of Your Text Changing the Appearance of Numbers Setting Alignment Options
Using Merge

Removing Formatting

Module Eleven: More Formatting

Adding Borders
Adding Fill Color
Using Cell Styles
Using Conditional Formatting Changing the Theme

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Groove 2007 Essentials

Welcome to the Microsoft Groove 2007 Essentials workshop. In this course, we’ll show you how to communicate and collaborate with team members all over the world, whether they are in your organization or not. Groove allows you to create workspaces, share files, and start and participate in team discussions. We’ll also show you how to use Groove tools like the Calendar and SketchPad.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Opening and Closing Groove

Understanding How Groove Works Opening Groove
Launchbar Overview
Closing Groove

Module Three: Creating a Groove Workspace

Understanding Workspace Types Creating a Workspace
Understanding the Workspace Interface Adding Workspace Members

Module Four: Using Your Workspace

Adding Additional Members Starting a Discussion Sharing Files
Viewing and Editing Files Chatting with Members Sending a Message

Module Five: Customizing Your Workspace

Adding Standard Tools
Adding Custom Tools
Customizing Workspace Properties Setting User Roles

Module Six: Using Groove’s Tools (I)

Calendar
Forms
InfoPath Forms Issue Tracking Log Meetings

Module Seven: Using Groove’s Tools (II)

Notepad SketchPad Pictures SharePoint Files

Module Eight: Customizing Alerts

Setting Default Alert Options Creating Tool Alerts Creating Workspace Alerts Viewing Alerts

Suppressing Alerts

Module Nine: Using Groove’s Management Tools

Using the Contact Manager
Using the Workspace Manager Using the Communications Manager Viewing Message History

Module Ten: Managing Groove Items

Saving Workspaces Renaming Items
Viewing an Item’s Properties Deleting Items

Module Eleven: Setting Groove Options

Managing Identities
Setting Account Options Managing Security
Modifying General Options Setting Synchronization Options

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

InfoPath 2007 Essentials

This course will take a close look at InfoPath 2007 to give you all the tools you need to create, manage, and fill out forms. You’ll be amazed at how InfoPath can help your organization streamline its information flow!

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Opening and Closing InfoPath

Opening InfoPath
Using the Getting Started Window Interface Overview
An XML Primer
Closing InfoPath

Module Three: Filling Out a Form

Launching Fill-Out-A-Form Mode Entering Data
Checking Your Spelling
Printing the Form

Saving the Form

Module Four: Designing a Form Framework

Creating a Blank Form
Adding a Table
Adding and Removing Rows or Columns Merging and Splitting Cells
Formatting Tables
Changing Table Properties

Module Five: Adding Labels

Adding Labels
Changing the Font Face and Size Changing the Font Color
Adding Effects
Using the Font Task Pane Aligning Text

Module Six: Adding Controls

Adding a Standard Control
Adding Repeating and Optional Controls Adding File Controls
Adding Picture Controls
Advanced Types of Controls

Module Seven: Formatting Controls

Changing the Visual Properties of a Control Using the Control Properties Dialog
Adding Data Validation Rules
Applying Conditional Formatting

Running the Logic Inspector

Module Eight: Working with Data Sources

Viewing Data Source Information Managing Fields and Groups Adding a Data Connection Manually Binding Controls

Module Nine: Creating a View

Creating a Custom View Creating a Print View Setting a View as Default Deleting Views

Module Ten: Finishing the Form

Changing the Color Scheme Checking Your Spelling Using the Design Checker Previewing the Form

Module Eleven: Distributing Your Form

Protecting Your Form Understanding Saving vs. Publishing Using the Publishing Wizard
Printing the Form

Module Twelve: Wrapping Up

Words from the Wise Review of Parking Lot Lessons Learned

Completion of Action Plans and Evaluations

OneNote 2007 Essentials

Have you ever wished that you could track appointments, take meeting notes, record research, and keep to-do items all in one place? Well, you can do all that and more with OneNote 2007! In this course, we’ll show you how.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Opening and Closing OneNote

Opening OneNote Interface Overview Closing OneNote
About the OneNote Icon

Module Three: Your First Notebook

Typing Text
Handwriting Text
Adding Text and Objects from Other Applications Using the Formatting Toolbar

Module Four: Basic Editing Tasks

Resizing Objects
Moving Objects
Using Cut, Copy, and Paste Using Undo and Redo Checking Your Spelling

Module Five: Working with Pages

Adding Pages and Sub-Pages
Moving, Renaming, and Deleting Pages and Sub-Pages Using the Page Setup Task Pane
Adding Rule Lines

Module Six: Adding Objects to Your Notebook

Creating Lists
Creating Tables
Inserting Pictures Inserting Screen Clippings Researching in OneNote

Module Seven: Advanced OneNote Objects

Calculating in OneNote
Adding an Audio Recording
Adding a Video Recording
Linking to Files
Linking to Outlook Meetings and Tasks

Module Eight: Drawing in OneNote

Drawing Shapes
Selecting Shapes
Resizing and Deleting Shapes Formatting Shapes
Rotating and Flipping Shapes

Module Nine: Managing Notes

Tagging Notes
Using the Unfiled Notes Section
Adding Sections
Adding Section Groups
Renaming, Moving, and Deleting Sections and Section Groups

Module Ten: Working with Notebooks

Creating a New Notebook Saving Notebooks Searching in Notebooks Opening Notebooks Closing Notebooks

Module Eleven: Adding the Finishing Touches

Using the Page List Task Pane Using Full Page View
Password Protecting Your Notebook Using OneNote Backups

E-Mailing Your Notes Printing Your Notes

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Outlook 2007 Essentials

Outlook is a powerful e-mail application. However, it does much more than that to help you stay organized. With contacts, calendars, and tasks, Outlook can help you manage every aspect of your life.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Opening and Closing Outlook

Opening Outlook Understanding the Interface Setting up an E-mail Account Viewing Your Inbox
Closing Outlook

Module Three: Working with E-mail

Sending and Receiving Mail
Viewing an E-mail
Replying To or Forwarding an E-mail Deleting an E-mail

Module Four: Creating a New E-mail

Creating an E-mail Addressing an E-mail Creating the Body Attaching a File Sending the Message

Module Five: Managing E-mail

Marking an Item as Read or Unread Printing a Message
Creating Folders
Moving Messages to Folders
Renaming, Moving, and Deleting Folders

Module Six: Managing Junk Mail

About the Junk Mail Filter
Enabling Junk Mail Filtering
Enabling the Phishing Filter
Modifying Safe and Blocked Senders Lists Marking a Message as Junk or Not Junk

Module Seven: Outlook’s Organization Tools

Creating a Basic Rule
Creating an Advanced Rule Using Categories
Flagging an Item for Follow-Up Viewing Favorite Folders

Module Eight: Searching for Items

Understanding Search Folders Setting Up and Using Search Folders Using Instant Search
Using Advanced Search
Using Contact Search

Module Nine: An Introduction to the Calendar

Getting Started
Creating an Appointment Changing Your Calendar View Editing an Appointment Managing Reminders

Module Ten: An Introduction to Tasks

Getting Started Creating a New Task Editing a Task
Basic Task Views

Module Eleven: An Introduction to Contacts

Getting Started Creating a New Contact Editing a Contact Organizing Contacts

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

PowerPoint 2007 Essentials

PowerPoint is the world’s premier presentation software. You can use PowerPoint to create and edit slides, and then to run the slide show while you deliver your presentation. Slides can have a variety of information on them, and you can add interest to your slides using formatting and animation. Microsoft’s newest version of PowerPoint uses the new ribbon interface, and offers significant improvement to its graphical capability.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Opening and Closing PowerPoint

Opening PowerPoint Understanding the Interface Creating a Blank Presentation Closing PowerPoint

Module Three: Working with Presentations

Creating a Presentation from a Template Saving Files
Opening Files
Closing Files

Module Four: Your First Presentation

Adding Text to a Slide
Adding a Slide
Adding Text to the Content Placeholder Using the Slides Tab
Checking Your Spelling

Module Five: Formatting Text

Changing Font Face and Size Changing the Font Color Changing Character Spacing Adding Font Enhancements Clearing Formatting

Using the Font Dialog

Module Six: Formatting Paragraphs

Modifying Bullets and Numbering Changing Alignment
Adjusting the Indent
Using Tabs

Changing Line Spacing

Module Seven: Working with Text

Using Cut, Copy, and Paste Using the Outline Tab Using Undo and Redo Finding and Replacing Text

Module Eight: Advanced Formatting Tasks

Using the Format Painter Changing the Slide Background Applying a Theme
Changing the Color Scheme Changing the Slide Layout

Module Nine: Customizing Slide Elements

Adding a Header or Footer Applying a Standard Animation Creating a Custom Animation Adding a Slide Transition Setting Slide Advance Options

Module Ten: Setting up Your Slide Show

Using the Set Up Show Dialog Recording a Narration
Timing your Show
Hiding Slides

Module Eleven: Showtime!

Our Top Five PowerPoint Tips Starting a Show
Navigating through the Show Changing Your Pointer Switching to a Blank Screen

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Project 2007 Essentials

Project is the world’s premier spreadsheet software. You can use Project to analyze numbers, keep track of data, and graphically represent your information. With Project 2007, you can manage more data than ever, with increased worksheet and project sizes. Project also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information – and better information leads to better decision making!

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Opening and Closing Project

Opening Project
Understanding the Interface Creating a Project
Saving a Project
Opening and Closing Project Files Closing Project

Module Three: Your First Project

About the Project Guide
Entering the Start Date for your Project Setting the Project Calendar
Setting Holidays and Days Off
Defining the Units of Time (Days and Weeks)

Module Four: Adding Tasks

Understanding Key Terms Entering Tasks
Viewing Task Information Adding Notes to Tasks Understanding Task Indicators

Module Five: Advanced Task Operations

Creating Summary Tasks Creating Recurring Tasks Changing the Order of Tasks Deleting Tasks

Splitting a Task

Module Six: Scheduling your Tasks

Linking Tasks
Unlinking Tasks
Adding Lags and Leads to Task Relationships Setting Deadlines
Setting Constraints

Module Seven: Adding Resources

Understanding Resources Creating a Work Resource Creating a Material Resource Viewing Resource Information Modifying the Resource Calendar

Module Eight: Assigning Resources

Understanding the Relationship between Work, Duration and Units Assigning a Single Resource
Assigning Multiple Resources
Changing a Resource Assignment

Leveling Resources

Module Nine: Customizing Your Project View

Important Task Views
Important Resource Views
Customizing the Gantt Chart with the Wizard Customizing the Gantt Chart Manually Formatting the Time Scale

Module Ten: Creating Project Reports

Creating Basic Reports Creating a Visual Report Copying a Picture
Adding a Text Box and Shapes

Module Eleven: Finishing Your Project

Checking your Spelling
Using the Page Setup Dialog Box Printing a Project View
E-mailing a Project

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Publisher 2007 Essentials

In this course, you will learn the basic functionality and editing essentials that will allow you to produce high quality publications for both personal and business use. Microsoft Publisher 2007 is a flexible and powerful authoring tool. This course will teach you how to begin, edit, format and produce a publication in Microsoft Publisher 2007. This course is a hands-on class that will have you producing documents today.

Once you gain a basic understanding of Microsoft Publisher 2007, you will be able to produce a wide variety of documents for publication.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Opening and Closing Publisher

Opening Publisher
Using the Getting Started Window Interface Overview
Creating a Blank Publication Closing Publisher

Module Three: Working with Publications

Saving Files
Opening Files Closing Files
Using the Recent List

Module Four: Your First Publication

Setting up Your Business Information Adding Text
Navigating Through the Publication Adding a New Page

Working with Pages

Module Five: Basic Editing Tasks

Using Cut, Copy and Paste Using the Office Clipboard Using Undo and Redo Finding and Replacing Text

Module Six: Using the Format Publication Task Pane

Viewing the Pane
Setting Page Options Choosing a Color Scheme Choosing a Font Scheme Setting Publication Options

Module Seven: Basic Formatting Tasks

Changing Font Face and Size Changing the Font Color Adding Font Enhancements Applying Styles

Module Eight: Formatting Paragraphs (I)

Changing Spacing Setting the Alignment Indenting Text

Module Nine: Formatting Paragraphs (II)

Adding Bullets and Numbering Adding Borders
Adding Shading
Using the Paragraph Dialog

Module Ten: Formatting the Page

Creating Columns Changing the Background Adding Page Numbers Applying a Page Master

Module Eleven: Adding the Finishing Touches

Checking Your Spelling Previewing Your Publication Printing Your Publication E-Mailing Your Publication

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Visio 2007 Essentials

This course will help you get up and running with Visio 2007. We’ll show you how to create drawings, add shapes, customize your screen for maximum productivity, and format your drawing.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Opening and Closing Visio

Opening Visio
Using the Getting Started Window Interface Overview
Closing Visio

Module Three: Working with Files

Creating a New Drawing Switching Between Files Saving Files
Closing Files

Opening Files

Module Four: Your First Drawing

Finding the Required Shape
Placing the Shape in the Drawing Selecting Shapes
Resizing, Moving, and Deleting Shapes Connecting Shapes
Adding Text to a Shape

Module Five: Setting Up Your Drawing

Showing and Hiding Screen Elements Adding a Guide
Moving or Deleting a Guide Changing Ruler and Grid Settings

Module Six: Basic Editing Tasks

Cutting, Copying, and Pasting Shapes Duplicating Shapes
Using Undo and Redo
Finding and Replacing Text

Checking Your Spelling

Module Seven: Formatting Shapes

Changing a Shape’s Outline Color Changing a Shape’s Fill Color Modifying Corners
Adding Shadows

Changing Line Types and Ends

Module Eight: Formatting Text

Changing the Font Face and Size Changing Font Color
Adding Effects
Using the Format Text Dialog

Module Nine: Formatting Blocks of Text

Aligning Text
Indenting Text
Changing Paragraph Spacing Creating a Bulleted List

Module Ten: Formatting Your Drawing

Aligning Shapes
Using the Format Painter Applying a Theme Centering Your Drawing

Module Eleven: Adding the Finishing Touches

Using the Page Setup Dialog Previewing Your Drawing
Saving Your Drawing as a Picture Printing Your Drawing

E-mailing Your Drawing

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Windows 7 Essentials

Welcome to the Windows 7 Essentials workshop. This workshop will help you unlock the power of the tools available in Windows 7. By the end of this workshop, your new desktop will have you rocketing through your tasks like a pro!

Windows 7 Essentials will show your participants the great new features of Windows 7 and provide them with a great base to further their Windows 7 experiences. With Windows 7 you are able to better manage your time by providing new and more efficient tools and applications.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Welcome to Windows 7

Windows 7 Upgrade Advisor Upgrading from Windows Vista? Upgrading from Windows XP? User State Migration Tool Windows Easy Transfer

Module Two: Review Questions

Module Three: Start Menu

Log In and Out of Windows
All Programs
Search Box
Pin to Start Menu
Customizing the Start Menu Module Three: Review Questions

Module Four: The Taskbar

Jump Lists
Live Taskbar Preview
Pin to Taskbar
Notification Area
Action Center
Module Four: Review Questions

Module Five: Control Panel (I)

System and Security Network and Internet Hardware and Sound Programs

Module Five: Review Questions

Module Six: Control Panel (II)

User Accounts and Family Safety Appearance and Personalization Clock, Language, and Region Ease of Access

Module Six: Review Questions

Module Seven: Gadgets and Tools

Desktop and SideShow Gadgets Themes
Sticky Notes
Snipping Tool

Get More Gadgets Online
Module Seven: Review Questions

Module Eight: Productivity Tools

Drag and Drop Files
Aero Shake and Snap
Libraries
Windows Key Shortcuts
Module Eight: Review Questions

Module Nine: Networking and Sharing

HomeGroup
View Available Networks Sharing Files
Remote Media Streaming Location Aware Printing Module Nine: Review Questions

Module Ten: Built-in Applications

Windows Mail
Windows Defender
Windows Firewall
Backup and Restore
Windows Media Center
Module Ten: Review Questions

Module Eleven: Troubleshooting Tools

Program Compatibility Problem Steps Recorder System Restore
XP Mode

Startup Repair
Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise
Review from the Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Windows 8 Essentials

Welcome to the Windows 8 Essentials workshop. This workshop will give your participants an introduction into the new world of Windows 8. With Windows 8 Microsoft has introduced a different environment with its new user interface and ways of navigating through your apps.

Windows 8 Essentials will show your participants the great new features of Windows 8 and provide them with a great base to further their Windows 8 experiences. With Windows 8 you are able to better manage your time by providing new and more efficient tools and applications.

Outline:

Module One: Getting Started

Housekeeping Items
The Parking Lot
Workshop Objectives
Action Plans and Evaluations

Module Two: Welcome to Windows 8

About Windows 8
Installing Windows 8 (upgrade vs. clean)
Setting up Windows 8 (including about your Microsoft Account) Exploring the Start Screen
Using Windows 8 with a Touch Screen
Logging In and Shutting Down
Module Two: Review Questions

Module Three: Using Apps

Opening and Closing an App Navigating Apps
About the Built-In Apps Using All Apps

Updating and Downloading Apps from the Windows Store Module Three: Review Questions

Module Four: Working with the Desktop

Opening the Desktop
About the Desktop Interface
Switching Between the Start Screen and the Desktop Opening Desktop Apps
Using Desktop Effects (snap, peek, shake and flip) Opening Files with Different Apps
Module Four: Review Questions

Module Five: Using the Task Bar

About the Task Bar
Pinning Apps to the Task Bar Using Jump Lists
Minimizing All Open Windows Module Five: Review Questions

Module Six: Working with the Charms Bar

Displaying the Charms
Using the Search Charm Using the Share Charm
Using the Start Charm
Using the Device Charm Module Six: Review Questions

Module Seven: Managing Your Files and Folders

Working with File Explorer Changing File Explorer View Sorting Files
Searching for Files

Working with Libraries
About SkyDrive
Module Seven: Review Questions

Module Eight: Devices, Networking and Sharing

– View Available Networks
Using a HomeGroup
Using Remote Desktop Selecting Sharing Options Adding and Removing Devices Module Eight: Review Questions

Module Nine: Working with Settings and the Control Panel

Using the Settings Charm
Opening the Control Panel
Managing User Accounts and Parental Controls Setting Default Programs
Removing Unwanted Programs
Module Nine: Review Questions

Module Ten: Personalizing Windows 8

Customizing the Lock Screen Customizing the Start Screen Customizing Tiles on the Start Screen Customizing the Desktop

Accessing the User Screen Module Ten: Review Questions

Module Eleven: Understanding Security and Maintenance

Understanding Security Features Using Windows Update
Using the Action Center Troubleshooting Problems

Using System Restore
Module Eleven: Review Questions

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Word 2007 Essentials

Microsoft Word is one of the most widely used applications in the world today, so it’s important to have a firm grasp on the basics. To begin, you’ll learn basic word processing tasks, such as how to type, delete, and edit text. Then, we’ll look at some of Word’s essentials features, including formatting tools, bullets and numbering, themes, and headers and footers.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Opening and Closing Word

Opening Word
Interface Overview Creating a Blank Document Typing Text
Closing Word

Module Three: Working with Documents

Saving Files
Closing Files
Opening Files
Creating a Document from a Template Using the Recent List

Module Four: Your First Document

Selecting Text with the Mouse or Keyboard Dragging and Dropping Text
Checking Your Spelling
Starting a New Page

Module Five: Basic Editing Tasks

Using Cut, Copy, and Paste Using the Office Clipboard Using Undo and Redo Finding and Replacing Text

Module Six: Basic Formatting Tasks

Understanding Levels of Formatting Changing Font Face and Size Changing the Font Color
Adding Font Enhancements Clearing Formatting

Module Seven: Advanced Formatting Tasks

Highlighting Text Changing Case
Using the Format Painter Using the Font Dialog

Module Eight: Formatting Paragraphs

Changing Spacing
Setting the Alignment
Using Indents and Tabs Adding Bullets and Numbering Adding Borders and Shading

Module Nine: Working with Styles

About Styles
Applying a Style Changing a Style Changing the Style Set Changing the Theme

Module Ten: Formatting the Page

Formatting Text as Columns Adding Headers and Footers Changing Page Orientation Changing the Page Color Adding a Page Border

Module Eleven: Adding the Finishing Touches

Adding a Cover Page
Using the Page Setup Dialog Previewing Your Document Printing Your Document E-Mailing Your Document

Module Twelve: Wrapping Up

Words from the Wise Review of Parking Lot Lessons Learned

Completion of Action Plans and Evaluations

Office 2007 Advanced Access 2007 Advanced

This workshop is designed to teach you a deeper understanding of Access 2007 in a practical way. You will learn how to use the advance features of Access to help you better manage your database. This workshop incorporates a hands-on approach to learning. You will get both teaching and a chance to practice some of the advance features right on a computer.

This workshop is meant to provide a safe learning environment where you can practice and learn Access 2007 advance functions without worrying about making mistakes. Making mistakes is a part of learning and is expected in this workshop. Taking the time to learn the advanced features of Access 2007 will increase your knowledge on how databases work and make creating and managing an Access 2007 database easier for you.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Advanced Table Tasks

Using the Property Sheet
Adding, Moving, and Removing Controls Formatting Controls
Setting the Primary Key

Module Three: Advanced Form Tasks

Creating a Sub-Form Creating a Split-Form Creating a Modal Dialog Creating a Pivot Table Creating a Pivot Chart

Module Four: Advanced Reporting Tasks

Using Report Sections Grouping and Sorting Data Adding Calculated Controls Creating Labels

Module Five: Understanding Relationships

Types of Relationships
Viewing Relationships
Editing Relationships
About Referential Integrity Establishing Referential Integrity

Module Six: Advanced Query Tasks

Sorting and Filtering a Query Adding Calculated Fields Using the Expression Builder Using Logical Functions

Module Seven: Working with SQL

What is SQL?
Understanding SQL Statements Basic SQL Syntax
Uses for SQL in Access

Module Eight: Linking Data

Linking to an Excel Spreadsheet Linking Access Database Linking to a SharePoint List Linking to a Text or XML File Other Types of Links

Module Nine: Importing Data

Importing from an Excel Spreadsheet Importing from an Access Database Importing from a SharePoint List Importing from a Text or XML File Other Types of Imports

Module Ten: Exporting Data

Saving an Object as PDF Exporting to an Excel Spreadsheet Exporting to a SharePoint List Exporting to a Word or Text File Other Types of Exports

Module Eleven: Advanced Database Tools

Using the Database Documenter Analyzing Table Performance Analyzing Database Performance Compact and Repair a Database

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Excel 2007 Advanced

Knowing how to use the advanced features of Microsoft Excel 2007 opens a completely new experience in using this spreadsheet program. The novice user tends to use Excel 2007 as holding place for report data. They may know how to insert data and move columns around, but rarely go into the deeper functions that Excel 2007 offers.

This workshop will teach you the most common advanced features of Microsoft Excel 2007. The goal of this course is to get you familiar with these functions in a safe learning environment. Once you complete the course, your familiarity and confidence in using the advanced feature of Excel 2007 will increase, making Excel 2007 a more useful tool for you at work or at home.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: SmartArt

Inserting SmartArt
An Overview of the SmartArt Tabs Adding Text to the Diagram Resizing and Moving the Diagram Resetting the Diagram

Module Three: Inserting Objects

About Contextual Tabs
Adding Pictures from Your Computer Adding ClipArt
Adding Text Boxes
Drawing Shapes

Module Four: Creating Charts

Inserting a Chart
Overview of the Chart Tools Tabs Understanding the Parts of a Chart Changing the Chart Style
Resizing and Moving the Chart

Module Five: Creating Pivot Tables

Inserting a Pivot Table
Overview of the Pivot Table Tools Tab Choosing Fields

Module Six: Working with Pivot Tables

Changing the Data Displayed Applying a Style to Your Pivot Table Some Real-life Examples

Module Seven: Creating Pivot Charts

Creating a Pivot Chart from a Pivot Table Creating a Pivot Chart from Data

Module Eight: Solving Formula Errors

Using Named Ranges Understanding Formula Errors Tracing Dependents and Precedents Using the Trace Errors Commands Evaluating Formulas

Module Nine: Using What-If Analysis

Using Goal Seek
Using the Scenario Manager Using a One Input Data Table Using a Two Input Data Table

Module Ten: Managing Your Data

Transposing Data from Rows to Columns Using the Text to Columns Feature Checking for Duplicates
Creating Data Validation Rules Consolidating Data

Module Eleven: Grouping and Outlining Data

Grouping Data
Adding Subtotals
Outlining Data
Viewing Grouped and Outlined Data

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

InfoPath 2007 Advanced

This course will take a close look at InfoPath 2007 to give you all the tools you need to create, manage, and fill out forms. You’ll be amazed at how InfoPath can help your organization streamline its information flow!

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Types of Controls

Insert Controls on a Form Template Understanding Controls and the Data Source Standard Controls
Repeating and Optional Controls
File and Picture Controls
Custom and Advanced Controls
Remove a Control from a Form Template

Module Three: Repeating and Optional Controls

Using Repeat Tables
Using Repeating Sections Creating an Optional Section

Module Four: Actions

Creating an Action Based on User Input Using Buttons to Switch Views
Applying Conditional Formatting Calculating Fields

Validating Your Form Input Data

Module Five: Importing Form Designs

About Importing Designs from Other Applications Importing Word Forms
Importing Excel Forms

Module Six: Advanced Topics

Cascading List Box Merging Forms

Module Seven: Custom Task Panes

About Using a Custom Task Pane
Adding Resource Files to Your Form Template Creating a Custom Task Pane

Module Eight: Understanding Code

About How InfoPath uses XML Technologies InfoPath Form Events
Working with Data Connections
Using an Add-In

Module Nine: Publishing Forms

Understanding Form Security
Setting Form Template Security Level Network Location
Hosting InfoPath Forms

Module Ten: SharePoint Integration

Form Libraries
Promoting Field Properties
Email Enabling Document Libraries SharePoint Workflow

Module Eleven: Publishing Forms for Use with SharePoint

Publishing To a SharePoint Form Library Publishing To a SharePoint Site as a Content Type Browser Capable Forms
Installable Form Template

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

OneNote 2007 Advanced

Have you ever wished that you could track appointments, take meeting notes, record research, and keep to-do items all in one place? Well, you can do all that and more with OneNote 2007! In this course, we’ll show you how, plus we’ll explore OneNote’s new ribbon-based interface.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Upgrading from OneNote 2003?

What You Need to Know About the New File Format New Features in OneNote 2007

Module Three: Staying Organized

The Navigation Bar
Drag and Drop
Sorting and Viewing Pages Hyperlinks

Module Four: Note Taking Tools

Table Editing Tools
The Drawing and Pen Tool Bars Understand the Calculator Capabilities

Module Five: Text and Page Formatting

Format Using the Task Pane Select a Page Template Select a Default Template Create a New Template

Module Six: Office Integration

Attach Files to Your Notes
Insert Files as Printouts
Print to OneNote from Other Applications Send to Word

Module Seven: Researching a Topic

Side Note Window
Send Web Pages to OneNote The Research Task Pane
Screen Clipping
Make Text in Pictures Searchable

Module Eight: Handwriting Notes

OneNote Basics on a Tablet PC The Writing Tool Bar Specifying Pen Mode
Convert Handwriting to Text

Module Nine: On the Road

Multiple Computer Support
Understanding Notebook Synchronization Status OneNote Mobile for Mobile Devices

Module Ten: Live Sharing

Start a Live Sharing Session Join a Live Sharing Session The Live Session Task Pane

Module Eleven: Other Tools

Password Protection
Audio and Video Recording Tools Audio Search

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Outlook 2007 Advanced

Outlook is the most common email program at work. Outlook 2007 is actually more than an email program. This program manages tasks, events, contacts and more. Learning how to use all the advanced features of Outlook 2007 will increase your efficiency by managing your schedule and communication better.

This workshop will teach you the commonly used advanced features of Outlook 2007. At the end of this course, you will have increased familiarity with Outlook 2007, giving you more confidence in using this program for all your communication needs at work.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Customizing Outlook

Customizing the Navigation Pane Changing the Reading Pane Changing the To-Do Bar Resizing Panes

Module Three: Adding Word Elements to an E-mail

Common Formatting Tasks Adding SmartArt
Adding Pictures
Adding Tables

Module Four: Customizing Your Profile

Setting up a Signature
Changing Font Options
Changing Stationary Options
Enabling or Disabling Automatic Spell Check

Module Five: Advanced E-Mail Tasks

Adding Voting Buttons
Setting the Priority
Changing the Message Format Adding a Follow-Up Flag

Module Six: Advanced Calendar Tasks

Creating a Recurring Appointment Creating a Meeting Request Tracking Meeting Responses Color-Coding Appointments Changing Calendar Options

Module Seven: Doing More with Tasks

Create a Recurring Task Assigning a Task
Using the Details Tab Setting Task Options

Module Eight: Using Notes

Opening the Notes Folder Creating a Note
Editing a Note Color-Coding a Note Changing Notes Views

Module Nine: Viewing RSS Feeds

Adding an RSS Feed
Modifying or Deleting RSS Feeds Viewing a Feed
Working with Feed Items

Module Ten: Managing Outlook Data (I)

Understanding Data Configurations Archiving Data
Using Mailbox Cleanup

Module Eleven: Managing Outlook Data (II)

Backing up Data Adding a New PST File Opening a PST File Closing a PST File

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

PowerPoint 2007 Advanced

If you develop presentations or visuals for any reason, the skills included in this course will help you maximize your use of many robust PowerPoint features to create effective, visually attractive, and useful presentations.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Adding Pictures

Inserting a Picture from a File Inserting ClipArt
Using the Picture Tools Tab
Resizing, Moving or Deleting a Picture

Module Three: Working with Text Boxes

Inserting A Text Box
Adding Text
Using the Text Box Tools Tab
Resizing, Moving and Deleting a Text Box Formatting a Text Box

Module Four: Adding SmartArt

Inserting SmartArt
Using the SmartArt Tools Tab
Adding Text to SmartArt
Resizing, Moving and Deleting SmartArt

Module Five: Adding Tables

Inserting a Table
Adding Text
Using the Table Tools Tab Modifying Rows and Columns

Module Six: Inserting Advanced Objects

Adding a Movie
Adding a Sound Clip
Creating WordArt
Drawing Shapes
About the Drawing Tools Tab

Module Seven: Advanced Drawing Tasks

Using the Grid and Guides Rotating and Flipping Objects Aligning and Distributing Objects Ordering Objects
Grouping Objects

Module Eight: PowerPoint’s Research Tools

Checking Spelling
Using the Research Task Pane Using the Translation Tool Setting the Language

Module Nine: Creating Notes and Handouts

Adding Notes to a Slide Creating a Notes Master Creating a Handout Master Printing Notes and Handouts

Module Ten: Using Slide Masters

Switching to Slide Master View Using the Slide Master Tab Creating a Slide Master Applying a Slide Master Editing a Slide Master

Module Eleven: Advanced Presentation Tasks

Inserting Slides from Other Presentations Creating a Custom Show
Packaging Your Presentation for CD About the PowerPoint Viewer

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Project 2007 Advanced

Project is a sophisticated project management software that can help project managers with planning, assigning resources, tracking progress, managing budgets, and analyzing workloads for projects.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Viewing the Project

Using Split Views Sorting Information Grouping Information Filtering Information Using AutoFilters Using Zoom

Module Three: Working with Tasks (I)

Overlapping Tasks Delaying Tasks
Setting Task Deadlines Setting Task Constraints Splitting Tasks

Module Four: Working with Tasks (II)

Understanding Task Type Assigning a Task Calendar Understanding Task Indicators

Module Five: Working with Resources

Assigning a Resource Calendar Delaying Resource Start Time
Applying Predefined Resource Contours Specifying Resource Availability Dates Grouping Resources

Module Six: Working with Costs

Adding Pay Rates for a Resource
Specifying Pay Rates for Different Dates Applying a Different Pay Rate to an Assignment Using Material Resource Consumption Rates Entering Task Fixed Costs

Module Seven: Balancing the Project

Scheduling Resource Overtime
Identifying Resource Over allocation
Balancing Resource Over allocations Manually Balancing Resource Over allocations Automatically

Module Eight: Updating Project Progress

Saving a Baseline Plan
Updating the Entire Project
Updating Task Actual Values
Updating Task Completion Percentage Updating Actual Work
Updating Actual Costs

Module Nine: Checking Project Progress

Viewing Project Statistics Viewing Project Costs
Viewing the Project’s Critical Path Checking Duration Variance Checking Work Variance Checking Cost Variance Identifying Slipped Tasks

Saving an Interim Plan

Module Ten: Working with Reports

Opening a Report
Adding Page Elements to a Report Sorting a Report
Defining Report Contents
Creating a Visual Report

Module Eleven: Working with Multiple Projects

Creating Links Between Projects Consolidating Projects
Viewing Multiple Project Critical Paths Viewing Consolidated Project Statistics Creating a Resource Pool

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Publisher 2007 Advanced

Publisher is one of the Office suite’s hidden gems, offering you the ability to easily create any kind of publication – newsletters, business cards, menus, invitations, and much more! This course will take you through the basics of using Microsoft Publisher 2007. Highlights include setting up your business information, working with color and font schemes, using the new Getting Started Window, and using page masters.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Publisher Tasks

Personalizing Your Publication Tracking Effectiveness
Preparing for Commercial Printing Working with Images

Module Three: Graphics and Objects

Graphics Manager Task Pane Using Design Gallery
Adding Text to a Shape Graphic File Formats and Filters

Module Four: Moving and Grouping Objects

Moving an Object
Group and Ungroup Objects Align or Distribute Objects Send an Object to the Back

Module Five: File Management

Save Files in Other Formats
Save as an XPS File
View or Change Properties
Set or Rename a Default Working Folder

Module Six: Designing and Creating Websites

Planning Your Website
Adding Pages
Converting Print to Web
Compressing Graphic Files Sizes for Websites

Module Seven: Page Layout

Change the Paper Size
Changing Page Size
Scratch Area
Add or Remove Headers and Footers Make an Object Appear on Multiple Pages

Module Eight: Working with Pictures

Wrapping Text Around a Picture Cropping Pictures
Inserting a Picture into an AutoShape Converting Pictures to Watermarks Make Pictures Transparent

Module Nine: Media Files

About Media Files
Adding a File to Microsoft Clip Organizer Add, Change, or Delete Keywords for a Clip Sound and Motion Clips
Animated GIFs

Module Ten: Working With Text

Import Text from a File
Working with Text Box Overflow
Inserting Symbols, Fractions, or Special Characters Set or Change Tab Stops
Insert Date and Time

Module Eleven: Mail, E-mail, and Catalog

Create a Mail Merge
Creating an Address List for a Mail Merge
Creating a Data Source for a Mail Merge
Add Postal Bar Codes to Labels or Envelopes in Publisher

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Visio 2007 Advanced

You may already be creating some basic drawing in Visio. Now it’s time to unleash the full potential of this powerful application for creating diagrams and drawings.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Exploring Advanced Diagrams (I)

Understanding Visio Definitions Creating Calendars
Creating Maps
Flowcharts

Creating Organization Charts Using Perspective

Module Three: Exploring Advanced Diagrams (II)

Network Diagrams
Marketing Diagrams
Create Work Flow Diagrams
Create Fishbone (Cause and Effect) Diagrams Project Management Diagrams
Gantt Charts
PERT Charts

Module Four: Working with Stencils and Shapes

Creating Custom Stencils Saving the Stencil
Adding Shapes to the Stencil Controlling Shape Placement

Module Five: Advanced Custom Shape Design

Creating New Shapes
Revising Existing Shapes Locking and Protecting Shapes

Module Six: Layers (I)

Understanding Layers
Working with Existing Layers The Layer Properties Dialog Box Hiding or Showing a Layer Activating a Layer

Module Seven: Layers (II)

Creating Layers
Renaming and Removing Layers Assigning Shapes to Layers Assigning Color to a Layer Protecting a Layer from Changes Printing Only the Layers You Want

Module Eight: Multi-Page Drawings

Adding Pages to a Drawing Arranging Pages
Working with Background Pages Hyperlinking Between Pages

Module Nine: Creating Technical Layouts

Drawing with Precision
Working with Area Measurement Setting a Drawing Scale
Working with Building Plan Layouts

Module Ten: Working with Data Graphics

About Data Graphics
Using the Data Selector Wizard Applying Data Graphics
Editing Data Graphics

Module Eleven: The ShapeSheet

Viewing the ShapeSheet
Modifying ShapeSheet Data
Using a Formula in the ShapeSheet

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

Word 2007 Advanced

Whether you are a business writer, a marketer, or someone who uses the software for general document creation and handling, the skills included in this course will help you maximize your use of many powerful Word features to create effective, visually attractive, and useful documents.

Outline:

Module One: Getting Started

Icebreaker Housekeeping Items The Parking Lot Workshop Objectives

Module Two: Working with the Word Window

Using Zoom
An Overview of Word’s Views Arranging Windows
Splitting a Document
Using the Document Map

Module Three: Adding Pictures

Inserting Clip Art
Inserting a Picture from a File Using the Picture Tools Tab Moving or Deleting a Picture

Module Four: Adding SmartArt

Inserting SmartArt
Adding Text to SmartArt
Using the SmartArt Tools Tabs Moving and Deleting SmartArt

Module Five: Adding Tables

Inserting a Table
About Quick Tables Adding Text
About the Table Tools Tab Applying a Style

Module Six: Advanced Table Tasks

Resizing Rows and Columns Adding Rows and Columns Deleting Rows and Columns Moving Rows and Columns

Module Seven: Inserting Special Objects

Adding a Cover Page Adding WordArt Drawing Shapes Adding a Text Box

Module Eight: Adding In-Document References

Adding a Table of Contents
Managing Sources
Adding Footnotes, Endnotes, and Citations Inserting a Bibliography
Creating an Index

Module Nine: Advanced Research Tasks

Viewing Synonyms
Using the Research Task Pane Using Translation Screen Tips Setting Your Language

Module Ten: Reviewing a Document

Adding a Comment Reviewing Comments Tracking Changes Reviewing Changes Comparing Documents

Module Eleven: Customizing Word

Minimizing the Ribbon
Customizing the Quick Access Toolbar Accessing Word’s Options
Changing Word’s Color Scheme

Module Twelve: Wrapping Up

Words from the Wise
Review of Parking Lot
Lessons Learned
Completion of Action Plans and Evaluations

error

Enjoy this blog? Please spread the word :)