t. 0161 848 9173 f. 0161 872 9480
e. secretary@stantonyscentre.org.uk
Home > Information Technology Courses > Microsoft Excel – Intermediate

Microsoft Excel
Intermediate (SS-02)

Course Overview

The Intermediate Microsoft EXCEL course is one of a number of one-day courses we offer to those wishing to learn how to use Microsoft Office applications efficiently (including quick techniques and short cuts) and effectively to produce professional-looking documents.
On this course, delegates will learn how to create more sophisticated and spreadsheets.  We introduce columns, section breaks, mail-merge and inserting different elements into documents including simple charts and graphs, Word Art and screenshots.

Who is the course for?

This course is aimed at:
  • anyone who needs to use Microsoft Word in their workplace or in another context to produce more complex documents
  • those who have some experience of using Microsoft Word and want to learn more about its functionality and possibilities
  • those who have attended our Beginners' Microsoft WORD course and can create and edit documents, including using tables, text formatting, headers and footers and inserting pictures.
  • administrators, personal assistants or other staff who have responsibility for producing documents such as letters, reports, newsletters, etc.

Content / Programme

This course takes place over one day (see below for timing and lunch arrangements) and during that time, delegates will learn how to:
  • merge cells and align data within cells
  • use different cell formats
  • use multiple sheets for different purposes, including LOOKUP tables
  • use VLOOKUP to extract data from another sheet
  • use IF formulae to determine a cell's value based on the value of one or more cells (including using AND/OR)
  • use nested IF formulae to create multiple conditions for determining cell values
  • use formulae COUNTIF and COUNTIFS to count cell values dependent on specific criteria
  • use SUMIF and SUMIFS to add a range of values depending on specific criteria
  • import and export data in different formats, e.g. CSV - Comm Separated Values
  • use data validation to ensure data entered is valid
  • use simple conditional formatting to change the format (e.g. shading) of a cell according to its value
All participants will have access to a computer for the whole day. 
The version of Microsoft Word used on the day will be WORD 2019.

Assessment and Qualification

The course is not assessed or part of a qualification, although delegates will be given a 'certificate of completion' and self-assessment to track their progress during the day and encourage thinking about future learning.

Location, Timings and Facilities

  • The course will take place at our Trafford Park Centre, details of which can be found here.
  • The course will start at 9.30am and finish at 3.30pm.  There will be a break of 30 minutes during the day (usually about 12noon) for lunch).
  • Drinks (tea, coffee, water) will be provided on arrival, during mid-morning break and after lunch.
  • Lunch is not provided.  There are plenty of shops very close to the centre offering a range of lunchtime food.  There is a small eating space at the centre.  Delegates can, of course, bring their own lunch.  Food cannot be eaten in our IT Training Room, thank you.
  • There is free parking at the Centre.  The Centre can also be accessed by public transport.

Course Fees, Cost and Payment

  • This course can be booked by telephone (0161 848 9173) or via our Course Booking Form (select course SS-02 and your preferred date)
  • The cost of the course is £99.00
  • Payment can be made by Bank Transfer or via our STRIPE payment system.  Once we have confirmed your booking and provided your email address, we will send you an invoice which will include a link to the payments system and our bank account details and the reference you should use for payment.
  • If we do not have enough enrolments (we would normally expect a minimum of 3-4 participants) to run this course, we may offer you another date or a full refund if you have already paid the course fee.