Excel - Level 2

Category: Microsoft Office, Microsoft Excel

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

Slicers (Excel 2010 and 2013 Feature)

  • Use slicers to Filter Data

Sparklines (Excel 2010 and 2013 Feature)

  • Insert a Sparkline in to a Cell
  • Format your Sparkline

Advanced Charting

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

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 focussed spreadsheets. The course follows on from our Level 1 training and is full of shortcuts and tips.

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.

Course Contents

The subjects listed on the left are an outline. If there are any additional subjects you wish to cover, please feel free to call us prior to the course. All of our courses can be tailored to meet your business needs.

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.

Related Courses

  • Excel Level 1
  • Excel Level 3
  • PowerPoint Level 1
  • Word Level 1

Booking

To discuss course contents and booking arrangements, please call SquareOne on:

T: +44 (0)151 650 6907

E: enquiries@squareonetraining.com

Download Course Outline Request More Information

For more information about any of our courses please call +44 (0)151 650 6907,
email enquiries@squareonetraining.com or complete an enquiry form.

Back to top