Intermediate to Advanced Level

Course Outline

Logical formulae including IF, IFNA or IFERROR, goal seek and scenarios manager.
Lookup and reference including VLOOKUP, HLOOKUP and the new function XLOOKUP.
Conditional information including COUNTIF, SUMIF and AVERAGEIF.
Pivot Tables
Other advanced functions such as pivot tables, basic macros, charts, INDEX and MATCH and more.
Exploring budget templates, financial models and other reports.

Training delivery
Face to face or online.

Face to face address: The Hub Workspace, Triq Sant’ Andrija, SGN 1612 San Gwann.

Online: Microsoft Teams.

Maximum number of participants 8.

You will be given a pack of printed notes and workbooks to use during the sessions.

Price

Euro 140 including VAT per participant.

Hours

3 hours

Certificate of completion

A certificate of completion will be given at the end of the session following full attendance.

Tutor

Ms Pauline Micallef ACCA, MIA, CPA, MBA