The event is not active anymore.

The event Microsoft Excel in practice includes 3 modules that can be attended either separately or together.

Module 1: Beginner, Wednesday 10th November 2021, 9:00-11 AM Malta Time (GMT+1)

Module 2: Intermediate, Wednesday 24th November 2021, 9:00-11 AM Malta Time (GMT+1)

Module 3: Advance, Wednesday 15th December 2021, 9:00-11 AM Malta Time (GMT+1) 

 

Microsoft Excel is the most commonly used spreadsheet application. Microsoft Excel training is a training program that provides a practical approach to learn and understand the capabilities that Microsoft Excel can offer for the day-to-day use of Accountants and other professionals.

During our course we will delve into the various functions and applications that Microsoft Excel has to offer. Such functions and applications are listed in the ‘Training Topics’ section. These functions and applications will be covered
by the speakers in the form of practical workshops and at the end of the session, participants will be asked to complete a case study based on the different topics that would have been covered throughout the session.

Module 1: Beginner

Start Time: Nov 10, 2021 9:00 AM Malta Time (GMT+1) 

End Time: Nov 10, 2021 11:00 AM Malta Time (GMT+1)

Location Details: Online. A Microsoft Teams link will be sent to you following the registration. Kindly sign in 15 minutes before the beginning of the class.

Training topics:
• Introducing Microsoft Excel and practical use cases
• Tool bar explanation
• Using shortcuts to navigate Excel
• Introductory formulas such as SUM, AVERAGE, COUNT functions
• Introducing basic functions and formulas, such as filtering, sorting, freezing and grouping of cells
• Using formatting to present the data in line with the users’ preferences


Learning objectives:
• Work comfortably with Microsoft Excel 2016 and many of its features
• Be much quicker at carrying out regular tasks
• Use functions that will improve the quality of your work
• Be able to apply learned concepts in practical day-to-day use

This event has been accredited with 2 hours of structured CPE qualifying under the Professional development competency as per the Accountancy Board Accreditation Rules.

 

Module 2: Intermediate

Start Time: Nov 24, 2021 9:00 AM Malta Time (GMT+1) 

End Time: Nov 24, 2021 11:00 AM Malta Time (GMT+1)

Location Details: Online. A Microsoft Teams link will be sent to you following the registration. Kindly sign in 15 minutes before the beginning of the class.

Training topics:
• Dynamic formulas such as IF, IFS, AND, OR functions
• Use of pivot tables and conditional formatting
• Date formulas
• Use of VLOOKUP and HLOOKUP
• Other functions such as text-column function, autofill and flashfill
• Number manipulation, text manipulation and text cleaning functions
• Creating a chart on excel (line chart, pie chart etc.)

Learning objectives:
• Master the basics of Microsoft Excel
• Use sophisticated functions that will improve the quality of your work
• Be much quicker at carrying out regular tasks

This event has been accredited with 2 hours of structured CPE qualifying under the Professional development competency as per the Accountancy Board Accreditation Rules.

 

Module 3: Advance

Start Time: Dec 15, 2021 9:00 AM Malta Time (GMT+1) 

End Time: Dec 15, 2021 11:00 AM Malta Time (GMT+1)

Location Details: Online. A Microsoft Teams link will be sent to you following the registration. Kindly sign in 15 minutes before the beginning of the class.

Training topics:
• Dynamic formulas such as SUMIF, COUNTIF, INDEX, MATCH functions and many more
• Make use of data tables and goal seek functions
• Preparation of loan schedules
• Calculation of Net Present Value (NPV) and Internal Rate of Return (IRR)
• Automation of repetitive tasks using macros


Learning objectives:
• Build a solid understanding on the Basics of Microsoft Excel
• Learn the most common Excel functions used in the office
• Maintain large sets of Excel data in a list or table
• Harness the full power of Microsoft Excel by automating your day-to-day tasks

This event has been accredited with 2 hours of structured CPE qualifying under the Professional development competency as per the Accountancy Board Accreditation Rules.

 

Price for events:

Prices for each module are Euro 40 each. There are a number of discounts that you may benefit from:

  • If you choose to book two sessions, a 5% discount will apply.
  • If you choose to book three sessions, a 10% discount will apply.
  • If you book before 31 August, an additional early bird discount of 5% will apply.

Funding can be applied for from Jobsplus for Investment in Skills.

Contact: +356 2093 1810 / advance@mt.gt.com

Your trainers
Andrew Wait Andrew is an Executive at Grant Thornton engaged in the Transaction Advisory Services, a department specialising in corporate finance. He holds a Masters degree in Accountancy from the University of Malta. He has submitted a dissertation titled “Crowdfunding as an Alternative Source of Finance for Maltese Local Councils” in part-fulfilment of the degree. Andrew joined the advisory team on a full-time basis in July 2018. Within the team, his work primarily involves economics and corporate finance related projects. Consequently, he has worked on various market research, product development costings, economic impact assessments, risk analyses and business plans for private sector clients. He is also involved in the preparation of financial feasibility studies for private sector clients whilst also assisting government entities with financial feasibility studies and cost-benefits analyses for several projects, including the Malta Aviation Masterplan. Furthermore, he is also involved in supporting the drafting of Company Admission Documents for clients listing on Prospects MTF, a multi-lateral trading platform operated by the Malta Stock Exchange. In November 2020, Andrew commenced with working on compliance and internal audit related projects, both for private and public sector organisations. During his time at Grant Thornton, he was seconded for five months to the Malta Gaming Authority and two months to STC, where he assisted with process documentation and general accounting processes respectively.

Microsoft Excel in practice Grant Thornton Malta
  • Fort Business Centre, Level 2
  • Triq L-Intornjatur, Zone 1
  • Central Business District
  • Birkirkara CBD1050
  • Malta
Tel: +356 2093 1810 Contact: