Excel Intermediate

Course summary
1 day
195 - 240 GBP excl. VAT
Open / Scheduled
Next available date: 08/04/2020 09:30 - London
Course Dates
08/04/2020 09:30  (English)
195 GBP
16/04/2020 09:30  (English)
235 GBP
27/04/2020 09:30  (English)
240 GBP
05/05/2020 09:30  (English)
240 GBP
14/05/2020 09:30  (English)
240 GBP
21/05/2020 09:30  (English)
240 GBP
STL courses

Excel Intermediate

Courses never cancelled. Restaurant lunch. Last minute rescheduling. 24 month delegate support forum. And more... Quickly summarise multiple sheets of data into one; Turn long lists and reports into easy to read tables; Formulas to check whether cells pass or fail your rules; Create links between cells so that they all update automatically; Highlight targets, trends, duplicates and errors with Conditional Formatting; Formatting and layout consistency by saving as a Template

Suitability - Who should attend?

These intermediate Microsoft Excel courses are designed for delegates who have used Excel before and want to expand their knowledge. Improving formatting, organising data, highlighting key information and creating formulas/links between sheets.

You may also wish to know we also deliver advanced Excel training courses.

Training Course Content

Working with Large Worksheets

Viewing options
- Adjusting zoom
- Using Freeze Panes
- Using Split Window
Hiding and displaying data
- Hiding rows and columns
- Creating an outline
Printing large worksheets
- Page Break preview
- Working with page breaks
- Printing multiple sheets

Working with Multiple Worksheets and Workbooks

Using multiple worksheets
- Navigating between sheets
- Moving and copying sheets
Linking worksheets
- Creating 3-D formulas
- Consolidating data
Linking workbooks
- Creating a formula to link workbooks
- Using the Paste Link option
- Maintaining links

Working with dates

Entering date functions
- TODAY function
- NOW function
Date and time formats
Using dates in formulas

Conditional formulas and formatting

The IF function
Conditional formatting
- Based on a cell value
- Based on a formula
- Identifying cells with conditional formatting
- Copying conditional formats

List Management

Working with lists
- Structure of a list
Sorting and filtering lists
- Simple sorting
- Sorting by multiple columns
- Using AutoFilter
Advanced filtering
- Using custom filter
- Using Advanced Filter
Adding subtotals to a list

Documenting and Auditing

- Viewing, adding, editing and deleting comments
Auditing features
- Tracing formula errors
- Protecting a worksheet
- Protecting cell ranges

Using Templates

Built-in templates
- Accessing and using Excel’s templates
Creating and managing templates
- Creating, using and modifying a custom template file


List price £330 per delegate. Promotional rates apply: see event listings for current prices. On-site training also available: Contact us.

Be Inspired! Watch the Video


Election Analysis Excel Dashboard

Best STL

Using an Excel Dashboard to analyse and visually display May 2015 UK General Election Poll data from the web.

Provider: STL

STL - Microsoft Training

STL - Helping businesses deliver productivity and efficiency gains

Learning solutions from leadership and management training programmes to business intelligence and applications training. London based with a global reach....

Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Excel Intermediate.

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award


We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Contact information for STL


Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number
www.stl-training.co.uk Course homepage

Reviews by course attendees

Average rating 4.7

Based on 9857 reviews

Nicola Stewart; Administrator
Excellent; these are by far the best training courses on the market from Best STL!
Bogdan Raileanu; Conference Coordinator
Most useful topic: Worksheet links
Phineas Isles; Project Manager
Very good. Marius has patience and enthusiasm
Request information

Find out more about this Excel Intermediate course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!


Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here