Basic 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

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

€120 including VAT per participant.

Hours

4 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