Microsoft Office Excel 2016: Advanced

Home » Courses » Management Skills Training » Microsoft Office Excel 2016: Advanced

Microsoft Office Excel 2016: Advanced

Accountancy Training

About the course

Objectives: You will use advanced formulas and functions, and work with various tools to analyse data in spreadsheets finding solutions to business problems. You will also organise table data and present data as charts.

Designed for: This course is meant for those desiring to gain the advanced Excel skills necessary for calculating data, using functions and formulas, filtering and sorting data, using Pivot Tables and Pivot Charts to analyse data and find solutions to business problems.

Prerequisites: Before starting this course, learners are recommended to take Microsoft Office Excel 2016: Beginner

Course Content: Creating Advanced Formulas

  • Analysing Data with Logical and Lookup Functions
  • Organising Worksheet Data with Tables
  • Visualising Data with Charts
  • Analysing Data with Pivot Tables, Slicers, and Pivot Charts
  • Enhancing Workbooks
Course Fee

£195 Per Delegate

Start Date:
Duration:
– One Day
Level:

Discipline:

Location:

Enquire

  • Select Course
  • (AAT) Essentials: Finance for Non-Finance Managers
  • (AAT) Essentials: Budgeting for the Small
  • Microsoft Office Excel 2016: Beginner
  • Microsoft Office Excel 2016: Advanced
  • CPD Short Courses
  • Payment Method
  • I am paying myself
  • My employer is paying
  • Advanced Learning Loan
  • I am eligible for fee remission