Course Details and Schedule

In this course you will learn some of the useful features and functions that take Excel beyond the basic level. You will learn to restructure worksheets, use logical and nested functions, understand relative and absolute referencing, set up conditional formatting. Crucially for building worksheets that are easy to use and reliable to edit, you will define named ranges, cells and constants.

See below for course schedule

Key topics
  • Using arithmetic operators and functions
  • Relative, mixed and absolute referencing
  • IF and other logical functions
  • Introduction to some more advanced functions
  • Working with named ranges and named constants
  • Conditional formatting
  • Solving printing problems
Course information
Intended audience Those who have a good basic understanding of spreadsheets, who want to learn more advanced functions and techniques to build efficient and easy-to-use spreadsheets
Prior knowledge Experience in Excel that would be gained from attending the "Excel: Fundamentals" course
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
Further information Using 2003 or 2007? See our Microsoft Office page
Where next? "Excel: 3D formulae, charts and sharing data", "Analysing your spreadsheet data with pivot tables" and "Excel: Analysing spreadsheet lists, external data and what-if analysis"
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
2nd week Thursday 8 May 09:15-12:15 1 9.00 IT Services, 13 Banbury Road places available Add to basket
3rd week Wednesday 14 May 09:15-12:15 1 9.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.