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

Schedule

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