Excel 2016 Advanced

Course Outline

Download Full Course Outline (PDF)(PDF, 1MB)

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.

 

Book Now(PDF, 936KB)

Upcoming Dates:

Call us to discuss (07) 3000 2148

Course Summary

RTO
Excel 2016 Advanced
Course Length
1 Day
Course Type
Tagged as:  Short Courses
Location
Please contact us about your requirements.
Online delivery options available
Fees and Inclusions
Please contact us for course fees or a proposal

Contact Us


Please contact Peak Services for course fees or a proposal for onsite/in-house training.

Register Now
07 3000 2148

Find Out More
training@wearepeak.com.au
peakservices.com.au

Back to top