• Video

    This workshop is delivered through 20 video tutorials that will walk you through a series of useful Excel formulas. These on demand videos can be watched and studied in your own time and at a pace that suits your learning style. You can rewatch content as many times as you need to to help you master these new formulas and make your learning experience as easy as possible.

  • Documentation

    Alongside each video lesson, there will be a downloadable PDF support document to refer back to after the training. These documents are yours to keep forever and can be easily referred to while creating your spreadsheets. With step-by-step tutorials including screengrabs, real-life examples, and practical tips these documents will help implement Excel formulas with ease.

  • Quiz

    At the end of the course, there'll be a quiz to help check and confirm your understanding of all the skills, knowledge, tips and tricks you've learned. Test yourself on various Excel topics covered in the workshop, and receive instant feedback on your answers as you go and an overall final score. It's an ACE way to measure your progress and identify areas for further development.

What's Included...?

Excel formulas are essential to saving time and maximising your spreadsheet potential. I've designed this Excel Formulas Workshop to equip you with useful formulas you'll need to unlock the true power of Excel. The workshop covers 20 formulas in 3 hours worth of video content. You'll get to know everything you need to harness the power of formulas and streamline your spreadsheet designs. You can watch these pre-recorded sessions at your own pace, at a time that suits you, your learning style, and your schedule. Each lesson is supported with downloadable documents that will help you practice your new skills. Take a look at the skills we'll cover in this Excel Formulas Workshop below:

    1. Excel Formulas Workshop - Introduction

    1. Trim

    2. Substitute

    3. Iferror

    4. Min & Max

    5. Large & Small

    6. Left

    7. Right

    8. TEXTAFTER & TEXTBEFORE (NEW)

    9. Mid

    10. Len

    11. Find

    12. If Formula - with AND & OR

    13. Evaluate Formula

    14. Unique (NEW)

    15. Sort (NEW)

    16. Filter (NEW)

    17. Vlookup V Index Match

    18. Xlookup (NEW)

    1. Excel Formulas Quiz

About this workshop

  • £60.00
  • 20 lessons
  • 3 hours of video content
  • Each on demand lesson in this workshop includes downloadable practise data and support documentation to help you practice and consolidate your new skills. This workshop package concludes with an interactive quiz that will help you to cement your new found knowledge.

Access Options

Choose your length of study. You'll be able to rewatch our on demand videos as many times as you like during your chosen access period.

Fast-track your way to becoming an Excel Ace

Enrol today
workshop