Excel 2016 - Level 3

Join 252 students who already love this course!

(4.24 out of 5 )

1 Day $470

This course builds off the knowledge presented in the Microsoft® Office Excel® 2016: Parts 1 & 2 courses to help you get the most of your Excel experience. This course covers Microsoft Office Specialist exam objectives to help students prep for the exam.

  • Topic A: Use Links and External References
  • Topic B: Use 3-D References
  • Topic C: Consolidate Data
  • Topic A: Use Lookup Functions
  • Topic B: Trace Cells
  • Topic C: Watch and Evaluate Formulas
  • Topic A: Collaborate on a Workbook
  • Topic B: Protect Worksheets and Workbooks
  • Topic A: Apply Data Validation
  • Topic B: Search for Invalid Data and Formulas with Errors
  • Topic C: Work with Macros
  • Topic A: Create Sparklines
  • Topic B: Map Data
  • Topic A: Determine Potential Outcomes Using Data Tables
  • Topic B: Determine Potential Outcomes Using Scenarios
  • Topic C: Use the Goal Seek Feature
  • Topic D: Forecasting Data Trends
This course builds off the knowledge presented in the Microsoft® Office Excel® 2016: Parts 1 & 2 courses to help you get the most of your Excel experience. This course covers Microsoft Office Specialist exam objectives to help students prep for the exam.
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.