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

Leave a Reply