Course Outline
Download Full Course Outline (PDF)Who should Attend?
The skills and knowledge acquired in Microsoft Excel 2016 - Advanced 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
Expand their skills and knowledge in using Microsoft Excel in order to apply more complex formulas, functions along with other more advance level uses of Microsoft Excel 2016.
Short Course details
| Short Course Topics | |
|---|---|
| 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 | |
| Delivery | |
| This course is delivered as a face-to-face instructor led training sessions. Our courses can be customised to suit your particular requirements. | |
| Duration & location | |
| Our standard structure for this course is 1 full day and can be delivered in any metropolitan or regional area of Queensland. | |
| Fees & Inclusions | |
| Please contact Peak Services for course fees or a proposal for onsite/in-house training. | |
Upcoming Dates:
3 September 2024, 9am-3pm
Virtual Classroom (Inhouse delivery is also available)