MS Excel Advanced

Take the next step using Microsoft Excel and teach yourself the advanced functions of the program.

This two-day advanced Microsoft Excel course is perfect for experienced Excel users who want to take their Excel skills to the next level. Microsoft Excel is a tool to be reckoned with at the advanced level.

• 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 and work with scenarios and the Scenario Manager
• understand and create simple PivotTables
• construct and operate PivotTables using some of the more advanced techniques
• create and edit a PivotChart
• use advanced filters to analyse data in a list
• use a variety of data validation techniques
• create and use a range of controls in a worksheet
• share workbooks with other users
• create recorded macros in Excel

*Please note; Short Courses are non-accredited and result in a Certificate of Participation. A non-accredited training course does not count-towards a recognised qualification, but is specially designed to provide hands-on training in a new skill you can use in your personal or professional life, and is a great way to refresh your knowledge or give you a taste of a different industry.