In this course you will learn some of the useful features and functions that take Excel beyond the basic level. You will learn to restructure worksheets, use logical and nested functions, understand relative and absolute referencing, set up conditional formatting. Crucially for building worksheets that are easy to use and reliable to edit, you will define named ranges, cells and constants.
|Intended audience||Those who have a good basic understanding of spreadsheets, who want to learn more advanced functions and techniques to build efficient and easy-to-use spreadsheets|
|Prior knowledge||Experience in Excel that would be gained from attending the "Excel: Fundamentals" course|
|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: 3D formulae, charts and sharing data", "Analysing your spreadsheet data with pivot tables" and "Excel: Analysing spreadsheet lists, external data and what-if analysis"|
Frequency: Every term. Express an interest in future dates for this course.