You should have completed the Excel Beginner course or be familiar with the basics of Excel. The course is aimed at those familiar with Excel but looking to learn how to get the most out of the in-built features.

• use filling techniques
• 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 popular and common worksheet functions
• create more complex formulas and functions
• use a variety of financial functions
• use the date and time functions to perform calculations

• create and use defined names in a workbook
• apply conditional formatting to ranges in a worksheet
• use goal seeking to determine the values required to reach a desired result
• understand and use Excel’s Quick Analysis tools
• work with tables in Microsoft Excel
• understand and create simple PivotTables
• use a range of elements and features to enhance charts
• select and change the format of objects in a chart
• apply a range of number formatting techniques to worksheet cells