KITS Training and Conference Centre Based in Brighouse West Yorkshire - Courses in IT - MS Excel Introduction Course
 
 

 

 
MS Excel Introduction - Ref: 504/0

VENUE - KITS TRAINING CENTRE

DURATION - ½ DAY

PREREQUISITES - Windows 2000: Basic or equivalent experience

COURSE CONTENT

Getting started

  • Spreadsheet terminology
  • Exploring the Excel window
  • Getting help
  • Opening and navigating workbooks
  • Closing workbooks

Entering and editing data

  • Creating workbooks
  • Entering and editing labels and values
  • Entering and editing formulas
  • Saving and updating workbooks

Modifying a worksheet

  • Moving and copying data
  • Moving and copying formulas
  • Using absolute references
  • Inserting and deleting ranges

Using functions

  • Entering functions
  • Using AutoSum
  • Using AVERAGE, MIN, and MAX

Formatting worksheets

  • Formatting text
  • Formatting rows and columns
  • Number formatting
  • Using Format Painter and AutoFormat

Printing

  • Preparing to print
  • Page Setup options
  • Printing worksheets

Creating charts

  • Chart basics
  • Modifying charts
  • Printing charts

Web features

  • Saving workbooks as Web pages
  • Hyperlinks
  • Sending workbooks via e-mail
 
Interested?
telephone
01484 711462
or
Enquire Online
 
 
 
© KITS 2014 • Charity Reg. No. 507573 • Company Reg. No. 1219838
KITS • Kirkdale Industrial Training Services • Kirkdale House • Armytage Road • Brighouse • West Yorkshire HD6 1QF • Tel: 01484 711462
KITS Site Map
KITS Home Page KITS Home Page