Back
Responsive image

Microsoft Excel Intermediate | Training Course

Learn in-depth functionality and commands to analyse your data or finances in detail.
Gain the confidence to complete complicated Excel tasks efficiently.

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

  Course Dates Venue   Price  
London Bridge £179 + VAT save £120
Online £199 + VAT save £100
London Bridge £229 + VAT save £70
Online £249 + VAT save £50
London Bridge £279 + VAT save £20
Online £299 + VAT
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?

  • Refresher on basic formulas
  • Work with multiple worksheets
  • Use advanced formulas
  • Use conditional formatting
  • Analysis tools to present data visually
  • 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
  • 767 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
Automate and streamline your workflow to boost your productivity.

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

  • Use VLOOKUP functions
    Formula auditing tools
    Adv Pivot tables
    What If analysis
    Reducing your audit risk

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.

  • Understand the interface
    Create the perfect slide
    Work with text
    Visual enhancements
    Transitions, animations and notes

Microsoft Word Adv

from £179 + VAT

1 day course
Dramatically improve your productivity and efficiency on this advanced course.

Become confident using Word's more sophisticated features
  • Use Mail Merge
    Combine with Excel
    Master long documents
    Work with forms
    Time saving shortcuts


"Lisa was so knowledgeable and such a good teacher. It was really easy to follow the course and I felt able to ask questions throughout! Thank you :)"
CPAG
5th August - Microsoft Excel : Intermediate

Latest Reviews



"Trainer was very good and made sure everyone was engaged the whole way through."
Hill
  • 7th July


"Going through the exercises step by step and being able to have a go at doing them ourselves and share screen. Very interactive which is what I was looking for. Kevin was very clear and went back through anything we needed to. A fantastic day - thank you"
AIT Worldwide Logistics
  • 7th July


"The course was excellent. Lisa has the most incredible level of knowledge and was extremely personable. Many thanks."
The Charter School North Dulwich
  • 5th May