We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. Read More


Log in

M2039 - POSTPONED: Excel the Accounting Way (Session 1 and Session 2)

  • 24 Mar 2020
  • 26 Mar 2020
  • 2 sessions
  • 24 Mar 2020, 09:15 12:30 (UTC+01:00)
  • 26 Mar 2020, 09:15 12:30 (UTC+01:00)
  • TTC


Registration is closed
Registration Time: 09.00
Sessions Time: 09.15 - 12.30 including a 15-minute coffee break
Speaker: Ms Pauline Micallef
Venue: Lower Ground, Tower Training Centre, Swatar
Participation Fees (The Institute is now accepting payments via Paypal)
MIA Members: €100.00
Non-MIA Members: €180.00
Retired Members: €60.00
Students: €80.00

Background information

Some people fear Excel, however in today’s busy and fast-pacing world having knowledge of this tool saves you time, money and heartache. It’s an application that works with logical inputs, so whatever does not make sense will not give you back anything – garbage in, garbage out.
This course includes will give you knowledge that you would need within an Accounting function or department. Accounting professionals need Excel on a daily basis to produce reports, prepare financial statements including cashflows and registers, make reconciliations, organise data whilst also getting rid of the authentic calculator.

Objectives of this session

Session one will delve into the fundamentals of Excel and session two will build on that to explain basic formulae professionals can use, whilst also explaining keyboard shortcuts that will give the user more confidence in using this powerful tool. It’s a practical workshop were attendees are requested to bring their laptops with Windows (ideally with the latest Excel version installed to be able to follow all functions; some techniques might not work on mac). The attendees will be given an excel workbook with examples to use during the session.
After the session the attendee will be able to understand Excel better and master techniques that will make using Excel a piece of cake.

Topics on the agenda

- Fundamentals of Excel
- Choosing the keyboard over the mouse (for Microsoft Windows keyboard users only)
- Important formulae for the Accountant (including concatenate, date and time, splitting content in cells, difference between sum and subtotals, conditional formatting, data validation, pivot tables, vlookup and more)
- Tips when using Excel

Target audience

Finance analysts, Accountants with basic knowledge of excel, Accounting students, Clerks, Auditors, administrators, secretaries, individuals working with data.

Speaker’s profile

Pauline Micallef, the Technical Strategy Manager at the Malta Institute of Accountants (MIA), is a certified Public Accountant and a member of the MIA and the Association of Certified Chartered Accountants (ACCA). She acquired the ACCA qualification whilst working in the industry for over ten years. She then pursued a Masters in Business Administration from the University of Reading – Henley Business School. Over the years, she has implemented a number of ERP and Accounting systems and is a proficient user of Microsoft Excel that has trained a number of professionals.


6 Hours Professional


Terms and conditions apply


By Registering and/or Booking for this event, you agree that MIA will collect your information, who will be using it as per the MIA Privacy Policy for CPE Events. Please read the MIA’s Privacy Notice for CPE Events in its entirety which can be found at this link. By accepting to participate in this event you accept that MIA shall process personal data in accordance with this Privacy Notice.
If registration is being affected by a company or other corporate entity on behalf of an attendee or the registering company or other corporate entity supplies to the MIA personal data of third parties, such as of employees, affiliates, management companies or service providers, the registering company or other corporate entity shall be solely responsible for making sure that the provision of such data to the MIA fully complies with applicable laws and the relevant person in regard to whom the data relates has been provided with the necessary information at law regarding the MIA’s processing of his personal data.
Any information notices, consents or other applicable requirements that may be required to be fulfilled for the provision of third party data to the MIA shall be borne solely by the registering company or other corporate entity. The registering company or other corporate entity hereby fully indemnifies the MIA and shall render the MIA completely harmless against all costs, damages or liability of whatsoever nature resulting from any claims or litigation (instituted or threatened) by any third party against the MIA as a result of the provision of any third party personal data to the MIA by the registering company or other corporate entity.
The Malta Institute of Accountants may take photos during this event. These images will be used by the Institute to share news about the event in newsletters, the Annual Report, The Accountant journal and printed publicity. Photos can also be published on MIA’s Facebook, Linkedln and Twitter. Such images may be used to publicise future events of the same nature and for reporting purposes.


Suite 4, Level 1, Tower Business Centre, Tower Street, Swatar, BKR 4013, Malta 

E-mail: info@miamalta.org

Tel. +356 2258 1900