Back
Responsive image

Microsoft Excel Intermediate | Training Course

Gain the confidence to take on more complicated tasks in Excel.
Learn new ways to manipulate data, analyse information, and automate tasks.

LONDON LOCATION | SMALL COURSE SIZES | EXPERT TRAINING | ONLINE COURSE AVAILABLE

  Course Dates Venue   Price  
London Bridge £299 + VAT
Online £299 + VAT
Online £299 + VAT
London Bridge £179 + VAT save £120
Online £179 + VAT save £120
London Bridge £199 + VAT save £100
Online £199 + VAT save £100
London Bridge £229 + VAT save £70
Online £229 + VAT save £70
London Bridge £249 + VAT save £50
Online £249 + VAT save £50
London Bridge £279 + VAT save £20
Online £279 + VAT save £20
London Bridge £299 + VAT
Online £299 + VAT
London Bridge £299 + VAT

Microsoft Excel Intermediate | Training Course

Course Takeaways
Course Info

Course Offering

Course Takeaways
Takeaways

What will I learn?

  • Using more advanced formulas
  • Working with conditional formatting
  • Efficient worksheet management
  • Improved data analysis
  • Streamlined data organisation
  • Free digital course assets
  • Free post-course helpdesk support
Course Takeaways
Learner Reviews

How good is the course?

  • Average Score 4.9 out of 5
  • Delicious lunch provided
  • Certificate of Achievement
  • 1019 reviews

Introduction Refresher on basic formulas & functions

• Statistical functions (Average, Max, Min, Count and Counta)

• Using relative & absolute addressing

• Creating, using and editing range names

• Locking cells and worksheets

Working with Worksheets

• Grouping worksheets

• Setting Tab colour

• Performing calculations across sheets

Taking formulas to the next level

• Using SUMIFS & COUNTIFS

• The basic IF function

• Simple VLOOKUP

Questions & answers

Highlight data with formatting

• Apply Conditional Formatting Rules

• Use the Conditional formatting rules manager

• Create Conditional formatting using a formula

• Clearing rules

Working with Lists

• Freezing panes

• Filtering Data

• Using the subtotal tool

• Formatting as a table

Questions & answers

You Might Like These Too

Microsoft Excel Adv

from £179 + VAT

1 day course
Gain the confidence to tackle complex challenges and scenarios in Excel.

Learn time-saving hints and tips from professional Microsoft Excel experts.

  • Expanded functions for advanced calculations
    Minimise audit risk with data validation
    Analyse data efficiently with Pivot Tables
    What If Analysis with Goal Seek and Scenarios
    Clever time saving techniques

Microsoft Powerpoint Intro

from £179 + VAT

1 day course
Quickly and easily create professional, engaging presentations using PowerPoint.

Learn tips and tricks from experts to make your presentations shine.

  • PowerPoint interface and navigation
    Layouts and slide design
    Making text look great
    Using images, charts and graphs
    Mastering transitions and animations

Microsoft Word Adv

from £179 + VAT

1 day course
Dramatically improve your productivity when using Microsoft Word.

Discover techniques for working faster and more efficiently.

  • Mastering Mail Merge
    Efficiently manage long documents
    Tools for collaborative editing
    Create custom forms for data collection
    Options for exporting documents


"Great course, great trainer. Thanks"
Metropolitan Police Service
1st May - Microsoft Excel : Intermediate

Latest Reviews
Microsoft Excel : Intermediate
"The pace of the day/how the day was divided up. Energetic and knowledgeable trainer. Useful and relevant content."
NHS England
  • 1st May
Microsoft Excel : Intermediate
"Explaining everything clearly and a helpful and approachable manner. Giving good pointers for taking our learning forward. Good examples for practice."
NHS England
  • 1st May
Microsoft Excel : Intermediate
"Lynne was brilliant at making sure everyone in the course was keeping up to speed and taking on what was being taught. I found it great that we could apply it to our daily work."
Crown Prosecution Service
  • 4th April