*VIRTUAL* – Excel Bite Size ½ day Sessions – Formulas and Functions

Request info

Online Excel Training Course

Course Description: This virtual course is designed for people wish to learn how to create and work with formulas and functions within Excel.  The session will start out with some basic formulas and functions to get you started and ensure confidence using them.  We will then delve into more advanced functions for the latter part.

 Prerequisites: Delegates attending this course should have a basic knowledge of Excel 2016.

Course Content

  • Create formulas to:
  • Add
  • Subtract
  • Multiply
  • Divide
  • Sum
  • Min
  • Max
  • Average
  • More Advanced Functions
  • IF
  • OR
  • AND

This course will run 3 hours with a 15-minute break.  Morning sessions will be 09:30 until 12:30.  Afternoon sessions will be from 13:00 until 16:00 with a 15-minute break.

SELECT wp_posts.*, wp_p2p.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_p2p WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'start_date' AND CAST(wp_postmeta.meta_value AS DATE) >= '2025-05-21' ) ) AND ((wp_posts.post_type = 'schedule' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) AND (wp_p2p.p2p_type = 'schedule_to_courses' AND wp_posts.ID = wp_p2p.p2p_from AND wp_p2p.p2p_to IN (SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (27382) AND ((wp_posts.post_type = 'courses' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) ORDER BY wp_posts.post_date DESC )) GROUP BY wp_posts.ID ORDER BY CAST(wp_postmeta.meta_value AS DATE) ASC