none

Word 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:
  • Use Zoom
  • Understand Word Views
  • Split a Document
  • Use the Navigation Pane
  • Insert ClipArt, Pictures from Files, and Screen Shots
  • Move or Delete a Picture
  • Use the Picture Tools Tab
  • Remove a Picture’s Background
  • Adding Artistic Effects
  • Changing a Picture’s Layout
  • Use SmartArt
  • Work with Tables
  • Use the Table Tools Tab
  • Apply a Style to a Table
  • Add a Cover Page
  • Add Word Art
  • Draw Shapes
  • Add a Text Box
  • Add a Table of Contents
  • Manage Sources
  • Add Footnotes, Endnotes, and Citations
  • Insert a Bibliography
  • Create an Index
  • View Synonyms
  • Use the Research Task Pane
  • Use Translation ScreenTips
  • Set Your Language
  • Use Comments
  • Track and Review Changes
  • Compare Documents
  • Minimize the Ribbon
  • Customize the Quick Access Toolbar
  • Access Word Options

Publisher 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:
  • Import text from another file
  • Work with Text Box Overflow
  • Use special characters
  • Work with tab stops
  • Insert the date and time
  • Convert pictures to watermarks
  • Make pictures transparent
  • Use the Graphics Manager Task Pane
  • Move, group, ungroup, align, distribute and order objects
  • Add an object for multiple pages
  • Use sound and motion clips with keywords
  • Use animated gifs
  • Create a data source, and address list and a mail merge
  • Track the effectiveness of marketing materials
  • Add postal bar codes to labels or envelopes
  • Create a catalog
  • Use the Design Checker to check for publication errors
  • Set Commercial Print Information
  • Send files via email
  • Save files as different formats, including XPS
  • Use the Pack and Go Wizard to prepare a publication for commercial printing

Visio 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 advanced Visio definitions
  • Create new drawings using a variety of templates
  • Create and save a custom stencil
  • Control shape placement on a drawing
  • Use Quick Shapes
  • Lock and protect shapes
  • Understand the Layer Properties dialog box
  • Activate a layer
  • Assign color to a layer
  • Add pages to a drawing
  • Hyperlink between pages
  • View area measurements
  • Work with a Building Plan layout
  • Understand how to use data with your drawings
  • Modify ShapeSheet data
  • Use a formula in the ShapeSheet

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