Microsoft Excel Intermediate

The IF Function
IF with AND / OR Functions
Nested IF –
including IFS
Date and Time Functions – TODAY, YEAR, MONTH
Data Validation
The Lookup Function: VLOOKUP, HLOOKUP, XLOOKUP
VLOOKUP Function with IFERROR Validation
Subtotal Feature & SUBTOTAL Function – with Outlines
Database Statistical Functions – DAVERAGE, DCOUNT, and DSUM
Advanced Filters
Conditional Formatting
Pivot Tables & Pivot Charts

This course is designed for individuals who:
Want to display data dynamically in Excel worksheets based on specific conditions or criteria.
Seek to visually understand and follow the logical flow of formulas within worksheets, including addressing circular references.
Are responsible for managing and maintaining lists containing a moderate number of items, such as company assets, personnel records, product inventories, or invoices, often numbering up to a few thousand rows.

We can deliver our training sessions in several ways, these being:

  • Open public course (Contact us if you can’t see a suitable date listed)
  • Closed group
  • In person face to face
  • Virtual
  • One to one coaching

Have two or more people to train? You may consider a closed group course.

Benefits include:

  • Cost effective
  • Choose a date to suit you
  • Customise content and timings
  • No minimum delegate

Contact us on [email protected] to discuss specific date and delivery requirements.

How Our Tutor led Courses Are Delivered:

Delegates are given Pre-work
Group courses use your real-world scenarios so learning is immediately relevant and actionable.
Our sessions are participative and highly Interactive by including a variety of activities throughout the delivery including
Real-world case work
Practical exercises
Real Play
Peer learning
Case studies
Simulation
Facilitated discussion and Structured reflection
Leave with Actionable outcomes
Post-session measurements

Participants leave with:

Practical tools
Clear action plans
Greater confidence
Skills they can apply immediately

Course Benefits

  • Fully tutor led instruction
  • Comprehensive courseware for all delegates
  • Certificates of attendance
  • Course Guarantee
  • Emergency trainer
  • Contextualisation and customisation for Closed group courses
  • Evaluation Feedback
  • Pre & Post Course Activities
  • Access to Customer Portal (course bookers) for oversight of past and future training events and attendance details

Key Features

Course Duration is 1 Day

Engaging tutor led event

Comprehensive course materials

Certificates of attendance

Access to Customer Portal (course bookers)

Course Guarantee

Priced per delegate per day virtual open public course

From: £295.00 Plus VAT

Select a Date

Loading available dates...

Can’t see a suitable date? Please request a date here

Payment available via all major credit cards or Invoice. All options available during the online booking process.