Course Code : SS-02
Course Dates
Please see Course Calendar to see
course dates currently offered
Course Specification
Course Specification (PDF File)
Course Fee
£99.00
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 and effectively to produce professional-looking documents, including numerical data and charts.
On this course, delegates will learn how to create more sophisticated spreadsheets, including a range of formulae.
Who is the course for?
This course is aimed at:
-
anyone who needs to use Microsoft EXCEL in their workplace or in another context to produce spreadsheet for more complex data analysis
-
those who have some experience of using Microsoft EXCEL and want to learn more about its functionality and possibilities
-
those who have attended our Beginners' Microsoft EXCEL course and can create and edit simple spreadsheets, including basic formulae and formatting of cells
-
administrators, personal assistants or other staff who have responsibility for producing presenting and analysing data for different purposes.
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 EXCEL used on the day will be EXCEL 2016.
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.