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

Schedule

Frequency: Every term. Express an interest in future dates for this course.