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

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 helpdesk support for 28 days
Course Takeaways
Learner Reviews

How good is the course?

  • Average Score 4.9 out of 5
  • Delicious lunch provided
  • Certificate of Achievement
  • 622 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

  Course Dates Venue   Price  
London Bridge £299 + VAT
Online £149 + VAT save £150
London Bridge £169 + VAT save £130
Online £299 + VAT
London Bridge £199 + VAT save £100
Online £199 + VAT save £100
London Bridge £229 + VAT save £70
Online £229 + VAT save £70
London Bridge £299 + VAT
Online £299 + VAT
London Bridge £299 + VAT
Online £299 + VAT
London Bridge £299 + VAT
Online £299 + VAT
London Bridge £299 + VAT
Online £299 + VAT

You Might Like These Too

Microsoft Excel Adv

from £149 + 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 £129 + 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 £129 + 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

What Do People Think About Our Courses?

Tom Interview
Premiere Intro

 Learner Stories

Tom's Course

Tom works in Internal Communications for an NHS service provider. Listen to his experience about attending our online Adobe Premiere Intro course.

Meija Interview
Social Media Marketing Intro

 Learner Stories

Meija's Course

Meija works for the MOD, in marketing and communications and here tells us about attending her online Social Media Marketing course with Alice.

Katie Interview
Social Media Marketing Intro

 Learner Stories

Katie's Course

Katie works for the Ministry of Defence as a Digital Content Editor and here tells us about attending her online Social Media Marketing course with Kirsty.



"Content was all good and the trainer was very clear in her explanations"
LBMA
22nd March - Microsoft Excel : Intermediate

Latest Reviews



"This was such a useful course! Loads of useful tips, Lynne was great."
The British Academy
  • 22nd March


"Information provided was very useful and I look forward to participating in more training sessions."
The British Academy
  • 22nd March


"Very professional and well presented. Very knowledgeable."
IOPC
  • 22nd March
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients