Course Details and Schedule

Analyzing your data across multiple worksheets and workbooks? It couldn't be easier using 3-D referencing. Perhaps you want to collaborate with others? It's easy to share workbooks with multiple users with the owner able to maintain control, resolve conflicts and keep the data secure. 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
  • Collaboration using shared workbooks
Course information
Intended audienceThose 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"
ResourcesA course book and text book must be purchased when you attend the course (see the Cost below)
SoftwareExcel 2010
FormatPresentation with practical exercises
Where next?"Excel: Analysing your spreadsheet data with pivot tables", Excel: Lists and querying data and "Excel: Arrays, macros and VBA"
Taught using: 
Windows XP

 Course provider: IT Learning Programme

Schedule
Booking normally opens 30 days before the course begins.
Commences Dates Time Sessions Cost Location Status
5th week Monday 20 May 14:00-17:00 1 6.00 IT Services, 13 Banbury Road places available Add to basket
8th week Thursday 13 June 14:00-17:00 1 6.00 IT Services, 13 Banbury Road places available Add to basket

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

Frequency: Every term.