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 charts, functions, filtering, and cell referencing.
Course Outline
- Learn how to use absolute and relative cell references in formulas
- Cover how to use names for easier formulas
- Learn to create formulas that use multiple worksheets
- Learn about the various IF and Lookup functions to help control cell results
- Create better and updated charts
- Learn to add trend lines
- See how to filter workbook data and lists
- Learn to incorporate 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.
