Excel Intermediate

STL
4.2
33 reviews
  • The beginning was done with the enquiry about the relevant portion of the programme and attempted to resolve any apropos issues if there were while using excel. Very knowledgeable.
    ← | →
  • I truly gained a lot out of it.
    ← | →
  • Dough was distinct in his instruction and really tolerant. I did acquire a great deal of new abilities with application of Excel.
    ← | →

Course

In London

£ 201-500

The best Excel courses

See all

See all

Description

  • Start date

    Different dates available

Rated excellent on Trustpilot!

This course is 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.

This course is also offered as inhouse. STL may go to your premises or you can visit our venue in London.

Facilities

Location

Start date

London
See map
12 Bloomsbury Square, WC1A 2LP

Start date

Different dates availableEnrolment now open
London
See map
2nd Floor, Cruising Association House 1 Northey Street, E14 8BT

Start date

Different dates availableEnrolment now open

About this course

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

A working knowledge of creating/formatting simple spreadsheets, basic formulas and functions e.g. AutoSum. Or our Excel Introduction course.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.2
fantastic
  • The beginning was done with the enquiry about the relevant portion of the programme and attempted to resolve any apropos issues if there were while using excel. Very knowledgeable.
    ← | →
  • I truly gained a lot out of it.
    ← | →
  • Dough was distinct in his instruction and really tolerant. I did acquire a great deal of new abilities with application of Excel.
    ← | →
100%
4.3
fantastic

Course rating

Recommended

Centre rating

Julie Tang

3.5
05/07/2017
What I would highlight: The beginning was done with the enquiry about the relevant portion of the programme and attempted to resolve any apropos issues if there were while using excel. Very knowledgeable.
What could be improved: Nothing.
Would you recommend this course?: Yes

Maria Rojas

4.5
30/10/2016
What I would highlight: I truly gained a lot out of it.
What could be improved: Everything OK.
Would you recommend this course?: Yes

Amanda

4.5
30/10/2016
What I would highlight: Dough was distinct in his instruction and really tolerant. I did acquire a great deal of new abilities with application of Excel.
What could be improved: Everything OK.
Would you recommend this course?: Yes

Lynsey

4.0
05/10/2016
What I would highlight: I attended an excel programme conducted by Best STL. They customized a programme only for our organization which was amazing on the grounds that we got the best out of the learning background in zones that we required support with. The coach was exceptionally learned and made the course fascinating and also including funny side which kept us involved the entire day. I would utilize Best STL again for courses later on and surely prescribe them to anybody.
What could be improved: N/A.
Would you recommend this course?: Yes

Lindon Rochester

4.0
18/07/2016
What I would highlight: I anticipated that the programme was truly incredible, brilliant training. Doug who conducted the programme I undertook answered all the questions and much more.
What could be improved: No negative aspects.
Would you recommend this course?: Yes
See all
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2017

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 7 years

Subjects

  • MS Excel
  • Workbooks
  • Large Worksheets
  • Multiple Worksheets
  • Page Break
  • Viewing options
  • Conditional formulas
  • List Management
  • Documenting
  • Auditing
  • Templates
  • Excel

Course programme

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

Comments
- Viewing, adding, editing and deleting comments
Auditing features
- Tracing formula errors
Protection
- 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


Additional information

We include hot restaurant lunch in all training courses. In addition to that, our courses are never cancelled.

See related categories

Excel Intermediate

£ 201-500

The best Excel courses

See all

See all