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 Basics (Spreadsheets) - $125

 
Dates:
  • July 14 & 16, 9:00 - 12:00 Noon
  • September 22 & 24, 9 - 12:00 Noon
  • October 13 & 15, 5:30 - 8:30 pm
  • November 12 & 14, 1:00 - 4:00 pm
Prerequisites:
Course Outline:
  • Unit 1: Getting started
    Topic A: Spreadsheet terminology
    Topic B: Exploring the Excel window
    Topic C: Getting help

  • Unit 2: Entering and editing data
    Topic A: Creating workbooks
    Topic B: Entering and editing labels and values
    Topic C: Entering and editing formulas
    Topic D: Saving and updating workbooks

  • Unit 3: Modifying a worksheet
    Topic A: Moving and copying data
    Topic B: Moving and copying formulas
    Topic C: Using absolute references
    Topic D: Inserting and deleting ranges

  • Unit 4: Using functions
    Topic A: Entering functions
    Topic B: Using AutoSum
    Topic C: Using AVERAGE, MIN, and MAX

  • Unit 5: Formatting worksheets
    Topic A: Formatting text
    Topic B: Formatting rows and columns
    Topic C: Number formatting

  • Unit 6: Printing
    Topic A: Preparing to print
    Topic B: Page Setup options
    Topic C: Printing worksheets

  • Unit 7: Creating charts
    Topic A: Chart basics
    Topic B: Modifying charts
    Topic C: Printing charts
 
Register Today!