Don't just take our word for it

We ask all our past delegates to rate our courses so you can decide if this course is really right for you - just click 'Hear what people say' to read ratings. If you've been on a course, log in to 'My Reed Learning' and leave your review to help others decide.

Intermediate Microsoft Excel XP/2003 Course

  • Duration:1 Day
  • Cost:£199 + VAT
  • Ref:MIDEXP

Expand your knowledge of MS Excel with this course.

Book now >

Cost £199.00 Duration 1 day Code MIDEXP

Course rating:

(3  votes)

What's this?

  • Hear what people say
  • Send to a friend
  • Add to favourites

Who is it for

Suitable for people who have attended the introduction course or have sufficient knowledge and understanding of the basics of Excel and are looking to expand this. Please note this course is suitable for delegates using Windows XP or 2000 versions - delegates with Vista might like to try Intermediate Excel 2007. Not sure if this level is right for you? Why not take our short online test to check >

Prerequisites
A working knowledge of Excel introduction topics or attendance to our Introduction to Excel course.

What is it about

A natural progression from our introductory courses that provides expert guidance through more complex functions and plenty of practice and examples to build confidence using them. 

Course Overview

  • Review of Excel fundamentals
  • Building 3-dimensional worksheets
  • Worksheet templates
  • Protection and security
  • Grouping worksheets 
  • Data tables and lookup functions
  • Introduction to the ‘If’ function 
  • Group and outline functions 
  • Building graphs and using trend lines 
  • Database features including sorting and filtering data 
  • Methods to validate data
  • Colours based on values (getting Excel to change the formatting characteristics based on the cell contents)

What will I get out of it?

  • Know how to protect your data using the security features
  • Achieve automation of worksheets using excel look up features
  • Improved interpretation of data by learning to create and customise graphs, including plotting trend lines
  • Learn how Excel can make decisions using the ‘If’ function and conditional formatting

Accredited by

This course is accredited for CPD

  • Hear what people say
  • Send to a friend
  • Add to favourites

Intermerdiate Microsoft Excel brochure

Download brochure

Read more about Intermediate Microsoft Excel:

Download our latest brochure

View more brochures

What's new this month >