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

• 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.