Excel Level 3 - functions and formula

Falmouth University Business students smiling and looking at a laptop
Tuition fees per individual £85*
Delivered online


14 Jun 1pm - 4pm

Book course

*If you're a student or staff different fees apply. Please visit our dedicated student and staff areas for specific information.

Who's the course for?

This course will teach you some of the most important formulas needed to use Excel. This course is the third in a series of three courses and can also be attended as a standalone course. In this third and final course in the series of three you will build on what you have previously learnt to use the advanced functions/formulas built into Excel. Formulas can be a tricky part of Excel and there are a great many to choose from but mastering them will enable you calculate values effectively and efficiently. After completing all three courses in this Excel series you will receive an overall digital badge showing your mastery of the software and have the opportunity to take the MOS Excel exam.

What you will learn  

  • Relative, mixed, and absolute references 
  • Structured references 
  • The count, counta and countblank functions 
  • Using the IF function 
  • Using the IF function with multiple conditions 
  • The concat and textjoin functions 
  • The left, right and mid functions 
  • The upper and lower functions 
  • How to ‘nest’ functions inside formulas 
  • The r and between functions 
  • The sequence, sort and unique functions 
  • Data validation
Matthew Abbot headshot
Matthew Abbot

Matthew Abbott - Course Lead

Matthew is a digital skills trainer at Falmouth, specialising in Microsoft Office 365 and Adobe Premiere Pro. He delivers a range of Adobe and Microsoft Courses including Microsoft Office Specialist (MOS) and Adobe Certified Professional (ACP) courses. He holds a degree in sustainable product design and a PCET teaching certificate and have taught as a Senior Technician at Falmouth University for over 20 years.