Microsoft Excel 2007 - Beyond the Basics
This one-day course covers features of Excel beyond the basics that many self-taught users are familiar with, including functions, formatting, print and cell referencing.
Course Outline
- Cells, ranges, and cell range names
- Absolute and relative cell references
- Using multiple worksheets
- Functions - Using the IF and Lookup functions
- Charts and trend lines
- Filtering workbook data and lists
- Subtotalling
Who would benefit from the course?
This course is designed for people who are looking to use more features of their spreadsheet to give their work that extra polished look and functionality.
Pre-requisites
A basic understanding of Excel is required, or attendance at one of our introductory Excel courses.
