Excel - Level 2

SquareOne Training
Course summary
Length: 2 days
Price: 185 - 350 GBP excl. VAT
Language: English
Course type: Open / Scheduled
Next available date: 06/11/2017 09:00 - Liverpool
Course Dates
06/11/2017 09:00  (English)
350 GBP
11/12/2017 09:00  (English)
330 GBP
11/12/2017 09:00  (English)
350 GBP
18/12/2017 09:00  (English)
185 GBP
Contact us for future dates  (English)

Course Description

This Level 2 Excel training course is offered as an open/scheduled 2-day workshop by SquareOne Training. The course is designed to show delegates how to improve their understanding of Excel and produce powerful well presented spreadsheet models. This training course is also suitable for existing users of Excel who have recently upgraded. The course follows on from the Level 1 course and is full of shortcuts and tips.

Our patient and dedicated trainers will help all users gain the skills needed to start working confidently on Windows PCs. This course is taught at an intermediate level. This course can also be delivered in-house at your location and tailored to your liking.

Suitability - Who should attend?

This Level 2 Excel training course is suitable for existing Microsoft Excel users seeking to improve their understanding of so they can produce powerful, well presented spreadsheets. The course follows on from our Level 1 course and is full of shortcuts and tips.

Training Course Content

The content for this Level 2 Excel training course is structured as follows:

Overview of Microsoft Excel Level 1 Course

  • Recap of Shortcuts and Tips from the Level 1 course
  • Recap of Absolute Cell Referencing

Range Names

  • Create Range Names
  • Navigate using Range Names
  • Print Range Name Areas
  • Create Formulae using Range Names

3D Worksheets

  • Setting up worksheets
  • Copying worksheets
  • Grouping worksheets
  • Calculating multiple sheets

Linking Data from Other Spreadsheets

  • Copying worksheets quickly and tips on copying to new spreadsheet

Advanced Functions

  • IF Statements
  • Nested IFs
  • VLookup

Conditional Formatting

  • Apply shading and formats to cells by setting up conditions
  • Creating Conditions using Formulae
  • Format Painter for Conditions

Data Validation

  • Setting up the restriction on how cells are input as dates, numbers, or time
  • Setting up cells entries as a list
  • Limit the characters of cell entries
  • Create Error Messages

Working with Large Data

  • Split
  • Freeze Panes
  • AutoFilter
  • Sort
  • Custom Sort

Text Functions

  • Trim, Proper, Left, Right
  • Concatenate
  • Text to Columns
  • Removing Duplicates

Tables (Lists)

  • Creating Tables
  • Formatting Tables

Pivot Tables

  • Overview of Pivot Tables
  • Create Pivot Tables
  • Format Data
  • Group Data in Pivot Tables
  • Show Pages
  • Refresh Data

Slicers (Excel 2010 Feature)

Sparklines (Excel 2010 Feature)

Advanced Charting

  • Producing Charts using a Function Key
  • Changing the Chart Type
  • Formatting Charts
  • Adding Titles
  • Customising the Chart
  • Drawing on Charts


This Level 2 Excel training course is offered both as an open/scheduled course and an in-house training course.

The in-house training will be delivered in the form of a closed course at your company's premises. SquareOne can come to you no matter where you are based throughout the UK. The cost of this training course is available upon request.

Provider: SquareOne Training

SquareOne Training

SquareOne Training

SquareOne Training is an internationally renowned IT Training company who create inspiring, motivational and cost effective training services which bring about tangible improvements in productivity. They specialise in providing classroom courses, Microsoft upgrade training, IT consultancy and large-scale rollout support...

Read more and show all courses with Provider: SquareOne Training

Request information - obligation free

Fill out your details to find out more about Excel - Level 2.

  Contact the provider

  Get more information

  Register your interest


Contact information for SquareOne Training

SquareOne Training

2 Tower Road
CH41 1FN Birkenhead

 Show phone number

Contact SquareOne Training

Reviews by course attendees

Delegate   |   16/05/2017
Training was very good overall. Good lunch
Phil Dunn   |   15/05/2017
Great Facilities, friendly staff and good session on Excel. I loved Pivots
Penny Jones   |   15/05/2017
For me and what we cover in work, the VLOOKUP module and Pivot Table were particularly helpful.
Enter & win £50 voucher

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Request information

Find out more about this Excel - Level 2 course - simply fill out your details:

Similar courses

With Activia, IT User training comes the way you want it: at your place or ours; off-the-shelf or bespoke; scheduled public classes or closed private courses matched to your requirements.

Case Study
SquareOne Deliver IT Rollout Pro...

Read about SquareOne's global projects in New Hardware and Software Refresh and Microsoft Lync/Skype Rollout.

Read more
Find more courses here