none

Outlook 2010 Essentials

by | Jun 28, 2020

Workshop Objectives

Research has consistently demonstrated that when clear goals are associated with learning, it occurs more easily and rapidly. 
By the end of this workshop, you should be able to:
  • Open and close Outlook
  • Use the Outlook Interface, including the new Backstage view
  • Set up an e-mail account
  • View the Inbox
  • Send and Receive messages
  • View messages
  • Use Quick Steps
  • Reply to or forward messages
  • Delete e-mail
  • Ignore e-mail
  • Create and send a new message 
  • Address a new message
  • Create the body of an e-mail message
  • Attach files to messages
  • Mark an item as Read or Unread
  • Print messages
  • Create folders and use them to organize messages
  • Understand and handle Junk Mail
  • Create Rules for handling messages
  • Use Categories 
  • Flag items for follow-up

PowerPoint 2010 Advanced

by | Jun 28, 2020

Workshop Objectives

Research has consistently demonstrated that when clear goals are associated with learning, it occurs more easily and rapidly. 
By the end of this workshop, you should be able to:
  • Insert a picture
  • Insert screen shots
  • Insert clip art
  • Insert SmartArt
  • Insert a text box and add text
  • Insert a Table and add text
  • Resize, move, and delete a picture, text box, or SmartArt
  • Remove a picture’s background
  • Use the Picture Tools tab
  • Use the Text Box Tools tab
  • Use the SmartArt Tools tab
  • Use the Table Tools tab
  • Format a text box
  • Modify table rows and columns
  • Format a table
  • Add a movie
  • Add a sound clip
  • Create WordArt
  • Draw shapes
  • Use the Drawing Tools tab
  • Use the Grid and Gridlines
  • Rotate and flip objects
  • Align and distribute objects
  • Order objects
  • Group objects
  • Check spelling
  • Use the Research Task pane
  • Use Translation ScreenTips 
  • Set the Language
  • Add Notes to Slides
  • Create a Notes Master
  • Create a Handout Master
  • Print Notes and Handouts
  • Switch to the Slide Master View

Project 2010 Advanced

by | Jun 28, 2020

Workshop Objectives

Research has consistently demonstrated that when clear goals are associated with learning, it occurs more easily and rapidly. 
By the end of this workshop, participants should be able to:
  • Split the view
  • Sort, group, and filter tasks
  • Use zoom
  • Overlap, delay, or split tasks
  • Set task deadlines and constraints
  • Understand task types
  • Assign a task calendar
  • Understand task indicators
  • Assign a resource calendar
  • Customize a resource calendar
  • Apply predefined resource contours
  • Specify resource availability
  • Group resources
  • Enter resource rates and overtime rates
  • Specify pay rates for different dates
  • Apply a different pay rate to an assignment
  • Use material resource consumption rates

Excel 2010 Essentials

by | Jun 28, 2020

Workshop Objectives

Research has consistently demonstrated that when clear goals are associated with learning, it occurs more easily and rapidly. 
By the end of this workshop, you should be able to:
  • Open and close Excel
  • Differentiate between worksheets, workbooks, rows, columns, and cells
  • Understand the new Interface and the new Backstage View
  • Enter labels and values
  • Edit data
  • Add rows and columns
  • Check spelling
  • Open, close, and save workbooks (including publishing to PDF and sending via E-mail)
  • Switch between Excel views and create custom views
  • Use Zoom
  • Set up, Preview and print your workbook
  • Build, copy and edit formulas
  • Use absolute referencing appropriately
  • Understand the difference between Formulas and Functions
  • Understand the new Function Names
  • Use the Formulas Tab
  • Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
  • Use the status bar to perform calculations
  • Use AutoFill and AutoComplete
  • Sort and filter data
  • Use sparklines

InfoPath 2010 Advanced

by | Jun 28, 2020

Workshop Objectives

Research has consistently demonstrated that when clear goals are associated with learning, it occurs more easily and rapidly. 
By the end of this workshop, participants should be able to:

  • Understand various types of controls
  • Validate form data
  • Import designs from Word or Excel
  • Create cascading drop down lists
  • Work with forms that can be merged
  • Add resource files to your form template
  • Understand InfoPath Form Events
  • Manage data connections
  • Publish in various types of forms