Intermediate Excel at Stainforth
- 1 day, 9.00am to 4.00pm
- Stainforth
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
3 start dates. Choose the one that suits you.
-
19 Nov 2026
Starts 19 November 2026
-
29 Jan 2027
Starts 29 January 2027
-
9 Jul 2027
Starts 9 July 2027
Course dates may be subject to change without prior notice.
Start dates may be subject to change. We will let applicants know if a start date changes.
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 at Stainforth
Prefer to talk? Call 01724 294040 or email wdinfo@dncolleges.ac.uk