Excel - Express

SquareOne Training
Course summary
Length: 1 day
Price: 175 GBP excl. VAT
Language: English
Course type: Open / Scheduled
Next available date: Contact us for future dates - Liverpool
Course Dates
Please enquire for dates & details  (English)
175 GBP
Contact us for future dates  (English)
Please enquire for dates & details  (English)
175 GBP

Course Description

Excel - Express (2003/2007/2010 & 2013)

Excel - Express (2003/2007/2010/2013 & 2016)

This Excel Express training course is offered as an open/scheduled workshop by SquareOne Training. The course is designed to show people all the clever Microsoft Excel Data Manipulation Features. We have found that these are the most popular features we show on our courses and we have therefore created this new and exciting course to help you get the most out of Excel quickly.

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.

Suitability - Who should attend?

This Excel Express (2003/2007/2010/2013 & 2016) 1 day course is suitable for existing users of Excel who want to learn more about data manipulation features.

Training Course Content

The content of this Excel Express (2003/2007/2010/2013 & 2016) course is structured as follows:

Range Names

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

Advanced Functions

  • Advanced Functions such as IF, IF(AND, IF(OR, Countif, VLookup, ISERROR
  • Data Calculations

Text to Columns and Concatenate

Conditional Formatting

  • Apply shading and formats to cells by setting up conditions
  • Creating Conditions using Formulae
  • Sorting by Colour

Database Functions

  • Working with the AutoFilter feature
  • Advanced Filters
  • Data Form
  • Sub Totals
  • Data Tables

Pivot Tables

  • Create Pivot Tables
  • Group Data in Pivot Tables
  • Show Pages


This Excel Express 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 - In-House IT & Computer Training

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

Read more and show all courses with Provider: SquareOne Training

Request information - obligation free

Fill out your details to find out more about Excel - Express.

  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

Louise Parkes   |   31/05/2017
I learnt so much from this course. Would highly recommend. Especially the shortcuts.
Course participant   |   12/06/2015
Trainer was excellent. Good atmosphere to learn in. She answered all questions and pushed learners. Excellent session, great tuition, learnt things I didn't know existed in a programme I use everyday!
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 - Express course - simply fill out your details:

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