Need Help? Call: +44 (0)151 650 6907


Excel: Intermediate (Mac)

About SquareOne

SquareOne is among the UK's leading providers of IT training to businesses of all shapes and sizes. Our company pledge is to deliver inspiring, motivational and cost effective training which brings about tangible improvements in productivity. Through our training solutions, individuals are able to gain lifelong skills and realise their full potential whilst clients achieve their corporate goals.

Course Objectives

This course is suitable for existing users of Microsoft Excel who wish to improve their understanding of this package so that they can produce powerful, intuitive and business focused spreadsheets. The course follows on from our Level 1 training and is full of shortcuts and tips.

Training Locations

Our open classroom courses are held in Merseyside where we have state of the art training facilities. We also provide in-house training solutions at any office location in the UK or Europe. We frequently deliver training in Liverpool, Wirral, Blackpool, Manchester, London, Chester, Warrington, Leeds, Cardiff, Birmingham, Edinburgh, Bristol, Sheffield, Glasgow, Leatherhead and Aberdeen as well as in European countries such as France, Switzerland, Germany, Sweden, Norway and Ireland.

Software Versions

We offer training solutions for all versions of Excel - 2003, 2007, 2010, 2013 and 2016 for the PC and 2011 and 2016 for the Mac (Office 365)

Related Courses

Course Duration

Choose from:

1 Day - Customised Course Outline - Closed Course

2 Day - Complete Course Outline - Closed Course or Open Classroom Course

Our course timings are 09:30 - 16:30.

Overview of Excel Level 1

  • 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
  • Tips for Copying to New Spreadsheets

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 Restriction on how Cells are Inputted as Dates, Numbers, or Time
  • Setting up Cell Entries as a List
  • Limit the Characters of a Cell Entry
  • Create Error Messages

Working with Large Data

  • Split your Worksheet
  • Freeze Panes
  • Use AutoFilter
  • Sort and Custom Sort

Text Functions

  • Use the Trim, Proper, Left and Right Functions
  • Concatenate Text
  • 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

Pivot Table Slicers

Advanced Charting

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


Looking for in-house training that can be customised to you/your businesses exact needs? Contact us below for one of our team to contact you.

Upcoming Courses

Below are a list of upcoming dates and locations where this course is scheduled to take place.

Location Start Date Duration Cost

Related Courses

For more information about any of our courses

please call +44 (0)151 650 6907, email or complete an enquiry form.