Course Details and Schedule

Analysing your data across multiple worksheets and workbooks? It couldn't be easier using 3-D referencing. Perhaps you want to collaborate with others? Find out how to protect your workbooks or even lock some areas, to keep the data secure and prevent accidental edits. Want to learn some advanced charting features and how to create histograms? Come along and learn how to do all this and more.

See below for course schedule

Key topics
  • Working with multiple worksheets and workbooks
  • 3-D range functions
  • Advanced charting
  • Using sparklines
  • Creating histograms
  • Securing worksheets and workbooks
Course information
Intended audience Those who have a good understanding of spreadsheets who want to learn some of the more advanced features and functionality
Prior knowledge "Excel: Functions and cell referencing"
Resources A course book must be purchased when you attend the course (included in the Cost below)
Software Excel 2010
Format Presentation with practical exercises
Where next? "Excel: Analysing your spreadsheet data with pivot tables", Excel: Analysing spreadsheet lists, external data and what-if analysis and "Excel: Working with arrays, macros and VBA"
Taught using:
Windows XP

Course provider: IT Learning Programme

Booking normally opens 30 days before the course begins.
Commences Dates Time Sessions Cost Location Status
4th week Wednesday 21 May 09:15-12:15 1 9.00 IT Services, 13 Banbury Road Booking opens April 21st 2014 Email me when booking opens
6th week Thursday 5 June 09:15-12:15 1 9.00 IT Services, 13 Banbury Road Booking opens May 6th 2014 Email me when booking opens

Can't make any of these dates? Express an interest in future dates for this course.

Frequency: Every term.