Description
At Course Completion
After completing this course, students will 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.
