Microsoft Excel Training - Advanced

The course is for existing users of Excel. You should have completed the Excel Beginner Course and our Excel Intermediate Course or be familiar with the content covered on these courses. The course is aimed at those wishing to move to the next level with Excel with a focus on increasing automation and employing the more advanced tools offered.

• Modify Excel options
• Protect data in worksheets and workbooks
• Import data into Excel and export data from Excel
• Use data linking to create more efficient workbooks
• Group cells and use outlines to manipulate the worksheet
• Create summaries in your spreadsheets using subtotals
• Use the Data Consolidation feature to combine data from several workbooks into one
• Create, use and modify data tables
• Create recorded macros in Excel

• Create and work with scenarios and the Scenario Manager
• Create and edit a PivotChart
• Construct and operate PivotTables using some of the more advanced techniques
• Use advanced filters to analyse data in a list
• Use a variety of data validation techniques
• Use a range of Information functions
• Use a range of text functions
• Create and use a range of controls in a worksheet
• Share workbooks with other users