Course Details and Schedule

How do you filter, summarise and subtotal large lists of data? On this course you will learn all about advanced filtering, database and other advanced functions to answer the question. Want to do some "what-if analysis"? Want to find out how to create dynamic models that instantly recalculate when related cell values change? How do you analyse external data? Come and learn to use some of the more advanced tools in Excel and get the answers to these questions and much more.

See below for course schedule

Key topics
  • Filtering, subtotalling and computed criteria
  • Advanced functions
  • Database functions
  • Working with external data
  • What-if analysis
  • Two-input tables
  • Goal seek and Solver
Course information
Intended audience Those who have a good understanding of spreadsheets who want to learn some of the more advanced features and functionality.
Prior knowledge Experience in Excel that would be gained from attending these courses: "Excel: Functions and cell referencing" and "Excel: 3D formulae, charts and sharing data"
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: Analysing your spreadsheet data with pivot tables" and "Excel: Working with arrays, macros and VBA"
Taught using:
Windows XP

Course provider: IT Learning Programme


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