Microsoft Excel Intermediate

Share With Your Friends

Dates:

  • March 11 & 13, 5:30 – 8:30 pm
  • May 6 & 8, 2:00 - 5:00 pm

Prerequisites:

Price: $115

Course Outline:

  • Unit 1: Working with large worksheets
    Topic A: Viewing options
    Topic B: Hiding, displaying, and outlining data
    Topic C: Printing large worksheets
  • Unit 2: Using multiple worksheets and workbooks
    Topic A: Using multiple worksheets
    Topic B: Linking worksheets by using 3-D formulas
    Topic C: Consolidating data
    Topic D: Linking workbooks
    Topic E: Managing workbooks
  • Unit 3: Customizing Excel
    Topic A: Using the Options dialog box
    Topic B: Customizing toolbars and menus
  • Unit 4: Advanced formatting
    Topic A: Borders and shading
    Topic B: Using special number formats
    Topic C: Working with dates
    Topic D: Working with styles
    Topic E: Other advanced formatting
  • Unit 5: List management
    Topic A: Examining lists
    Topic B: Sorting and filtering lists
    Topic C: Advanced filtering
  • Unit 6: Advanced charting
    Topic A: Chart formatting options
    Topic B: Using combination charts
    Topic C: Using graphic elements
  • Unit 7: Documenting and auditing
    Topic A: Auditing features
    Topic B: Comments and text boxes
    Topic C: Protection
    Topic D: Workgroup collaboration
  • Unit 8: Using templates
    Topic A: Built-in templates
    Topic B: Creating and managing templates

Register Today!

Business & Industry Training
31 College Drive
Concord, NH 03301-7412
(603) 230-4022
Fax: (603) 230-9304
nhtibtc@ccsnh.edu
Office of Workforce Development