Concord Banner
                     

NHTI Business & Industry Training
31 College Drive
Concord, NH 03301-7412
(603) 271-6663
Fax: (603) 271-6667
nhtibtc@ccsnh.edu

NHTI Logo

Excel Intermediate - $125

 
Dates:
  • July 22 & 24, 5:30 - 8:30 pm
  • August 4 & 6, 9:00 - 12:00 Noon
  • October 8 & 10, 9:00 - 12:00 Noon
  • November 17 & 19, 5:30 - 8:30 pm
  • December 8 & 10, 1:00 - 4:00 pm
Prerequisites:
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!