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.
|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, histograms and sharing data" and "Excel: Functions and cell referencing" courses|
|Format||Presentation with practical exercises|
|Further information||Using 2003 or 2007? See our Microsoft Office page|
Frequency: Every term. Express an interest in future dates for this course.