- Global site
- Africa
- Americas
- Asia Pacific
- Europe
- Middle East
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
- Fort Business Centre, Level 2
- Triq L-Intornjatur, Zone 1
- Central Business District
- Birkirkara CBD1050
- Malta