Classroom Management

IT02 Intermediate Spreadsheeting

This intensive and hands on course is aimed at the teacher who has a good grasp of how to use a spreadsheet in various contexts but who feels the need to learn more.

This is an interactive day: following the introduction to each section, delegates will be given activities to work on to ensure they have grasped the materials. In some cases trainer and delegate will work in parallel with delegates following instructions live, step by step from what happens on the screen.

Delegates will take away with them fully worked solutions to all exercises in fully formatted and documented spreadsheet files.

The 2008 dates and venues have yet to be finalised for this course. Please return to our Course Subjects page.

Objectives

By the end of this course, delegates will be able to
  • Use named formulae, cells and ranges
  • Format cells by using in built styles, auto formatting and background images
  • Program relatively complex formulae including nested IF statements, using ISERROR and ISNA, CONCATENATION to help them to carry out a wide variety of calculations
  • Work with dates and times
  • Use LOOKUP, VLOOKUP and HLOOKUP functions to find and use data and other information
  • Use graphs to manipulate data and make forecasts
  • Work with lists including filtering, sorting and creating sub totals
  • Use PIVOT TABLES to analyse and manipulate data
  • Appreciate the basic rules of spreadsheet layout
  • Appreciate the need to document all spreadsheets
  • Use many keyboard short cuts

Who should attend

This course is aimed at the teacher who needs an updating or refresher course on the modern spreadsheet: teachers who recognise the need to use spreadsheets but who don't have the knowledge and confidence to do so.

Agenda

09.00 - 09.30
  • Arrival and registration
09.30 - 10.30 - Session 1:
  • Use named formulae, cells and ranges
  • Format cells by using in built styles, auto formatting and background images
10.30 - 10.45
  • Coffee
10.45 - 11.45 - Session 2:
  • Program relatively complex formulae including nested IF statements, using ISERROR and ISNA, CONCATENATION to help them to carry out a wide variety of calculations
11.45 - 12.00 - Session 3:
  • Work with dates and times
12.00 - 12.45
  • Lunch
12.45 - 13.30 - Session 3:
  • Use LOOKUP, VLOOKUP and HLOOKUP functions to find and use data and other information
13.30 - 15.30 - Session 4:
  • Use graphs to manipulate data and make forecasts
  • Work with lists including filtering, sorting and creating sub totals
  • Use PIVOT TABLES to analyse and manipulate data
15.00 - 16.16
  • Any questions?
Throughout:
  • Appreciate the basic rules of spreadsheet layout
  • Appreciate the need to document all spreadsheets
  • Use many keyboard short cuts