Excel 2016 Advanced

Solab

Training

In Aberdeen

£ 210 + VAT

The best Excel courses

See all

See all

Description

  • Type

    Training

  • Location

    Aberdeen (Scotland)

  • Duration

    1 Day

  • Start date

    July

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.

1-Day Instructor-led classroom based training.

Excel 2016 Advanced can be delivered as a scheduled open course, a company private closed course or as a one to one consultancy. We can run this course either at our training centre in Aberdeen, your premises or using our portable training school.

Facilities

Location

Start date

Aberdeen (Aberdeenshire)
See map
56-58 Bridge Street, Bridge House, AB116JN

Start date

JulyEnrolment now open

About this course

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Microsoft excel training
  • MS Excel
  • Microsoft Excel
  • Microsoft Excel 2016
  • Excel 2016
  • Visual Basic Editor
  • Pivot charts
  • Track Changes
  • Charts
  • Advanced

Course programme

EXCEL 2016 ADVANCED


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

At the completion of this course you will be able to:
  • nest Functions (place a function as an argument of another function)
  • use new functions such as IFS, SWITCH, TEXTJOIN and CONCAT
  • audit functions to identify errors
  • create tables to manage large amounts of data
  • create, edit and format Pivot Tables to summarise, analyse and report on data
  • create Pivot Charts
  • record Macros and edit recorded code in the Visual Basic Editor
  • restrict user data entry using Data Validation
  • share a workbook for multiple editors and enable Track Changes.

SUMMARY

Module 1: Nest Functions
Module 2: New Functions
Module 3: Audit Functions
Module 4: Tables
Module 5: Pivot Tables
Module 6: Pivot Charts
Module 7: Macros
Module 8: Data Validation
Module 9: Sharing and Tracking

See related categories

Excel 2016 Advanced

£ 210 + VAT

The best Excel courses

See all

See all