Microsoft Excel (Intermediate/Advanced)

Length: 1/2 Day

Audience: All employees

Intermediate

  • Using Illustrations, Styles & Themes
  • Inserting & Formatting Pictures & Text Boxes
  • Inserting & Formatting Links
  • Creating & Formatting Tables & Charts
  • Formulas & Functions
  • Absolute & Mixed References
  • Logical Functions & Values
  • Filter/Sort Date

 

Advanced

  • Pivot Table
  • Macro Recording
  • Freeze Panes
  • References, Mail Merges & Forms
  • Spell Check & the Thesaurus
  • Commenting
  • Protecting & Reviewing Worksheets/Workbooks
  • Sharing & Collaborating on Worksheets/Workbooks

 

Materials/AV Required:
Students will need a computer and access to Microsoft Excel. The training can be provided on any version.

Facilitator: Don MacDonald - Holland College