In House - Webinar

Microsoft Excel Intermediate

The goal of this live interactive practical webinar is to consolidate existing knowledge of Microsoft Excel and to add to it with technical and useful functions and procedures.
Duration:
3.5 hours
Max delegates:
10

Course price:
£700 + VAT

Course Introduction

The goal of this live interactive practical webinar is to consolidate existing knowledge of Microsoft Excel and to add to it with technical and useful functions and procedures.

There will be 3 x 45 minute sessions with practical exercises and breaks in-between. There will be a 30 minute Q&A at the end of the webinar.

Course Objectives

  • Refresh and consolidate existing knowledge
  • Understand use of IFs, Nested IFs and SUMIF
  • Apply Conditional Formatting

Course Content

  • 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
  • VLOOKUP in Detail for Range and Non-Range Lookups
    • External Cell Referencing and Linked Documents
    • Paste Special
    • Questions, Answers and Requests

Schedule

  • Session One – 45 min
  • Practical Exercises and break – 15 min
  • Session Two – 45 min
  • Practical Exercises and break – 15 min
  • Session Three – 45 min
  • Practical Exercises and break – 15 min
  • Q&A – 30 min
In House Course registration form

Enquire today

Please let us know how you would like us to contact you below:
Privacy consent

Please read our privacy policy

Open dates

Course name Topic Environment Duration Price Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun
Microsoft Excel Intermediate
Microsoft Office Skills
Webinar
3.5 hours
£175 + VAT
Scroll to Top