Where it runs
Courses run at UCNL, Scunthorpe. Some can also be delivered at Doncaster College, Stainforth or HESTA (Hull) — ask the team for details.
Overview
Customised programme
Course Structure
The course covers the following –
- Introduction
- Work Related Spreadsheets
- Working Example
- Quick Access Toolbar
- Formula Auditing
- Named Ranges
- Data Validation (using Named Ranges
- Absolute Values (‘Locking’ the cell reference)
- Data Transfer between Worksheets and Spreadsheets
- Conditional Formatting
- IF Statements and Formulas
- VLOOKUPs
- Inserting Charts
- Pivot Tables
- Paste Options / Clipboard
- Date and Time Functions
- Placing Existing Data into a ‘Table’
- Themes
- Adapting the view of the Spreadsheet
- Inserting ‘Screen-Shots’
- SmartArt Graphics
- What-If Analysis
- Version History
- Show Changes
- Work Related Spreadsheets
There is also an opportunity during the last section of the workshop to work on Excel with specific work related issues.
Assessment Methods
N/A
Upcoming courses
4 start dates. Choose the one that suits you.
-
10 Dec 2026
Starts 10 December 2026
-
11 Feb 2027
Starts 11 February 2027
-
15 Apr 2027
Starts 15 April 2027
-
24 Jun 2027
Starts 24 June 2027
Course dates may be subject to change without prior notice.
Entry Requirements
What You'll Need
N/A
Enquire about this training
One short form. The team will be in touch to confirm your place.
You’re enquiring about Intermediate Excel
Prefer to talk? Call 01724 294040 or email wdinfo@dncolleges.ac.uk