Corporate Training for Teams
5.0 (3 Reviews)

Excel Level 2 (In-House)

Length
1 day
Price
360 GBP excl. VAT
Next course start
Enquire for more information See details
Course delivery
Virtual Classroom
Length
1 day
Price
360 GBP excl. VAT
Next course start
Enquire for more information See details
Course delivery
Virtual Classroom
Leave your details so the provider can get in touch

Course description

Excel Level 2 (In-House)

This course is for anyone who wants to gain an advanced skill set necessary for calculating data using functions and formulas, sorting and filtering data, creating PivotTables to analyse data and customising workbooks.

Upcoming start dates

1 start date available

Enquire for more information

  • Virtual Classroom
  • Online

Suitability - Who should attend?

Pre-Requisites

Before starting this course, it is recommended that you take the Microsoft Office Excel Level 1 course

Outcome / Qualification etc.

  • You will use advanced formulas and work with various tools to analyse data in spreadsheets.
  • You will also organise table data and present data as charts to enhance the look and appeal of workbooks.

Training Course Content

Introduction & Workshop Objectives

Lesson 1: Calculating Data with Advanced Formulas

  • Apply Cell and Range Names
  • Calculate Data across Worksheets
  • Use Specialised Functions
  • Concatenate, Proper, Left and Right
  • Analyse Data with Logical and Lookup Functions
  • If, SumIf, CountIf and Vlookup

Lesson 2: Organising Worksheet and Table Data

  • Create and Modify Tables
  • Format Tables
  • Sort and or Filter Data
  • Use Functions to Calculate Data

Lesson 3: Presenting Data using Charts

  • Create a Chart
  • Modify a Chart
  • Format a Chart

Lesson 4: Analysing Data using PivotTables,

Slicers and PivotCharts

  • Create a PivotTable Report
  • Filter Data using Slicers
  • Analyse Data using PivotCharts

Lesson 5: Customising and Enhancing the Excel Environment

  • Customise the Excel Environment
  • Customise Workbooks
  • Manage Themes
  • Create and Use a Template

Why choose GBC Learning & Development

Established in 1994 and still learning!

Trusted by 400 world-wide

Save! Bring a Buddy Half Price

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Reviews

Average rating 5

Based on 3 reviews.
Reviews are published according to our review policy.
Write a review!
5/5
J D
24 Nov 2021
A great days training

A fantastic trainer, very well prepared, fantastic interpersonal skills, very direct and confident – exactly the type of trainer you need for this type of course – leading us by...

Show more
5/5
Anonymous
08 Jun 2018
Enjoyable and informative

Very enjoyable and informative gained understanding of myself and others.

5/5
Anonymous
08 Jun 2018
Learnt a lot of usefull information

Was very good, learnt a lot of usefull information.

Expenses

Course Price: £360 + VAT

Request info

Contact form

Fill out your details to find out more about Excel Level 2 (In-House).

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
GBC Learning & Development
Salisbury House
EC2M 5QQ London Wall

GBC Learning & Development – Invest for High Performing People

Practical yet inspiring topics, comprehensive content, and passionate trainers. Tap into the expertise of our trainers who have a wealth of experience in business, coupled with an understanding of how people learn and put their learning into practice in the...

Read more and show all courses with this provider

Ads