Want to do some frequency distribution? Then come and learn to use arrays and array formula. 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.
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: Lists and querying data","Excel: Analysing your spreadsheet data with pivot tables", "Excel: 3D formulas, charts, histograms and securing your data" and "Excel: Functions and cell referencing" courses |
| Resources | A course book must be purchased when you attend the course (see the Cost below) |
| Software | Excel 2010 |
| Format | Presentation with practical exercises |
| Further information | Using 2003 or 2007? See our Microsoft Office page |
Course provider: IT Learning Programme
Can't make any of these dates? Express an interest in future dates for this course.