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 2010 and get the answers to these questions and much more.
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 the "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 |
| Where next? | Excel: Arrays, macros and VBA |
Course provider: IT Learning Programme
Can't make any of these dates? Express an interest in future dates for this course.