Excel Mastery for Geeks: Real-World Formulas, Pivot Tables and Advanced Features
2024-12-17 09:00 - 17:15 (Europe/Athens) | Ground-Based/ UNIC Global Training, 46 Makedonitissis Avenue, Nicosia, 2417, Cyprus
17 of December 2024

CPD hours: 7
Aim
The aim of the course is to provide participants with comprehensive Excel skills, enabling them to implement and interpret formulas in real-world scenarios, master essential and advanced logical functions, and apply the most suitable formulas for various tasks. Participants will learn to work with simple and nested formulas, pivot tables, format data smartly and clean data effectively. Additionally, the course covers the use of wildcards, hyperlinks, tables, and other advanced features. By introducing the latest Excel functions and pivot tables, the course aims to transform participants into Excel experts, making them the coolest geeks in their office.
Participants’ Profile
The seminar is ideal for professionals who use Excel regularly and seek to enhance their skills, including business analysts, financial analysts, data scientists, project managers, administrative professionals, and anyone involved in data management and analysis. It is particularly beneficial for those who want to master real-world formula implementation, advanced data formatting, and new Excel functions. Whether you are an experienced Excel user aiming to become more efficient or a novice eager to learn advanced techniques, this seminar will provide valuable insights and practical skills to elevate your Excel Proficiency.
Certification
All participants will be awarded a certificate. Each hour of attendance will account for one unit of Continuing Professional Development (CPD) as required for members of most professional bodies.
Download Seminar ProgrammePre-Register Form

Principles of International Taxation
2024-12-18 09:00 - 17:15 | Live Online
18 of December, 2024

CPD hours: 7
Aim
As access to the global marketplace grows with cross border transactions, it is vital to expand and improve your knowledge of the tax laws and systems pertaining to the various markets as well as to explore various techniques in international tax planning. To minimize the tax burden on income and profits for you and your clients, acceleration of your understanding of critical tax laws and regulations affecting cross-border transactions is essential.
This seminar has been specifically designed to meet the needs of professionals from various backgrounds who wish to develop their competence in the field of International Taxation, and benefit from the credibility that this expert knowledge will afford them.
Participants’ Profile
This seminar is addressed to:
• Financial Controllers
• Accountants
• Tax Consultants
• Bankers and Banking Executives
• Government Tax Officials
• Lawyers
Certification
All participants will be awarded a certificate. Each hour of attendance will account for one unit of Continuing Professional Development (CPD) as required for members of most professional bodies.
Download Seminar ProgrammePre-Register Form

Practical Workshop on Transfer Pricing
2024-12-19 09:00 - 17:15 | Live Online
19 of December, 2024

CPD hours: 7
Aim
The tax environment is continually evolving, and for those responsible for managing the tax liabilities of their organization or for giving tax advice to clients, keeping abreast of such changes is paramount. New tax rules invariably penalize the unwary, but at the same time present rewards and opportunities to the informed. The Aim of the seminar is to familiarize participants with the practical approach of the transfer pricing issues.
Objective
The main objective of the seminar is to provide a clear understanding of the transfer pricing regulation in Cyprus and international with the practical cases and thus help the participants develop their tax planning abilities. The seminar, through real case studies will assist participants apply knowledge and identify the impact of the transfer pricing on financial decisions that need to be taken.
Participants’ Profile
This seminar is addressed to:
• Financial Controllers
• Accountants
• Tax Consultants
• Auditors
It will be of particular interest to newly qualified accountants and who need to familiarize themselves with local taxation issues.
Certification
All participants will be awarded a certificate. Each hour of attendance will account for one unit of Continuing Professional Development (CPD) as required for members of most professional bodies.
Download Seminar ProgrammePre-Register Form

NEW: Corporate Sustainability Reporting Directive (CSRD): An Overview, Key Developments and Implications for Professional Accountants
2024-12-20 09:00 - 13:15 | Live Online
20 of December, 2024

CPD hours: 4
Aim

This seminar covers the directive’s purpose and significance, key developments, and policy objectives. Participants will explore the European Sustainability Reporting Standards (ESRS) and specific reporting requirements. We will review the scope and phased implementation timeline, including key deadlines. The seminar will also delve into sustainability assurance requirements, examining the roles of statutory auditors and independent assurance providers. Finally, we will discuss the integration of CSRD into national laws in Cyprus, including legislative amendments and auditor requirements.

Objective
To provide a comprehensive understanding of the Corporate Sustainability Reporting Directive (CSRD) and its implications for businesses within the European Union. Participants will gain insights into the key developments, policy objectives, and reporting standards mandated by the CSRD. The seminar will also cover the scope and timing of implementation, the requirements for sustainability assurance, and the specific steps being taken to integrate these regulations into national laws, with a focus on Cyprus. Attendees will leave equipped with the knowledge needed to comprehend the new sustainability reporting landscape and the implications it will have on the accounting profession.
Participants’ Profile
Accountants, auditors and professionals involved in the implementation of sustainability reporting.
Certification
All participants will be awarded a certificate. Each hour of attendance will account for one unit of Continuing Professional Development (CPD) as required for members of most professional bodies.
Download Seminar ProgrammePre-Register Form

NEW: IFRS Insights - The Art of Consolidation
2024-12-20 09:00 - 17:15 | Live Online
20 of December, 2024

CPD hours: 7
Aim
The aim of this seminar is to provide participants with an in-depth understanding of the principles, methodologies, and practical applications of consolidation in accordance with International Financial Reporting Standards (IFRS). This comprehensive seminar is designed to equip attendees with the essential knowledge and skills required to prepare consolidated financial statements, ensuring full compliance with IFRS and significantly enhancing the quality and reliability of financial reporting. The seminar intends to cover all advanced aspects of consolidated financial statements, reviewing Piecemeal Acquisitions, Partial Disposals, Complex Groups and Foreign Operations.
Participants’ Profile
The seminar is addressed to financial controllers of groups and individual companies, accountants, and auditors with either professional qualifications or relevant experience in preparing, analyzing and presenting financial statements.
Certification
All participants will be awarded a certificate. Each hour of attendance will account for one unit of Continuing Professional Development (CPD) as required for members of most professional bodies.
Download Seminar ProgrammePre-Register Form
