In this course you will learn some of the more advanced features and functions in Excel. At the end of the course you will be able to apply your new skills to restructure worksheets, use logical and nested functions with relative and absolute referencing, conditional formatting and defining and using named ranges in functions and formula.
Course information
| Intended audience | Those who have a good basic understanding of spreadsheets who want to learn more advanced functions and techniques to improve their spreadsheet skills |
| 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 (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? | "Analysing your spreadsheet data with pivot tables", "Excel: Lists and querying data" and "Excel: 3D formulas, charts, histograms and securing your data" |
Course provider: IT Learning Programme
Can't make any of these dates? Express an interest in future dates for this course.