Microsoft Excel 2013/2016 – Advanced Online

This course has been mapped against the learning outcomes and performance criteria for the Unit of Competency BSBITU402 Develop and use complex spreadsheets from the Certificate IV in Business.

TAKE THE LEAP

Area of Learning — Microsoft Excel 2013/2016 – Advanced Online

About this course

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.

Successful completion of this course and the required assessments leads to a Statement of Attainment.

Why Study Online?

  • ZERO travel and flexible course delivery; complete this course online from home or at work.
  • Study according to your schedule with 24/7 access to online course content.
  • Fully equipped virtual classrooms. Attend real-time virtual classes with a certified trainer.
  • Participate in interactive learning experiences.
  • Feel supported through your studies with our dedicated Student Support Days to provide one on one guidance.

Rather study face-to-face?

Check out our Microsoft Excel 2013/2016 – Advanced Course for face-to-face delivery.

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.

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

Learning online.

The benefits of a virtual classroom.

Study From Home or at Work
Certified
Trainers
Fully Equipped Virtual Classrooms
Interactive Learning Experiences
Online Student Support

Now is the time to get qualified.

Discover our areas of learning.

Forsythes Training is an established, trusted, quality training provider with an extensive list of corporate clients and individuals who have attended our training courses over the last twenty years in a variety of learning areas: