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.
|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)|
|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"|
Frequency: Every term. Express an interest in future dates for this course.