This one-day course covers features of Excel beyond the basics that many self-taught users are familiar with including charts and sparklines, 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 linking workbooks together
See how to use workspaces to make working with multiple workbooks easier
Learn about the various IF and Lookup functions to help control cell results
Create better and updated charts
Learn to add trend lines and sparklines
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.