Business Courses

About the course

Course Fee - £195 Per Delegate

Start date

Duration

Level

Discipline

Location

x

One Day

x

x

x

COURSES   MANAGEMENT

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

Microsoft Office Excel 2016: Advanced

One day workshop

Course Enquiries: 01733 685582

A professional approach for professional people.

Exams and Invoices: 01733 269148