Excel Formulas Webinar

What you will learn

This 2-hour Excel formula webinar is designed for those who want to get to grips with inputting formulas. By breaking them down into their individual parts is the only way to truly understand how they work.

Prerequisite

This webinar is designed for those who have had some experience of using Excel.

Date and time: Once you have completed purchasing a booking, we will send an email to arrange a suitable time and date for this online course, including your booking confirmation and joining instructions.

You are asked to join the meeting 5 minutes before start time to ensure a prompt start.

Can't find the course you're looking for? Please enquire about our range of virtual classroom courses.

If booking 2 people, please add the quantity in your cart.

If booking 3 or more people, get in touch for a quote.

Price: £82


If you have any questions, please complete our enquiry form.

By the end of this webinar you will know how to:

  • Lock formulas to cells when copying, known as Absolute reference
  • Use built-in help guides to find the formula you need
  • Run statistical analyses with MIN, MAX, COUNT and COUNTA functions
  • Use COUNTIFS to only count content that meet particular criteria
  • Use SUMIFS to only sum numbers that meet particular criteria
  • Understand how Comparison Operators are integral to formulas
  • Use the IF function to generate a result from a test
  • Use Data Validation to control data input and aid formula output
  • Retrieve data from tables with the popular VLOOKUP function
  • Achieve a professional look to your formulas with IFERROR function