Excel – Intermediate

Make an enquiry


The goal of this course is to consolidate existing knowledge and to add to it with technical and useful functions and procedures.

What we will cover

  • Existing Knowledge Refresh
  • Calculations and Percentages
  • Advanced Absolute Referencing
  • Conditional Formatting / Sparklines
  • The IF Function
  • Using Nested IFs
  • The SUMIF function for Analysis and Reconciliation
  • COUNTIF for further Analysis
  • VLOOKUP in Detail for Range and Non-Range Lookups
  • External Cell Referencing and Linked Documents
  • Paste Special
  • Questions, Answers and Requests
Illustration - Tablet

By the end of this course you will:

Q and A icon

Refresh and consolidate existing knowledge

Document search icon

Apply Conditional Formatting

Head Empower icon

Understand use of IFs, Nested IFs and SUMIF

Make an enquiry

Ready to book? Simply complete the form with your details and we will contact you about the next available dates.

If you require further advice on the suitability of this course, please call our experts on 0117 248 2731

APCC Affiliate
ilm approved

Ready to change the way you work?