Courses in english

C1300 - Office tools fundamentals

Public cible

Anyone wishing to use the Information and Communication Technologies (ICT), to manage the graphical interface Windows, to handle files on the computer and to discover the main purposes of the office tools. All candidates of profiles, l’avisé bureautique ; l’expert du traitement de texte : MS-Word ; L’expert du tableur : MS-Excel.

Objectifs

• Understand the essential concepts of the office tools.
• Work with the user environment.
• Master the management of files.
• Discover the bases of the spreadsheet.
• Learn the bases of the word processor.
• Use the general office automation features.
• Know how to produce first results with the spreadsheet and the word processor.

Prérequis

None.

Notes

Participants are allowed to pass the ECDL certification Computer essentials without any additional charge.

Voir la fiche technique

C1302 - MS-Powerpoint essentials

Public cible

Anyone wishing to use the features of a presentation software to quickly create professional presentations.

Objectifs

• Work with presentations and save them in different file formats.
• Swap between different presentation views and choose different slide layouts and designs.
• Insert and edit pictures, images, drawn objects and tables.
• Choose, create and format charts as well as art graphic elements.
• Improve the presentations by choosing the appropriate formatting options.
• Control the advanced concepts of themes and styles.
• Apply animation and transition effects to presentations.
• Setup and manage the slideshow navigation options.
• Print slides, notes and handouts.

Prérequis

It is recommended to complete the module « Office tools fundamentals » (C1300) prior to enroling for this course or proof of equivalent certified knowledge.

Notes

Participants are allowed to pass the ECDL certification « Presentation » without any additional charges.

Voir la fiche technique

C1310 - MS-Word essentials

Public cible

Anyone wishing to work with the basic features of a word processor.

Objectifs

• Work with documents and save them in different file formats.
• Create and edit small-sized word processing documents.
• Structure a document correctly and know the basic rules for the detection of the structure by the word processor.
• Check and correct spelling.
• Improve the documents by choosing the appropriate formatting options.
• Use existing styles of formatting.
• Insert tables, images and drawn objects into documents.
• Prepare documents for mail merge operations.
• Adjust document page settings before finally printing documents.

Prérequis

It is recommended to complete the module « Office tools fundamentals » (C1300) prior to enroling for this course or proof of equivalent certified knowledge.

Notes

Participants are allowed to pass the ECDL certification « Word processing » without any additional charge.

Voir la fiche technique

C1320 - MS-Excel essentials

Public cible

Anyone wishing to work with the features of a spreadsheet.

Objectifs

• Work with spreadsheets and save them in different file formats.
• Enter data into cells and use good practice in creating lists.
• Select, sort, copy, move and delete data.
• Manage rows and columns in a worksheet.
• Copy, move, delete and appropriately rename worksheets.
• Create mathematical and logical formulas.
• Use the basic integrated functions of the spreadsheet.
• Format numbers and text content in a spreadsheet.
• Choose, create and format charts to communicate information meaningfully.
• Adjust spreadsheet page settings before finally printing.

Prérequis

It is recommended to complete the module « Office tools fundamentals » (C1300) prior to enroling for this course or proof of equivalent knowledge.

Notes

Participants are allowed to pass the ECDL certification « Spreadsheet » without any additional charge.

Voir la fiche technique

C1322 - Project design : MS-Excel enhanced

Public cible

Anyone wishing to efficiently design a private or professional spreadsheet project.

Objectifs

• Methodical design of a new workbook.
• Personalization of the workspace.
• Working with large worksheets.
• Do calculations with any integrated spreadsheet function.
• Design user-friendly screens with the help of forms.
• Use macros for the automation of repetitive tasks.
• Integrate command buttons.
• Seek goals, work with the solver, include data tables and implement data protection.
• Realize and present a project.

Prérequis

Successful completion of the module « MS-Excel advanced » (C1321E) or proof of equivalent certified knowledge.

Notes

Participants are allowed to pass the ECDL certification « Spreadsheet advanced  » without any additional charge.

Voir la fiche technique

C1501 - CCNA - Routing and Switching Essentials

Public cible

Anyone wishing to start using the concept, the configuration and the maintenance of computer networks.

Objectifs

• Understand and describe basic switching concepts and the operation of Cisco switches, as well as enhanced switching technologies such as VLANs, VLAN Trunking Protocol, Rapid Spanning Tree Protocol, and 802.1q.
• Understand and describe the purpose, nature, and operations of a router and routing tables as well as configure and troubleshoot VLANs and inter-VLAN routing.
• Understand and describe dynamic routing protocols, distance vector routing protocols, and link-state routing protocols.
• Understand, describe, configure and troubleshoot access control lists (ACLs) for IPv4 and IPv6 networks.
• Understand, describe, configure and troubleshoot Network Address Translation (NAT) operations.
• Understand, describe, configure and troubleshoot the operations of Dynamic Host Configuration Protocol and Domain Name System for IPv4 and IPv6.
• Configure and troubleshoot basic operations of a small switched network and of routers in a small routed network as well as an Open Shortest Path First (OSPF) network.
• Configure and troubleshoot static routing and default routing (RIP and RIPng).

Prérequis

Successful completion of the module «  CCNA - introduction to networks » (1500E) or proof of equivalent certified knowledge.

Notes

Monday evenings from 18:00 - 20:00 (Theory) and Wednesday evenings from 18:00 - 21:00 (Labs). No reduced price for unemployment possible.

Voir la fiche technique

C1502 - CCNA - Scaling Networks

Public cible

Anyone wishing to deepen their knowledge of the concept, the configuration and the maintenance of computer networks.

Objectifs

• Understand and describe enhanced switching technologies such as Rapid Spanning Tree Protocol (RSTP) and Per VLAN Spanning Tree Plus Protocol (PVST+).
• Configure and troubleshoot Rapid Spanning Tree Protocol (RSTP).
• Understand, describe, configure and troubleshoot EtherChannel.
• Understand, describe, configure and troubleshoot first hop redundancy protocols (HSRP) in a switched network.
• Understand, describe, configure and troubleshoot wireless routers and wireless clients.
• Understand and describe routers in a complex routed IPv4 or IPv6 network using single-area OSPF, multiarea OSPF, and Enhanced Interior Gateway Routing Protocol (EIGRP).
• Configure and troubleshoot routers in a complex routed IPv4 or IPv6 network using single-area OSPF, multiarea OSPF, and Enhanced Interior Gateway Routing Protocol (EIGRP).
• Manage Cisco IOS® Software licensing and configuration files.

Prérequis

Successful completion of the module CCNA - routing and switching essentials (1501E) or proof of equivalent certified knowledge.

Notes

Monday evenings from 18:00 - 20:00 (Theory) and Thursday evenings from 18:00 - 21:00 (Labs). No reduced price for unemployment possible.

Voir la fiche technique

C1504 - CCNA - Security

Public cible

Anyone wishing to deepen their knowledge of computer network security.

Objectifs

• Implement AAA on Cisco routers using local router database and server-based ACS or Identity Service Engine (ISE).
• Implement firewall technologies to secure network perimeter.
• Implement IPS to mitigate attacks on networks.
• Secure endpoints and mitigate common Layer 2 attacks.
• Secure communications to ensure integrity, authenticity and confidentiality.
• Implement secure Virtual Private Networks.
• Implement an ASA firewall configuration using the CLI and an ASA firewall configuration and VPNs using ASDM.
• Test network security and create a technical security policy.

Prérequis

Succesful completion of the module «  CCNA - routing and switching essentials » (1501E) or proof of equivalent certified knowledge.

Notes

Weekday evenings from 18:00 - 20:00 (Theory) and Saturday mornings from 9:00 - 13:00 (Labs). No reduced price for unemployment possible.

Voir la fiche technique

C1510 - CCNP Routing and Switching: Routing

Public cible

Anyone wishing to develop an in-depth understanding and theoretical knowledge of advanced routing and switching.

Objectifs

• Implement, monitor, and maintain routing services in an enterprise network.
• Plan, configure, and verify the implementation of complex enterprise LAN and WAN routing solutions, using a range of routing protocols in IPv4 and IPv6 environments.
• Configurate secure routing solutions to support branch offices and mobile workers.
• Reinforce configuration skills.

Prérequis

Succesful completion of the module «  CCNA - connecting networks » (1503E) or proof of equivalent certified knowledge.

Notes

Weekday evenings from 18:00 - 20:00 (Theory) and Saturday mornings from 9:00 - 13:00 (Labs). No reduced price for unemployment possible.

Voir la fiche technique

C1600 - Organisational, legal and technical basics of the Internet

Public cible

Anyone wishing to become familiar with the concepts and services of the Internet.

Objectifs

• Becoming familiar with the vocabulary, concepts and services of the Internet.
• Understand the purpose of networks, their properties and tools.
• Becoming familiar with IP addresses, TCP protocols, DNS services, DHCP.
• Use and configure emails, programming FTP's and Browsers with helping tools.
• Know organizational processes and techniques to create and operate a web site.
• Get to know the different aspects of IT security against protection of WEB dangers.
• Acquire data protection skills based on confidentiality, integrity and availability.
• Create a HTML page using a tree structure and link mechanisms between different files.

Prérequis

None. However, it is recommended to complete the module « Creating web pages with HTML and CSS » (C1601) prior to enroll to this module or to have equivalent knowledge.

C1601 - Creating web pages with HTML and CSS

Public cible

Anyone wishing to create or edit modern, easy to use websites, who has no knowledge of HTML or cascading style sheets (CSS). To learn how to create web pages to create and the pages locally and to get the knowledge of standard html5 and the WAI standards.

Objectifs

• Understand the language in which web pages are created.
• Understand the basic structure of web pages.
• Build a system of web pages. Understand and create link connections between them.
• Write a proper source code for the created websites, using only text editors.
• Insert texts, images, lists. Create menus with links to other web pages.
• Understand the concept of user-friendly web pages.
• Understand and use the semantics of HTML.
• Create web pages using cascading style sheets (CSS).

Prérequis

None. However, it is recommended to complete the module « Organisational, legal and technical basics of the Internet» (C1600) or «Introduction to programming» (C1610) prior to enroll to this module or to have equivalent knowledge.

Voir la fiche technique

C1611 - User friendly web pages with JavaScript

Public cible

Anyone, working in a professional environment, wishing to create interactive and user-friendly websites using HTML and JavaScript.

Objectifs

• Acquire fundamental programming skills using JavaScript, a client-side language.
• Develop simple functions in JavaScript to make websites more interactive.
• Create user-friendly web forms.
• Check the data given by the user and displaying a corresponding message.
• Create a simple image gallery.
• Use JavaScript libraries such as jQuery.
• Find and correcting errors in JavaScript code using debugging tools.
• Improve the usability of a Web page.

Prérequis

Successful completion of the module « Creating web pages with HTML and CSS » (C1601E) and « Introduction to programming » (C1610E) or proof of equivalent certified knowledge.

Voir la fiche technique

C1613 - PHP and MySQL Web Development

Public cible

Anyone wishing to learn how to create dynamic websites using MySQL database and PHP and to extending their knowledge of PHP by using it with MySQL

Objectifs

Prérequis

Successful completion of the module « Concepts of creating dynamic web pages using PHP » (C1612E) or proof of equivalent certified knowledge.

Voir la fiche technique

C1643 - Understanding and governance of information systems

Public cible

Anyone who wishes to better understand the information system (IS) of one’s company, made up of computerised and non-computerised elements, in order to gather and map the processed data, and then put in place a governance ensuring the security of these data and the legal compliance of the processing.

Objectifs

• Understand the components of the information system of one's organisation.
• Explain and support compliance of one's IS.
• Establish the mapping of information flows : databases, software, paper documents, etc.
• Contribute to the action plan to develop one's IS and make it compliant with the principles of data protection.
• Accompany the creation of the records of processing activities and assess them.
• Set up the organisational and technical measures to ensure data are kept confidential and safe.
• Set up required procedures : privacy by design and by default, respect of data subjects' rights, data breach notification, etc.
• Ensure the means to guarantee the transparency and the traceability of the processing (accountability).

Prérequis

None.

C1644 - Spring Boot: Java on the server site

Public cible

Anyone wishing to develop dynamic, enterprise-class Web applications using Java on the server site. The objective of this course is learning how to use Java on the server site. We concentrate on the Spring Boot.

Objectifs

• Server site programming concept.
• Installing and configuring Spring Boot. Basics of Maven.
• MVC Architecture concept. Generating of an aplication.
• Controllers,  views, models in Spring Boot.
• Thymeleaf.
• Processing HTML forms.
• Accessing Data with JPA.
• Authentication and authorisation.

Prérequis

Successful completion of the module « Java crush course for programmers » (C1635E) or « Le langage Java: partie 1 » (C1040) and « Le langage Java: partie 2 » (C1041) or proof of equivalent certified knowledge.

C1645 - Ionic Framework - Mobile Apps with HTML, CSS & JS

Public cible

Anyone wishing to learn how to create mobile applications that work on multiple platforms i.e. iOS (iPhone, iPod, iPad, ), Android, Windows Phone, using HTML5, CSS and JavaScript. The objective of this course is learning how to write applications working on almost all mobile systems.

Objectifs

• The concept of Cordova. Environment setup.
• First Ionic application for Android and iOS.
• Angular. Typescript.
• Ionic UI components.
• Accessing the device - storage, camera, media.
• Ajax, Network connections.
• Using other native plugins.
• Creating a complex, multi platform application.

Prérequis

Successful completion of the module « Creating web pages with HTML and CSS » (C1601) and « User friendly web pages with JavaScript » (C1611) or proof of equivalent certified knowledge.

C2001 - General accounting : current operations

Public cible

Anyone wishing to learn the basics of accounting.

Objectifs

• Master the logic of double entry bookkeeping and understand the accounting system.
• Understand the balance sheet structure and learn to distinguish between assets and liabilities.
• Compute the results of the company (profits and losses).
• Use accounting tools : accounts, trial balances, journals, etc...
• Record current operations.
• Record invoices : purchase and sales invoices, credit notes, etc...
• Understand the mechanism of VAT.
• Learn to record bank statements.

Prérequis

None.

Notes

This course refers to the standardised Luxembourgish accounting chart.

C2002 - Accounting for non-accountants

Public cible

Anyone wishing to read and to understand annual financial statements, to become familiar with the accounting vocabulary and to learn the accounting mechanisms (e.g. lawyers, legal counsels, store and retail managers, secretaries, etc.).

Objectifs

• Get familiar with the accounting vocabulary and the legal and regulatory background.
• Understand the accounting mechanisms.
• Comprehend the logic links between the main documents: balance sheet, profit and loss accounts, accounting journals, account balance, etc.
• Discover the accounting principles.
• Understand the logic of amortisation, accounting provisions and booking value.
• Acquire notions to assess balance sheets.
• Read financial statements: balance sheet, profit and loss and notes to the accounts.

Prérequis

None.

Voir la fiche technique

C2003 - General accounting : year-end operations

Public cible

Anyone wishing to deepen their knowledge of the accounting system.

Objectifs

• Have notions of accounting principles.
• Treat off-balance sheet inventory.
• Master inventory changes (upstream/downstream, finished products, goods, stocks).
• Measure assets (depreciation, etc...).
• Account for disposals of assets.
• Account for provisions for risks and charges.
• Understand the mechanism of accruals and prepayments.
• Proceed with the closing of the accounts.

Prérequis

Successful completion of the module « General Accounting : current operations » (C2001E) or proof of equivalent certified knowledge.

Notes

This course refers to the standardised Luxembourgish accounting chart.

C2004 - Financial analysis

Public cible

Anyone wishing to learn the skills necessary in order to assess the financial health and performance of a company through examination of the financial statements and other information.

Objectifs

• Establish an assesment of the financial health of a business.
• Master the skills necessary to do so with regards to : analysis of financial activity; analysis of business structuring; and variance analysis.
• Learn how to restructure the presentation of financial information in order to facilitate analysis; statement of profit or loss, functional balance sheet, balance sheet, statement of cash flows.
• Calculate the main indicators of business health and performance: financing, and the ability to obtain financing; working capital and working capital requirements; solvency and liquidity.
• Know how to interpret this information.
• Propose solutions
•  for issues identified.

Prérequis

Successful completion of the module « General accounting : current operations » (C2001E) and « General accounting : year-end operations » (C2003E) or proof of equivalent certified knowledge.

C2005 - Calculation and accounting of wages

Public cible

Anyone wishing to know how to compute the different  parts of a salary (gross, social contributions, salary tax, net) and wishing to be able to book the salary entries.

Objectifs

• Determine the different parts of a salary: gross items due by the employer, social contributions, salary taxes, payable net.
• Determine the employer's social contributions.
• Know different steps of booking the salary entries.
• Verify the accounts based on the documents or files received by the administrations.
• Apply the salary continuation system in case of long-term sickness.
• Apply the regulatory administrative steps prior to hiring a new staff member.

Prérequis

Successful completion of the module « General accounting : current operations » (C2001E) or proof of equivalent certified knowledge. It is recommended to complete the module « Labor law: working conditions » (C3004) prior to enroling to this module.

Voir la fiche technique

C2014 - Advanced level of fund accounting

Public cible

Anyone wishing to apply and to develop their technical knowledge in fund accounting.

Objectifs

• Review the most used financial instruments, their specificities, valuation and impact on the NAV calculation.
• Gain a deeper knowledge of the operations on shares (corporate actions).
• Consider the different types of classes of Funds' shares/units (distribution, capitalisation, hedge, etc.).
• Understand the process of Funds' dividend distribution (calculation, registration and settlement).
• Manage the liquidation of classes of shares/units and compartment of Funds.
• Gain deep understanding of the specificities of the Fund NAV calculation subject to its portfolio, charges/fees, Fund type, etc.
• Find out the performance fees: estimation, provision, crystallisation, equalisation, etc.
• Find out other specificities such as «swing prices», «draw down», «Private Equity & Real Estate Funds», etc.

Prérequis

Successful completion of the module "Introduction to fund accounting" (C2013E) or proof of equivalent certified knowledge.

Voir la fiche technique

C2016 - Introduction to audit concepts

Public cible

Anyone wishing to be familiar with terminology, objectives and techniques of audit (internal and external) and be prepared to participate in an audit.

Objectifs

• Discover the basis: internal controls, internal audit, external audit/review.
• Understand the concept of internal controls.
• Practice internal controls skills through a case study.
• Understand the purpose and techniques of an internal audit assignment.
• Practice internal audit skills through a case study.
• Get familiar with external audit/review terminology.
• Practice external audit skills through a case study.
• Be prepared for an audit.

Prérequis

None.

Voir la fiche technique

C2021 - Budget and business plan management

Public cible

Finance managers, controlling managers, project managers and entrepreneurs, who are in charge of budgets and business plans.

Objectifs

• Understand the utility of a budget as a tool for managing business performance.
• Controlling the progress of a budgetary procedure: preparation, implementation follow-up and the use of dashboards.
• Learn how to put in place a management control system: strategic planning and operational objectives.
• Know how to develop a business plan: market analysis, business concept, internal organization and evaluation.
• Evaluate the feasibility of a project: self-financing capacity, cash, borrowing, pitfalls and traps.
• Learn to control the different elements of the financial component of a project (investments, financing, turnover, etc.).
• Operating expenses, VAT flows, working capital requirements, balance sheet and Profits and Losses forecasts.

Prérequis

Successful completion of the module « General Accounting : current operations » (C2001) and « General Accounting: : year-end operations » (C2003) or proof of equivalent certified knowledge. It is recommended to complete the module « Financial analysis » (C2004) or the module « Les techniques du contrôle de gestion » (C6009), prior to enroling to this module or to have equivalent knowledge.

C2023 - Fund Industry in Luxembourg

Public cible

Anyone wishing to be familiar with terminology, objectives and techniques of fund.

Objectifs

• Get an overview of general basic principles governing fund.
• Understand and define the different categories of fund.
• Know different functions around the fund.
• Know how to interpret the law.
• Be aware of the administrative procedure.
• Improve your personal analytical skills.

Prérequis

None.

Voir la fiche technique

C3001 - Overview of Luxembourg company law

Public cible

Anyone currently working or looking for a new position within a credit institution, fiduciary or related services provider, individuals wishing to expand their practical knowledge in Luxembourg Corporate Law or anyone interested in the functioning of company law in Luxembourg.

Objectifs

• Identify the key features of the different corporate entities in Luxembourg. Partnerships and capital companies.
• Learn more about some specificities of the Luxembourg Company Law such as the business permit.
• Identify the key features of S.A. and S.à r.l. as well as their similitudes and differences.
• Being able to prepare the relevant documentation for the setting up of a S.A. or a S.à r.l.
• Understand the decision making process and identify the relevant documentation to be drafted.
• Identify the different means of financing of a S.A. and a S.à r.l. and the Corporate Law implications.
• Understand the meaning of corporate tax residency and its application to Corporate Law.
• Implementing the most relevant means of company winding up (liquidation).

Prérequis

None. However it is recommended to complete the module « General accounting : current operations » (C2001E) or « Accounting for non-accountants » (C2002E) prior to enroling to this module or to have equivalent knowledge.

Voir la fiche technique

C3003 - Labour law: work contracts

Public cible

Anyone working in Human Resources, fiduciaries, law offices, etc. Persons who want to be aware of rights and responsibilities of employees and employers in this area, such as employee representatives, etc. Legal experts with foreign education backgrounds seeking to familiarise themselves with Luxembourg law.

Objectifs

• Distinguish between the various types of work contracts: CDD, CDI and others.
• Be able to prepare a CDD and CDI work contract.
• Understand all the rules in the area of CDD temporary contracts and other temporary employment contracts.
• Master the rules relating to trial periods.
• Know how to manage the various events that could arise during contract periods, such as modifications, illness and other events.
• Master the procedures and consequences of dismissals and resignations, to include reasons, disputes, process and unemployment.
• Understand the reasons for automatic termination of contracts: retirement, bankruptcy, long-term illnesses and others.

Prérequis

None.

Voir la fiche technique

C3004 - Labour law: working conditions

Public cible

Anyone working in Human Resources, fiduciaries, law offices, etc. People who want to be aware of rights and responsibilities of employees and employers in this area, such as employee representatives, etc. Legal experts with foreign education backgrounds seeking to familiarise themselves with Luxembourg law.

Objectifs

• Understand the legal stipulations in the area of compensation, to include minimum wage, indexing, the thirteenth month, in-kind benefits, payment times, etc.
• Know how to manage working hours: overtime, work plans, sliding timetables and work at night, work during bank holidays and on Sundays.
• Master the concepts relating to bank holidays.
• Understand how to manage leave: annual leave, maternity leave, settling-in leave, parental leave, exceptional leave, leave for family reasons, etc.
• Understand how employees' protection mechanisms regarding illness and pregnancy.
• Set up frameworks for monitoring at work.

Prérequis

None. However it is recommended to complete the module « Labour law : work contracts » (C3003E) prior to enroling to this module or to have equivalent knowledge.

Voir la fiche technique

C3047 - Individual income tax

Public cible

Anyone wishing to understand the basic mechanisms of individual taxation for professional or personal reasons.

Objectifs

• Get an overview of general basic principles governing individual taxation.
• Learn the computation mechanism of taxable income.
• Define the different categories of income and explain the computation of the net income in each category (commercial profit, profit from agriculture and forestry, are not covered by this course).
• Be familiar with provisions reducing the taxable basis : special expenses, extraordinary charges and allowances.
• Know how to compute personal income tax.
• Understand the concept of tax residency from a national and international point of view as well as the related consequences.
• Be aware of administrative procedures and tax claims.
• Analyse taxpayers' situations in order to determine a potential tax compliance obligation and/or option.

Prérequis

None.

Notes

Candidates must attend at least 10 sessions in order to be allowed to sit the exam.

C3048 - Value added tax

Public cible

Anyone wishing to understand the mechanisms of VAT.

Objectifs

• Understand the general history and mechanisms of VAT.
• Learn the 5 major concepts of VAT : the taxable person, the taxable operation, the place of supply, exemption and the person responsible for VAT.
• Distinguish between the supply of goods and the supply of services.
• Understand the principal VAT exemptions and VAT rates in Luxembourg.
• Understand concepts linked to the person responsible for VAT, including the chargeable event and taxable basis.
• Understand the processes for VAT recovery.
• Learn how VAT applies domestically or across borders, including on particular transactions : sale of goods, Real Estate and Financial Services.
• Description of the administrative procedures and compliance obligations related to VAT.

Prérequis

None.

Notes

Candidates must attend at least 10 sessions in order to be allowed to sit the exam.

Voir la fiche technique

C3049 - Corporate income tax

Public cible

Anyone wishing to learn the basic principles of direct taxes for corporations and partnerships in Luxembourg.

Objectifs

• Get to know the basic rules of the corporate income tax and the taxpayers subject to this tax.
• Get to know the basic rules of the municipal business tax and the taxpayers subject to this tax.
• Get to know the basic rules of the net wealth tax and the taxpayers subject to this tax.
• Understand the differences between accounting results and the tax result, and more specifically the  application of the participation exemption regime.
• Be aware of tax neutrality mechanisms in case of the restructuring of companies.
• Learn about the tax unity regime.
• Understand the concept of dividend distributions, hidden capital contributions and the consequences  of withholding tax.
• Get an overview of the administrative procedure and compliance matters.

Prérequis

Previous knowledge of accounting and tax law is recommended.

Notes

Candidates must attend at least 10 sessions in order to be allowed to sit the exam.

C3050 - International taxation

Public cible

Beginners of tax advisory firms and tax practitioners who aim to develop a good understanding of international taxation.

Objectifs

• Understand the principles of international taxation.
• Learn about the taxation of residents and non-residents under Luxembourg domestic tax law.
• Be aware of forms and reasons of double taxation and understand the role of tax treaties as a means to avoid double taxation.
• Learn about the taxation of specific kinds of income : interest, dividend, capital gain and intellectual property rights.
• Know about the applicability of tax treaties and learn to analyse taxing rights allocated under the OECD Model Convention as well as triangular tax cases in a tax treaty context.
• Understand the methods for elimination of double taxation.
• Be aware of tax aspects of extraordinary transactions such as mergers.
• Get an overview of the Special provisions of the OECD Model Convention and get acquainted with international tax planning.

Prérequis

None. However it is recommended to complete the module "Corporate income tax" (C3049E) prior to enroling to this module or to have equivalent knowledge.

Notes

Candidates must attend at least 10 sessions in order to be allowed to sit the exam.

Voir la fiche technique

C3051 - Introduction to Luxembourg law

Public cible

Anyone seeking to apply or to develop their knowledge in Luxembourg law, to understand the basics of law, the pillars of the Luxembourg state, its legal institutions, the procedures brought before these legal institutions and willing to acquire the know how to defend themselves in actions involving administrations, property laws and contract law.

Objectifs

• Get to know the pillars of the Luxembourg state, its legal institutions.
• Learn how laws are created.
• Understand the national, European and international legal environments through standards.
• Understand the legal structure of Luxembourg and the European Union.
• Know how to institute legal proceedings, understand their investigation and judgment processes.
• Know how to protect property rights.
• Understand and apply contract law.

Prérequis

None.

Voir la fiche technique

C3053 - General introduction to European Union law

Public cible

Anyone wishing to prepare a state examination, any civil servant or anyone willing to understand and to apply European law.

Objectifs

• Appreciate the distribution of powers between the EU and the Member States.
• Distinguish the EU institutions and other European organizations (OSCE, WEU, NATO, Council of Europe).
• Learn about European citizenship.
• Understand the decision-making processes and learn about the hierarchy of European norms, their primacy and direct effect (the relationship between EU law and national law).
• Understand the concept of free circulation, the functioning of the Common Market and the harmonization of legislation.
• Learn about free trade and discover the concepts of Freedom, Security and Justice in European Union law.
• Understanding economic and monetary union.
• Consider the European Union's place in the world common foreign and security policy, defense policy, trade policy and humanitarian aid.

Prérequis

None. However it is recommended to have notions of law.

C3055 - Legal framework for the protection of personal data and its challenges

Public cible

Anyone in charge of informing management, making recommendations, advising employees on the data protection rules to be respected and verifying that the relevant obligations are complied with.

Objectifs

• Knowing the key legislative texts.
• Understanding the practical implications of the main principles of personal data protection: lawfulness and fairness, transparency, integrity and confidentiality, accountability, data protection by design and by default.
• Knowing the different stages of compliance with the GDPR as well as the time required to implement them and integrate the components of the proof of conformity.
• Being able to map the processing to secure the processing circuits and the personal data.
• Understanding the apportionment of liability between the different actors in the personal data processing chain and identify the personal data processor.
• Informing data subjects (principle of transparency).
• Understanding the issues and risks of national and international data transfers and how to ensure the security of these transfers at the contractual level.
• Understanding contractual compliance: study of the various clauses to be used for the protection of personal data (information, consent, processing of personal data on behalf of the controller, general compliance of suppliers, employment contracts) and understanding of the limitation of liability limitation clauses.
• Understanding the rights of the data subjectand the limits within which those rights can be exercised.
• Understanding the principle of free and unambiguous consent and recognizing situations in which it is not necessary to obtain such consent (performance of a contract, unsolicited electronic communications).

Prérequis

None.

C3056 - Project Design: Data protection Best-practices

Public cible

Anyone willing to train on personal data management or improve its practices, at the level of an organization, a department or a specific service.

Objectifs

• Identify the points of attention relating to the protection of personal data.
• Formulate the right questions.
• Search information.
• Choose the right tools.
• Put the most appropriate tools in place.
• Acquire the good reflexes.

Prérequis

None. However, it is recommended to complete the module « Legal framework for the protection of personal data and its challenges » (C3055E) prior to enroling to this module or to have equivalent knowledge.

C4024 - Mobile communication

Public cible

Anyone wishing to develop its knowledge of mobile communication. Communication officers, entrepreneurs, independents.

Objectifs

• Master the basics of mobile communication.
• Identify the vectors of mobile communication.
• Master format of messages in mobile communication. Master pull and push to increase impact of mobile communication.
• Master communication through SMS, MMS or notifications. Knowing the value of mobile applications.
• Communicate through a mobile application.
• Measure the success of your mobile communication.

Prérequis

None.

Voir la fiche technique

C4026 - The basics of digital communications

Public cible

Anyone wishing to develop their knowledge of digital communication: manager, communications officers, web editor or small business leader.

Objectifs

• Define and develop a digital communication strategy.
• Analyze current digital communication strengths and weaknesses.
• Generate website traffic.
• Write for the web and editorial marketing.
• Establish a communication plan and be able to define success metrics .
• Understand current web and social media platforms and when they are effective.

Prérequis

None. However it is recommended to have basic understanding of the web and social media and some experience in a communication-related position.

Voir la fiche technique

C5019 - Introduction to sophrological relaxation techniques

Public cible

Anyone, especially people who suffer from stress or just want to evolve in their life.

Objectifs

• Discover sophrology, its theoretical principles and its techniques.
• Learn how to breathe properly and understand the importance of breathing.
• Learn and practise various relaxation techniques (belonging to the 1st degree of Sophrology relaxation techniques).
• Consciously (re)discover the body through the real-life experience (through sensations and movement).
• Focus on the positive side of reality and to integrate it consciously and gradually into the field of consciousness.
• Learn to concentrate over the present moment.
• Learn how to deal with stress problems.
• Help people to reach their goals by using very effective techniques.

Prérequis

None.

Notes

Please bring a gymnastics mat, a small pillow and a blanket (you may feel cold during the relaxation). It is recommended to wear a tracksuit (to feel at ease for the exercises).

C5036 - Self confidence

Public cible

Anyone wishing to understand the mechanism of self-confidence through the analysis of their internal way of functioning when facing not only various events but also different people. This course will permit you to turn restrictive emotions of doubt and negativity into energizing and positive emotions.

Objectifs

• Define self confidence.
• Identify the levels of self confidence.
• Know the limitations of self confidence and know how to identify and respond them.
• Understand what is holding you back from projects and desires realisation.
• Understand the source of shyness.
• Learn how to overcome fear of failure.
• Be comfortable at every moment and in all circumstances.
• Have a positive self-image and learn how to transform negative perceptions into positive ones.

Prérequis

None

Notes

It is crucial to follow the sessions in order to pass the exam.

Voir la fiche technique

C5048 - Working across cultures

Public cible

Business men and women wishing to navigate smoothly the many factors that make up any professional environment, including the country's culture, the corporate culture, the different work styles, and one's own personal style.

Objectifs

• Recognize the potential traps and opportunities of working in a cross-cultural context.
• Understand the influence of culture on individuals: how they work and communicate.
• Identify cultural communication preferences and take these into account.
• Determine the key skills and capabilities that come into play in a global environment.
• Discover how to upgrade these critical skill sets.
• Enhance your performance when it comes to managing projects, overall management and negotiations.
• Reduce stress and improve delicate relationships.
• Improve your leadership skills and your ability to head up an international team.

Prérequis

None.

Voir la fiche technique

C5049 - Powerful communication techniques

Public cible

Business professionals and anyone wishing to master one to one interactions and wishing to develop confidence and communication know-how for continued success.

Objectifs

• Uderstand the complex interplay between speaker, audience, relationship, and context in the communication process.
• Determine root causes of miscommunication and to find ways to neutralize them in the future.
• Identify and remove roadblocks to effective communication.
• Discover your personal communication style.
• Comprehending and demonstrating effective ways to listen.
• Demonstrating the intellectual capacity of relating effectively across contexts.
• Applying theories of interpersonal communication to practical interpersonal situations inside and outside the classroom.

Prérequis

None.

C5059 - Project communication and valorisation

Public cible

Anyone wishing to improve their communication at each stage of a project life cycle.

Objectifs

• Identify the characteristics of the different target groups: project sponsors, manager involved in the selection and business value assessment, project team members, intern partners, extern partners and end-users.
• Define a communication plan regarding the needs and the constraints of a project.
• Get to know the characteristics of the main communication tools.
• Appreciate the 4 main communication steps within a project lifecycle : The definition, the launch, the realization and the closure.
• Communicate to ensure the enrolment of project facilitators (internal and external).
• Communicate to enroll and to motivate the team.
• Get end-users involve to contribute to the acceptance of the project results implementation.
• Ensure regular communication on the project progress, and valorize the final results as well as the intermediate ones.

Prérequis

Successful completion of the module «  Project management essentials » (C6025E) or «  Advanced project management » (C6046E) and «  Budget and Business plan management » (C2021E) or proof of certified equivalent knowledge.

C5063 - Introduction to non-verbal communication

Public cible

Anyone willing to learn the basic mechanisms of non-verbal communication and wishing to understand the impact of non-verbal language in their personal and professional lives as well as to learn how to interpret the non-verbal language of others both in and out of the workplace.

Objectifs

• Evaluate the importance of non-verbal language in the interpersonal communication.
• Understand your own non-verbal language - what is its impact on others?
• Read the non-verbal language of the other people : what is its impact on your relationships and goals?
• Distinguish truth from falsehood using non-verbal communication cues.
• Analyse body language in all circumstances.
• Adapt your gestures to different contexts in order to better control your image.
• Learn how to highlight your personality (clothing, colors etc.) and how to effectively make use of space.

Prérequis

None.

Notes

It is crucial to follow the sessions in order to pass the exam

Voir la fiche technique

C5065 - Occupational Health and Safety Management: legislation and implementation

Public cible

Anyone wishing to discover and to implement the basic elements of a health and safety management system at work.

Objectifs

• Discover the Luxembourg legislation applicable in the context of health and safety at work.
• Understand the differences between danger, risk and evaluation.
• Identify on the main risks (road, work at height, psyco-social, etc.)
• Be able to manage and analyze the differents workers accidents.
• Implement the actions plans.
• Discover the main advantages of managements systems.

Prérequis

None.

C5066 - Awareness raising and communication

Public cible

Anyone willing to develop their knowledge and practices in raising awareness to employees from various departments, to communicate constructively and in a way that involves employees in continuous improvement and compliance with, in particular, standards or regulations, and report to high management or supervisory authorities.

Objectifs

• Characterise a communication situation.
• Understand the component and specifications of different types of communication.
• Analyse a communication situation.
• Gather information, use and develop communication tools relevant to the context.
• Design and develop awareness actions.
• Give constructive feedback.
• Manage to mobilise the group.

Prérequis

None.

C6025 - Project management essentials

Public cible

Project manager wishing to recall on basics in project management or anyone aspiring to become a project manager and wishing to acquire the basics of project management.

Objectifs

• Understand the theoretical bases of the project management and become familiar with key project management processes.
• Define a project and develop the project charter: structure and activities plan with respect to their dependencies and to resources availabilities.
• Learn the basic tools to identify and anticipate potential gaps versus planned ( PERT, GANTT, Critical Paths ).
• Follow the life of a project on the time and cost aspects ( OTOBOS).
• Run the main monitoring and control processes of a project.
• Understand the standards of project management, quality  of project management.
• Experience the opening and the closing process.

Prérequis

None.

C6045 - Daily information management

Public cible

Anyone wishing to search, manage and monitor information at home and/or in business environment.

Objectifs

• Understand the typology of information.
• Understand Web search tools.
• Manage information in your daily works.
• Easily communication of information.
• Setting-up an information monitoring plan.
• Use professional information in your project.
• Use professional information in your innovation management plan.

Prérequis

None.

Notes

Exercises on PC will allow the theoretical knowledge to be applied immediately.

Voir la fiche technique

C6049 - Audit and Compliance

Public cible

Professionals willing to know how to design and implement a proper enterprise risk management system with a focus on governance, and key internal control functions approach and tools.

Objectifs

• Identify the key rules of a proper enterprise governance.
• Approach the international standards in matter of risk assessment.
• Know how to implement a proper enterprise risk management system.
• Develop key tools for a tailored-made a risk based approach.
• Know how to design and communicate a control program.
• Know how to design a Data Privacy Impact Assessment (DPIA).

Prérequis

None. However it is recommended to have good knowledge of any kind of legislative module.

Voir la fiche technique

C6051 - Managing and selling investment products

Public cible

Professionals of the financial sector providing investment information or investment advice within the definition of the EU second directive on Financial instruments and markets.

Objectifs

• Understand and manage financial risk.
• Understand risk and return.
• Understand modern portfolio theory and diversification.
• Understand reality versus rational financial behavior.
• Understand and evaluate data and documents regarding a given investment product with respect to the risk profile of the investor.
• Understand performance and risk measurement.
• Understand the difference between historical performance and forecasting.
• Understand the main characteristics of and differences between active, passive and alternative portfolio management.

Prérequis

Successful completion of the module « Financial instruments and markets » (C6050) or proof of equivalent certified knowledge.

C6052 - Introduction to alternative investments

Public cible

Available soon

Objectifs

C7000 - Overview on the logistics sector

Public cible

Anyone currently active in the sector wishing to establish his / her understanding of the sector and to take advantage of the possibilities of internal mobility to develop his or her job, or anyone considering retraining in this sector.

Objectifs

• Learn about the origin, the evolution and the scope of the logistics core-concept.
• Define the components of this sector, its challenges and its opportunities in Luxembourg.
• Get an overview on the logistics functions: supply, production, distribution and demand management.
• Identify the jobs and the profiles opportunities.
• Understand the organizations and types of logistics companies: logistics and transport, industrial logistics, health services, events, etc.
• Understand the concept of operations management, warehouse management and transportation management.
• Use the English and French specific vocabulary.

Prérequis

None.

C7003 - Introduction to purchases

Public cible

Purchasing managers and buyers, purchasing officers and top managers

Objectifs

• Understand the role of the purchasing department and the buyer in the organization.
• Know the most common tools and methods used identify KPI and improvement actions for the purchasing function.
• Apprehend the different phases of the purchasing processes from the strategic to the operational ones.
• Understand and enhance the economic and financial impact of purchasing.
• Learn the techniques applied for the spend analysis.
• Learn the tools and methods used to select and evaluate suppliers.
• Know the most important trends in terms of Information and Communication Technology (ICT) and globalization for Purchasing.
• Learn the approaches to reduce the supply risks in global sourcing.

Prérequis

None.

Voir la fiche technique

C7004 - The basic guide to exporting or importing

Public cible

Anyone wishing to acquire knowledge and develop skills on the management of import or export operations from the commercial and technical point of view, in order to get started. Finance Department / Executives and Employees. Sales Management Department / Executives and Employees. Sales or Sourcing Department / Executives and Employees.

Objectifs

• Understanding the fundaments of export ou import operations to increase your chances of success.
• Mastering the basics of Incoterms® to know when and how to use them.
• Building an efficient export (or import) marketing plan to identify your potential clients (or suppliers).
• Delivering/receiving your order and making sure to be properly insured.
• Understanding the main components of an (export or import) customs declaration.
• Issuing knowingly a proper invoice and securing the international payments.
• Understanding the main export/import documentation.
• Keeping a watch on recent trends.

Prérequis

None.

Voir la fiche technique

C7005 - The basics of customs clearance

Public cible

Anyone willing to acquire knowledge and develop skills on the management of import or export operations (technical, administrative, commercial, legal, human, financial aspects).

Objectifs

• Understanding the Customs (role and process).
• Mastering the fundaments of Incoterms.
• Using the Incoterms® properly, by mastering their advantages and limits.
• Understanding the main components of an (export or import) customs declaration.
• Determining the fundamental triangle Code-Origin-Value.
• Choosing the right customs status for the exported/imported goods.
• Choosing the appropriate customs procedure.
• Understanding the main export/import documents.

Prérequis

None.

Voir la fiche technique