Training

Microsoft Excel Intermediate.

About This Course

Course Code
QAEXITMC

Course Type
Performance

Vendor
Microsoft

Duration
2 Days

RRP
£890.00

Course Overview
Download

Special Notices

Please note that this course uses Microsoft Excel for Windows. It is not suitable for Excel for MAC. Courses for MAC users are available on request

For customers attending remotely via Virtual Classroom or ‘Attend From Anywhere’, an additional screen is required for this course to work through remote desktop labs and view training information.

This course is suitable for anyone using Excel 2013 or later. If delivered in a Nexus training centre, it will be delivered using Excel 2019.

Overview

The goal of this course is to provide you with the knowledge required to use more advanced formulas and work with various tools to analyse data in spreadsheets, such as sorting, filtering, conditional formatting and auditing. You will also organise table data and present data as charts.

The course emphasises hands-on experience, with a series of self-guided exercises integrated into the training.

Objectives

Course Outline

Module 1: Formulas

Module 2: The Auditing tools

Module 3: Working with data lists

Module 4: Filtering data lists

Module 5: Mastering Excel tables

Module 6: Charts

Module 7: Additional features

Module 8: Conditional formatting

Prerequisites

This course is aimed at existing Excel users who need to further their knowledge. Delegates are assumed to have experience of entering data and writing basic formulas, including common functions such as SUM and AVERAGE.

Dates & Prices

Tuesday 31st August 2021

£890.00

Thursday 9th September 2021

£890.00

Monday 20th September 2021

£890.00

Monday 11th October 2021

£890.00

Monday 25th October 2021

£890.00

Thursday 4th November 2021

£890.00

Monday 8th November 2021

£890.00

Thursday 9th December 2021

£890.00

Monday 20th December 2021

£890.00