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.
About this course
Overview
Customised programme
What You’ll Learn
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.
How You're Assessed
Assessment Methods
N/A
Admissions
Entry Requirements
What You'll Need
N/A
Enquire
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