General Description: The skills and knowledge acquired in Microsoft Excel 2016 – Level 3 are sufficient to be able to protect worksheet data, perform advanced data operations using summarising, data consolidations, filters and PivotTables, macros, and much more.

Learning Outcomes: 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

Prerequisites: Microsoft Excel 2016 – Level 3 assumes some knowledge of the software as well as a general understanding of personal computers and the Windows operating system environment.