In this Microsoft Excel training course, delegates will explore the vast range of Excel Formulas and Functions and learn how to apply these to their own work. This course is designed for students who want to gain the necessary skills to create, edit and utilise Excel’s formulas and functions. After completing this course delegates will be able to: 

  • Creating formulas and using BODMAS Rules 
  • Absolute Cell Referencing & Mixed Cell Referencing 
  • Named Cells and Named Range Formulas 
  • Consolidated Formulas and Grouping Formulas 
  • Conditional Formatting Formulas 
  • Auditing Formulas and Functions


  • 01

    Course Files

    • Course Files

  • 02

    Excel Formulas and Functions

    • Absolute and Mixed Reference Formulas

    • Consolidated Formulas and Functions

    • CountIF

    • CountIF, SumIF and AverageIF

    • Database Functions

    • Date Functions

    • Formulas Auditing

    • IF Error

    • IF Text Functions

    • IF, AND, OR

    • IF & VLOOKUP

    • Logical Functions

    • Match and Index

    • Multiple IF, OR, AND

    • SUMIF

    • Text Functions



Richard Walters is one of NILC's senior level Microsoft Office trainer's and has more than a decade of experience in IT and Business Skills training. Richard has an advanced-level understanding of all Microsoft Office packages and specialises in Excel, Word, PowerPoint, Visio and Project.

Richard Walters

Senior Microsoft Application Instructor


  • When does the course start and finish?

    The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.

  • How long do I have access to the course?

    How does 1 years access sound? After enrolling, you have unlimited access to this course for 365 days - across any and all devices you own.

  • What if I am unhappy with the course?

    We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 14 days and we will give you a full refund.