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.

Learn how to:

• Use absolute and relative cell references in formulas
• Use names for easier formulas
• Create formulas that use multiple worksheets
• Link workbooks together
• Use workspaces to make working with multiple workbooks easier
• Use the various IF and Lookup functions to help control cell results
• Create better and updated charts
• Add trend lines
• Filter workbook data and lists
• 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.