The skills and knowledge acquired in this Microsoft Excel Intermediate Course enable users to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function techniques, database tables, pivot tables, advanced formatting and charting features and data manipulation tools like goal seeking.

In this course you will learn:

At the completion of this course you should be able to:

• Use the fill operations available to fill a data series
• Use a range of techniques to work with worksheets
• Apply a variety of page setup techniques
• Apply borders to cells and ranges in a worksheet
• Use common worksheet functions
• Create more complex formulas and functions
• Create and use defined names in a workbook
• Create and use tables
• Apply a range of number formatting techniques to worksheet cells
• Apply conditional formatting to ranges in a worksheet
• Create and use Pivot tables
• Use goal seeking to determine the values required to reach a desired result

What to bring:

• Pen
• Paper

Other Information:

• To ensure resources are ready for you at the start of your course, we ask you ideally enrol at least one week before the course commences.
• All courses need a minimum number of students to run ("we try our hardest to get those") . If your course does not have enough students it will be cancelled before the commencement and you will be informed.