Excel Functions & Formulas Workshop

Key Course Points

Course Code: SSA5033 Course Data Sheet
View PDF
 Course Duration 0.5 days Start & End Time 1:30 pm- 4:30 pm

Upcoming Dates

Start Date Format Price (€) Price (£)
19/01/2027 Virtual / Classroom €279.00 £225.00 Enrol Now
09/03/2027 Virtual / Classroom €279.00 £225.00 Enrol Now
11/05/2027 Virtual / Classroom €279.00 £225.00 Enrol Now
15/07/2027 Virtual / Classroom €279.00 £225.00 Enrol Now
I would like to discuss custom dates and or private delivery. 
Enquire Now

Course Information

Excel formulas and functions are essential to performing calculations and solving problems in a Microsoft Excel Workbook. This half day workshop will start with the formula and function basics and then cover a range of mathematical, date and time, logical, lookup and conditional functions.

On completion of this half day workshop, you will be up and running with building formulas and functions in Excel.

  • Formula Basics: Doing Math with Excel
  • Use References in Excel Formulas
  • Introduction to Functions (SUM, COUNT, AVERAGE, MAX and MIN)
  • Use Date and Time Functions
  • Join Text and Numbers
  • Use IF Statements
  • Use the VLookup Function
  • Use Conditional Functions (SUMIF, SUMIFS, COUNTIF and COUNTIFS)
  • Detect and Fix Formula Errors

This workshop assumes the user has completed or has an understanding of the topics covered in the Excel Introduction course, including:

  • Using basic formulas and functions in a worksheet
  • Editing and formatting Excel data
  • Printing and saving Excel files

Contact Us

Whether you are thinking of doing any of our courses you can book it here now. Alternatively, if you need advice or would like to discuss a business discount account - email: info@sureskills.com or call: 01 240 22 62 (Irl)/ 028 9093 5565 (UK).

Latest Downloads

Discover our wide range of courses to help you achieve maximum results.

View Full Brochure Range