none

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

InfoPath 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, participants will be able to:
  • Open and close InfoPath
  • Use InfoPath’s Available Form Templates window and the interface
  • Add rules to customized forms
  • Explain XML at a high level
  • Use InfoPath Filler 2010 to fill out forms
  • Design a form from scratch using Microsoft InfoPath Design 2010
  • Work with InfoPath tables
  • Create field labels
  • Add and modify basic controls, including picture and file attachments
  • Understand what advanced control  types can be used for
  • Format controls
  • Add data validation and conditional formatting rules to controls
  • Use the Logic Inspector and Design Checker
  • View and modify data sources, fields, and groups
  • Manually bind controls to a data source
  • Create, modify, and delete InfoPath views
  • Change the color scheme of a form
  • Check spelling
  • Preview and test a form
  • Protect a form
  • Publish or print a form

OneNote 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:
  • Understand the file and organization changes when upgrading from OneNote 2007
  • Know the new features in OneNote 2010
  • Stay organized by using the Navigation bar and drag and drop capabilities
  • Sort and view pages
  • Work with Page Versions
  • Create hyperlinks to web locations, other files, or other OneNote pages
  • Use the Translator tools
  • Use tables
  • Understand the calculator capabilities
  • Work with Equations
  • Format text using the Mini Tool bar
  • Select a page template for a new page
  • Select a default page template
  • Create a new template
  • Understand the use of the drawing and pen tools
  • Understand how OneNote works on a Tablet PC
  • Create a custom pen to use when drawing or handwriting
  • Specify a pen as drawing or handwriting
  • Convert ink to text 
  • Attach files to notes pages
  • Insert Files as Printouts
  • Use scanned pages
  • Print to OneNote from Other Applications
  • Send to Word and other formats
  • Use the Side Note Window
  • Send Web Pages to OneNote
  • Use the Research task pane