Excel 2016 - Level 2

Join 474 students who already love this course!

(4.25 out of 5 )

1 Day $470

This course builds upon the knowledge presented in the Microsoft® Office Excel® 2016: Level 1 course and helps start students down the road to creating advanced workbooks & worksheets that can help deepen their understanding.

  • Topic A: Work with Ranges
  • Topic B: Use Specialised Functions
  • Topic C: Work with Logical Functions
  • Topic D: Work with Date & Time Functions
  • Topic E: Work with Text Functions
  • Topic A: Sort Data
  • Topic B: Filter Data
  • Topic C: Query Data with Database Functions
  • Topic D: Outline and Subtotal Data
  • Topic A: Create and Modify Tables
  • Topic B: Apply Intermediate Conditional Formatting
  • Topic C: Apply Advanced Conditional Formatting
  • Topic A: Create Charts
  • Topic B: Modify and Format Charts
  • Topic C: Use Advanced Chart Features
  • Topic A: Create a PivotTable
  • Topic B: Analyse PivotTable Data
  • Topic C: Present Data with PivotCharts
  • Topic D: Filter Data by Using Timelines and Slicers
This course is designed for students who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyse and present data.
INSTRUCTORS
Kate Davis

With over 10 years of experience, Kate is one of New Horizons most ...

Magdalena Todor

With over 20 years experience as a facilitator and university ...

Alice Antonsen

Alice is one of New Horizons’ most experienced Desktop ...

Ben Kirk

With over 16 years of experience working as a Desktop Applications ...

Keith Ching

At New Horizons Keith delivers Microsoft Office, Sharepoint and ...

Matthew Goodall

Matthew is a qualified Microsoft Office Specialist, Microsoft ...


REGISTER NOW
top

OLLAnywhere is a revolutionary way of utilising cutting-edge technology to allow students to attend live instructor-led training from anywhere in or outside of Australia.