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

 

 
MS Excel Intermediate - Ref: 505/0

VENUE - KITS TRAINING CENTRE

DURATION - 1 DAY

PREREQUISITES - Excel 2003 Introductory Course

COURSE CONTENT

Large worksheets

  • Viewing options
  • Hiding, displaying, and outlining data
  • Printing large worksheets

Multiple worksheets/workbooks

  • Using multiple worksheets
  • Linking worksheets by using 3-D formulas
  • Consolidating data
  • Linking workbooks
  • Managing workbooks

Customizing Excel

  • Using the Options dialog box
  • Customizing toolbars and menus

Advanced Formatting

  • Borders and shading
  • Using special number formats
  • Working with dates
  • Working with styles
  • Other advanced formatting

List management

  • Examining lists
  • Sorting and filtering lists
  • Advanced filtering

Advanced charting

  • Chart formatting options
  • Using combination charts
  • Using graphic elements

Documenting and auditing

  • Auditing features
  • Comments and text boxes
  • Protection
  • Workgroup collaboration

Using templates

  • Built-in templates
  • Creating and managing templates
 
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