Excel - Level 1

SquareOne Training
Course summary
1 day
195 - 275 GBP excl. VAT
Open / Scheduled
Next available date: 25/09/2019 09:30 - London
Course Dates
25/09/2019 09:30  (English)
275 GBP
16/10/2019 09:30  (English)
275 GBP
08/10/2019 09:30  (English)
225 GBP
05/11/2019   (English)
225 GBP
09/10/2019 09:30  (English)
195 GBP
07/11/2019 09:30  (English)
195 GBP

Course description


Excel - Level 1

This Level 1 Excel training course is offered as an open/scheduled 1-day workshop by SquareOne Training or a closed course at your offices.

At the end of this course you will feel more confident in creating spreadsheets with everyday calculations. You will know how to create, format and print spreadsheets, and how to create charts. 

Often, self-taught users miss out on the essential features and time saving shortcuts which are covered during this course.

Suitability - Who should attend?

This course is suitable for people who are self taught or have little to no experience of using Microsoft Excel who wish to get more confident within the package.


Delegates will need to be familiar with using personal computers and should have experience using a keyboard and mouse. We would expect delegates to know how to: launch and close applications, navigate, save and open files.

Training Course Content

Getting started with Microsoft Excel

  • Introduction to Excel
  • Navigating the Excel Screen and Ribbon
  • Tips and Tricks for Selection and Movement around the screen

File Management

  • Creating, Saving and Opening Workbooks

Data Input and Selection

  • Typing and Formatting for Text, Dates and Numbers
  • Selecting Cells, Rows and Columns using the Mouse and Keyboard shortcuts

Using Functions

  • Using the Sum, Average, Min, Max, Count Functions
  • Understanding and working with the Function Wizard

Working with Dates

  • Date Calculations
  • Formatting Dates

Copying and Moving Data/Formulae

  • Using Cut, Copy and Paste
  • AutoFill
  • Drag and Drop

Editing Worksheets

  • Adding Rows and Columns
  • Sizing Rows and Columns
  • Hiding/Unhiding Rows and Columns

Formatting Worksheets

  • Working with Fonts, Sizes and Colours
  • Adding Borders and Fill Colour to Cells
  • Aligning the Content of a Cell
  • Applying Number Formatting
  • Using the Format Painter
  • Merge and Unmerge Cells

Working with Large Worksheets

  • Freezing Panes
  • Working with Split Pane View
  • AutoFilter


  • Using Print Preview
  • Setting the Print Range
  • Sizing Spreadsheets to Fit
  • Working with Margins, Headers and Footers and other useful print settings

Multiple Sheets

  • Creating and naming Sheets
  • Colouring Sheet Tabs
  • Navigating Sheets
  • Deleting Sheets

Charts and Graphs

  • Creating Charts and Graphs alongside data
  • Creating Charts and Graphs on a new sheet
  • Changing the Chart Types
  • Basic Formatting of Charts and Graphs


This Level 1 Excel training course is offered both as an open/scheduled course in Merseyside, Manchester or London. 

This course can also be offered as an in-house training course, 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 and Europe. Closed course price available on request,

About provider

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 this provider

Request info

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

  Contact the provider

  Get more information

  Register your interest

Contact info

SquareOne Training

2 Tower Road
CH41 1FN Birkenhead

 Show phone number


Richard T.
Learnt a lot. Took a lot of key learning points away.
K. Roberts
I found formulas, comparisons, printing and subtotals useful.
Lewis S.
Lovely atmosphere and very confident in what was being taugh. Brilliant sessoin - thanks very much Gill!
Request information

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

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's first annual U.K. L&D Report!

UK L&D Report

Learn more

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

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