Course Details and Schedule

Want to do some frequency distribution? Then come and learn to use arrays and array formulae. Want to learn to create dynamic charts that update automatically as you add rows of data? Not easy, but you'll learn how on this course. Do those repeated tasks bore you? Automate the process with macros. Now you've mastered macros learn to change the macro with code and VBA.

See below for course schedule

Key topics
  • Arrays and array formulae
  • Consolidating data in workbooks
  • Useful advanced functions
  • Dynamic charting
  • Creating macros
  • Introduction to VBA programming
Course information
Intended audience Those who have a very good understanding of spreadsheets who want to learn more advanced features and functionality.
Prior knowledge Previous experience in Excel: this course is not for beginners. Knowledge of Excel that would be gained from attending the "Excel: Analysing spreadsheet lists, external data and what-if analysis","Excel: Analysing your spreadsheet data with pivot tables", "Excel: 3D formulae, charts and sharing data" and "Excel: Functions and cell referencing" courses
Software Excel 2010
Format Presentation with practical exercises
Further information Using 2003 or 2007? See our Microsoft Office page
Taught using:
Windows XP

Course provider: IT Learning Programme


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