Microsoft Excel 2013/2016 – Intermediate Online

This course has been mapped against the learning outcomes and performance criteria for the Unit of Competency BSBITU314 Design and produce spreadsheets from the Certificate III in Business.

TAKE THE LEAP

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

About this course

The skills and knowledge acquired in Microsoft Excel 2013/2016 – Level 2 enable users to expand their knowledge and learn how to create more productive workbooks.

It covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like goal seeking.

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 – Intermediate Course for face-to-face delivery.

Prerequisites

Microsoft Excel 2013/2016 - Level 2 assumes the learner has the knowledge required to create, edit, print and chart simple worksheets. Understanding ranges and copying is also important.

Learning Outcomes

At the completion of this course you should be able to:

  • use the fill operations available to fill a data series
  • use a range of techniques to work with worksheets
  • apply a variety of page setup techniques
  • apply borders to cells and ranges in a worksheet
  • use common worksheet functions
  • create more complex formulas and functions
  • create and use defined names in a workbook
  • apply a range of number formatting techniques to worksheet cells
  • apply conditional formatting to ranges in a worksheet
  • use goal seeking to determine the values required to reach a desired result
  • understand and use Excel's Quick Analysis tools
  • create and work with tables
  • use a range of elements and features to enhance charts
  • select and change the format of objects in a chart

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: