Back to all courses

Microsoft Excel Formulas and Functions

The aim of the course is to enable you to understand and apply functions, and use nested functions where more than one function will be required. A variety of other functions from the content list below will be covered from categories that you require. As new functions are added by Microsoft, these will be included where appropriate.

Save to my Shortlist Save to shortlist Share Share

Certification:

College Certificated

Duration:

  • Half day trainer led or virtual
Enquire now

Who is this course for?

This course would benefit all levels of staff within an organisation.

What qualifications will I gain?

Fife College Certificate of Attendance

What will I learn on the course?

You will complete the following outcomes:
  • Functions types and the Insert Function tool;
  • Using Nested functions to create more complex formulas;
  • Formula Auditing Tools.

Nesting Functions

  • Using Complex Functions
  • AND, OR, and NOT functions with IF
  • Using IFS for multiple conditions
  • SUMIF, COUNTIF, COUNTBLANK

Formula Auditing Tools

  • Trace Dependant and Precedent cells
  • Evaluate formula tool

Date and Time Category

  • TODAY, NOW, NETWORKDAYS, EOMONTH

Text Category

  • Extracting specific data with the MID, LEFT and RIGHT functions
  • Using the TRIM function to remove unwanted spaces in a cell
  • Using ampersands and CONCATENATE to combine data from different cells
  • Using TEXTSPLIT, TEXTBEFORE. TEXTAFTER to extract data

Information Category

  • Extracting information with the CELL and INFO functions
  • ISERR, ISERROR, IFERROR, and ISNA error-checking functions

Advanced Lookup and Reference Category

  • Using MATCH and INDEX functions together
  • Using the XLOOKUP function
  • Using VSTACK, HSTACK, TOCOL, TOROW, TAKE, DROP to append data into an array
  • UNIQUE and EXPAND functions

Statistical Category

  • Finding the middle value with MEDIAN and most common value with MODE
  • ROUND, ROUNDUP, and ROUNDDOWN functions

Reference Category and Advanced Data Validation

  • Getting data from remote cells with the OFFSET function
  • Using INDIRECT with Data Validation for two-tiered pick lists

Application Information

What further course options are available?

Please explore our range of training courses available on our website.

How will this help my career?

This course enhances your proficiency within Microsoft Excel, which you can take back into your workplace activities to improve productivity.

Related courses

View all courses