Basic to Advanced Level

Course Outline

Basic Level

Introduction to Microsoft Excel and useful shortcuts
Fundamentals of formulae including freeze panes, how to use the $ sign, & ampersand, drag function, setting names and paste special function.
Creating charts
Date and time formulae.
Text formulae and functions including concatenate, splitting content from cells, flash fill, group and ungroup.
Math and trig formulae including SUM and subtotal, rounding and absolute formula.
Checking for errors.
Importing text delimited files.
Conditional formatting.
Data Validation

Intermediate to Advanced Level

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 240 including VAT per participant.

Hours

7 hours in total → 4 hours basic and 3 hours Advanced.

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

Next intake

4 sessions of 3 hours each on the following dates:

Monday 16th November at 5:00pm - 8:00pm

Tuesday 17th November at 5:00pm - 8:00pm

Monday 23rd November at 5:00pm - 8:00pm

Tuesday 24th November at 5:00pm - 8:00pm