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"|
|9th week||Wednesday 25 June||14:00-17:00||1||9.00||IT Services, 13 Banbury Road||Booking opens May 26th 2014||Email me when booking opens|
Can't make any of these dates? Express an interest in future dates for this course.