Courses in english

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 entitled to take the ECDL « Presentation » test free of charge.

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 entitled to take the ECDL « Word processing » test free of 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 entitled to take the ECDL « Spreadsheet » test free of charge.

Voir la fiche technique

C1321 - MS-Excel advanced

Public cible

Anyone wishing to acquire advanced skills in spreadsheet utilization.

Objectifs

• Manipulate the spreadsheet in an effective way.
• Manage the various types of links.
• Learn formula auditing and error checking.
• Work with nested function implementations and array definitions.
• Use and integrate lookup functions.
• Know the database management features of a spreadsheet.
• Use analysis and summarization tools.
• Manage scenarios.

Prérequis

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

Notes

Participants are entitled to take the ECDL « Spreadsheet advanced » test free of charge.

Voir la fiche technique

C1520 - Introduction to Internet of Things (IoT)

Public cible

Anyone willing to learn about the Internet of Things, commonly referred to as IoT, which is the network of physical objects, devices, vehicles, buildings,and other « things » with network connectivity that enables them to collect and exchange data which then becomes a powerful resource.

Objectifs

• Gain an understanding of what the IoT is and the requirements to design your own IoT solutions.
• Examine the concept of IoT.
• Learn how it works, and how to harness its power to improve business.
• Start developing IoT ideas in your environment
• Understand what constitutes an IoT design solution.
• Enable to leverage business and/or technical knowledge across IoT-related functions in the workplace.
• Examine cybersecurity and privacy issues.

Prérequis

None. It is however recommended to have a basic level of understanding of electronic circuit design, microcontrollers and programming languages, as well as knowledge of computer fundamentals.

C1521 - Introduction to Cybersecurity

Public cible

Anyone wishing to learn about the world of Internet security and who want to be literate in the field. Or for any professional responsible for security and privacy of company or customer systems.

Objectifs

• Learn what cybersecurity is and its potential impact to you
• Understand the most common threats, attacks and vulnerabilities.
• Learn how to protect your personal data and privacy online and in social media, and why more and more IT jobs require cybersecurity awareness and understanding.
• Learn what cybersecurity is and what it means for you personally and professionally.
• Learn how to be safe online by understanding the most common threats, attacks and vulnerabilities.
• Find out how businesses protect their operations from cyber-attacks

Prérequis

None.

C1522 - IT Essentials

Public cible

Anyone wishing to learn computer fundamentals, from building a computer to connecting it securely to a network. This module prepares for the CompTIA A+ Certification.

Objectifs

• Provide fundamentals of computer hardware and software as well as advanced concepts such as security, networking, and the responsibilities of an ICT professional.
• Develop working knowledge of how computers operate, how to assemble computers, and how to troubleshoot hardware and software issues on computers and mobile devices.
• Develop critical thinking and complex problem-solving skills with Hands-on labs and virtual learning tools using both real equipment and Cisco Packet Tracer. 
• Install and upgrade hardware and software and troubleshoot systems.
• Experiment with network designs and configurations with Cisco Packet Tracer simulation-based learning activities
• Identify common security threats like phishing and spoofing.

Prérequis

None.

Notes

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

C1530 - Cybersecurity essentials

Public cible

Anyone wishing to enter into the exciting security field and learn the basics to fight cybercrime.

Objectifs

• Understand security controls for networks, servers and applications.
• Learn valuable security principals and how to develop compliant policies.
• Implement proper procedures for data confidentiality and availability.
• Develop critical thinking and problem-solving skills using real equipment and Cisco Packet Tracer.
• Gain insight into the importance of cybersecurity and the integral role of cybersecurity professionals.
• Explore foundational cybersecurity principles, security architecture, risk management, attacks, incidents, cryptography and emerging IT technologies.

Prérequis

Succesful completion of the module "Introduction do Cybersecurity (C1521E) or proof of equivalent certified knowledge.

Notes

This course is recommended for candidates planning to study for the Cisco CCNA R&S, CCNA Cyber Ops or Cisco CCNA Security Certifications. No reduced price for unemployment possible.

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. Nonetheless, 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

C1612 - Concepts of creating dynamic Web pages using PHP

Public cible

Anyone wishing to learn how to create dynamic websites using the server-side scripting language PHP.

Objectifs

• Install and configuring a local web server as a development environment.
• Understand the differences between client-side and server-side programming languages.
• Get to know the different data types in PHP and learning how to use them.
• Create and editing strings and texts with PHP.
• Create HTML code with PHP.
• Create, checking and handle web forms with PHP.
• Send automatically generated emails with PHP.
• Upload files.

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

C1631 - Android Programming

Public cible

Anyone wishing to write programs for mobile devices running under Android operating system on the basis of their Java programming skills.

Objectifs

• Acquire an overview of Android.
• Install the needed software and running existing example applications.
• Create and test Android projects in Eclipse. Understanding the structure of the given project.
• Organize the screen. Different layouts.
• Event Handling - Invoking Activities.
• Networking under Android.
• Multi-threading.
• Graphics and Animations.

Prérequis

None. However, it is recommended to complete the module « Java crash course for programmers » (C1635E) or « Le langage Java : partie 1 » (C1040) and « Le langage Java : partie 2 » (C1041) prior to enroll to this module or to have equivalent certified knowledge.

Voir la fiche technique

C1634 - Wordpress, create a website without any programming

Public cible

Anyone whishing to create a website without programming knowledge.

Objectifs

• Install your website on a local server.
• Create, manage and optimize the content of the site.
• Customize the appearance of the site.
• Add media like images, video, etc.
• Create a navigation menu.
• Install and configure necessary plugins (Security, backup, functions, etc.).
• Referencing your site (SEO).

Prérequis

None.

C1635 - Java crash course for programmers

Public cible

Anyone wishing to learn Java using their knowledge of other programming languages. In this course the users are taught the core of Java language, which gives them a solid basis for learning more specific Java applications like Server Side programming, Android programming, Java Desktop programming.

Objectifs

• Java overview. Environment setup.
• Java syntax. Data types. Exceptions Handling.
• Classes and Objects, Interfaces.
• Inheritance, Overriding.
• Introduction to Swing.
• Multithreading.
• Files and I/O, Using JDBC.
• Networking, Clients and Servers, NIO (New Input Output).

Prérequis

None. However, participants should know the basic concepts of programming, data types, algorithms and be familiar with another programming language.

Voir la fiche technique

C1643 - Understanding and governance of information systems

Public cible

Anyone wishing 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

C2013 - Introduction to fund accounting

Public cible

Anyone wishing to apply and to develop their technical knowledge.

Objectifs

• Review the most common legal forms of company set up for the various investment funds.
• Find out the basic differences between the general accounting for commercial companies and the Fund Accounting.
• Consider the actors/agents of the investment funds, the components of the funds, their accounting, their valuation, etc.
• Understand the specificities of the umbrella funds and the multiple classes of shares/units.
• Gain understanding on the operations on portfolio and their accounting.
• Gain understanding on the operations on Fund capital and their accounting.
• Consider the estimation and provision of the investment fund fees and charges (type, agreements, calculation method, etc.).
• Perform calculation of the Net Asset Value of investment funds.

Prérequis

Successful completion of the module « General Accounting : current operations » (C2001E), « General accounting : year-end operations » (C2003E) and « Les valeurs mobilières : comprendre et investir » (C6014) or proof of equivalent certified knowledge.

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

C2020 - Financial mathematics on Excel

Public cible

Anyone wishing to be initiated on solving financial problems.

Objectifs

• Understand Algebra basis functions for Financial Mathematics : power, logarithm, time series, functions, etc.
• Understand how to write a mathematical formula, build a table with values, round numbers and plot a function with Excel.
• Understand how to apply simple and compounded interest rates as well as discount factor rates.
• Understand the difference between the equivalent interest rate and the proportional ones with respect to the duration.
• Understand how to compute the  yearly and monthly amount of a household credit and/or mortgage, the net present value and the internal rate of return concepts.
• Understand how to apply main financial function of Excel.
• Understand how to use Excel to solve financial problems.

Prérequis

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

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

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 and the practical implications of the main principles of personal data protection: lawfulness and fairness, transparency, integrity and knowing the different stages of compliance with the GDPR and 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, identify the personal data processor, Informing data subjects (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 the rights of the data subjectand the limits within which those rights can be exercised, as well as the principle of free and unambiguous consent.

Prérequis

None.

C4005 - Introduction to marketing

Public cible

Anyone wishing to better understand marketing and to learn to leverage the available tools.

Objectifs

• Define the marketing operations within one's company.
• Understand the operational marketing vs the strategic marketing.
• Understand the methods and tools for marketing research.
• Define the marketing plan.
• Understand consumers' behaviour.
• Understand and manage the marketing mix (4 Ps).

Prérequis

None.

Voir la fiche technique

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

C4025 - Communication on social networks

Public cible

Anyone wishing to develop its communication skills on social networks. Communication officers, entrepreneurs or independent.

Objectifs

• Master the basics of digital communication on social networks.
• Identify the social networks on which communicate according to their needs.
• Master the communication on Facebook.
• Master the communication on LinkedIn.
• Master the communication on Twitter.
• Leverage other social networks (Instagram, YouTube).
• Communicate an information on its website and link with social networks.

Prérequis

None. However it is recommended to complete the module « The basics of digital communication » (C4026E) prior to enroling to this module or to have equivalent knowledge.

Voir la fiche technique

C4026 - The basics of digital communications

Public cible

Anyone wishing to develop their knowledge of digital communication: manager, communication officer, 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).

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.

C5050 - Communicate with diplomacy, tact and credibility

Public cible

Business professionals wishing to act and to communicate in a positive and professional manner in every situation.

Objectifs

• Choose and use the most appropriate words and emotional tone for every business interaction.
• Gain insight into your communication style and the styles of others.
• Build skills to clearly and effectively receive and transmit information, ideas, thoughts, feelings and needs.
• Exercising conversational sensitivity, empathy, and perspective-taking.
• Protecting identity and self-concept of others in interaction.
• Developing accuracy in understanding nonverbal behavior.
• Managing self-disclosure and privacy appropriately.

Prérequis

None

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.

C6036 - The project management tools

Public cible

Anyone wishing to acquire the basic problem-solving tools and approach applied to processes or who has taken the project management course.

Objectifs

• Master problem-solving tools and being able to pragmatically apply them.
• Deepen complements of knowledge in the follow-up of a project.
• Understand the logic of improving a process.
• Learn teambuilding spirit.
• Understand the value of visual communication and its fundamental keys.
• Understand the basics of Lean and 6 sigma methodologies.

Prérequis

Successful completion of the modules «Project management essentials » (C6025) or proof of equivalent certified knowledge.

Notes

How to do when a project is late, and there is no additional budget or time? The tools learned in this module provide a complement to the project manager in the field of improving a process. Process in general and project management in particular.

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

C6050 - Financial instruments and markets

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 the main characteristics and risks of financial instruments and investment products;
• Understand the general economic background and its impact on financial markets and the value of investments;
• Understand transactions and their cost as well as specific market structures for stocks, bonds, currencies and commodities;
• Understand derivative instruments and their characteristics and use;
• Understand basic valuation principles of financial instruments and structured products.

Prérequis

None. However a basic understanding of financial mathematics such as interest rate compounding and discounting as well as basic statistics is recommended.

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.

C6053 - Data Protection: Governance and risk management

Public cible

This course is designed for those wishing to learn or increase their knowledge of risk management and governance in data protection and information security. It will be based on a theoretical and practical approach derived from audit, cybersecurity and information security frameworks, and will be complemented by practical case studies tailored to participants’ sector expertise.

Objectifs

• develop a basic knowledge of the principles and standards used in risk management;
• identify relevant risks;
• use acquired skills and a practical toolkit to help identify indicators of risk and aid the overall governance of data protection and information security in your organisation;
• implement the governance of data protection and information security in your organisation through the adoption and implementation of a risk-based approach;
• develop practical solutions in response to the challenges encountered during the implementation of a risk-based approach;
• carry out data impact assessments required by GDPR in certain circumstances.

Prérequis

No previous knowledge is required. All participants with an interest in data protection or GDPR are very welcome. The course will be tailored to suit the sector experience of course participants.

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.

C7001 - Warehouse management

Public cible

Anyone preparing to take up a position as stock manager, order pickers or wishing to enter a goods reception service or a quality insurance service.

Objectifs

• Define the concept of stock and storage.
• Know the characteristics of a warehouse and the layout and the organization specificities: the various spaces, activities, the issues faced by each warehouse sections, etc.
• Understand the actions carried out in warehouses areas and challenges of coordination between employees, be aware of the positive impact of a good.
• Understand the main tools and methods used in inventory management.
• Understand the common criteria and indicators to optimize supply planning and reduce storage costs
• Know the products specificities and handle products with regards of their specificities and the constraints.
• Get to know the regulatory constraints, and implement them accurately.
• Use the English and French specific vocabulary.

Prérequis

Successful completion of the module « Overview on the logistics sector » (C7000E) or proof of equivalent certified knowledge.

Voir la fiche technique

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

C7005 - The customs clearance (in a post-Brexit world)

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

CI1500 - CCNA 7 - Introduction to Networks Course Resources

Public cible

Anyone wishing to achieve a basic understanding of how networks operate and how to build simple local area networks (LAN), perform basic configurations for routers and switches, and implement Internet Protocol (IP).

Objectifs

• Configure switches and end devices to provide access to local and remote network resources.
• Explain how physical and data link layer protocols support the operation of Ethernet in a switched network.
• Configure routers to enable end-to-end connectivity between remote devices.
• Create IPv4 and IPv6 addressing schemes and verify network connectivity between devices.
• Explain how the upper layers of the OSI model support network applications.
• Configure a small network with security best practices.
• Troubleshoot connectivity in a small network.

Notes

Monday evenings from 18:00 - 20:00 (Theory) and Saturday mornings from 08:00 - 12:00 (Labs) or Monday evenings from 18:00 - 21:00 (Theory) and Thursday evenings 18:00 - 21:00 (Labs). Blended Learning : 60 hours face-to-face lessons and 10 hours distance learning. No reduced price for unemployment possible.

CI1501 - CCNA 7 - Switching, Routing, and Wireless Essentials Course Resources

Public cible

Anyone wishing to learn how to configure and troubleshoot routers and switches for advanced functionality using security best practices and resolve common issues with protocols in both IPv4 and IPv6 networks.

Objectifs

• Configure VLANs and Inter-VLAN routing applying security best practices and troubleshoot inter-VLAN routing on Layer 3 devices.
• Configure redundancy on a switched network using STP and EtherChannel.
• Troubleshoot EtherChannel on switched networks.
• Explain how to support available and reliable networks using dynamic addressing and first-hop redundancy protocols.
• Configure dynamic address allocation in IPv6 networks.
• Configure WLANs using a WLC and L2 security best practices.
• Configure switch security to mitigate LAN attacks.
• Configure IPv4 and IPv6 staic routing on routers.

Prérequis

Successful completion of the module «  CCNA 7 - introduction to Networks Course Resources » (CI1500E) or proof of equivalent certified knowledge.

Notes

Monday evenings from 18:00 - 20:00 (Theory) and Thursday evenings 18:00 - 21:00 (Labs). Blended Learning : 60 hours face-to-face lessons and 10 hours distance learning. No reduced price for unemployment possible.

CI1511 - CCNP 8 - Enterprise: Advanced Routing

Public cible

Anyone wishing to have an in-depth knowledge to support the implementation and troubleshooting of advanced routing technologies and services including layer 3 VPN services, infrastructure security and infrastructure services used in enterprise networks.

Objectifs

• Implement DHCP to operate acrooss multiple LANs and EIGRP for IPv4 in a small to medium-sized business network.
• Explain how advanced EIGRP features afect network performance.Troubleshoot common EIGRP configuration issues and EIGRPv6 issues.
• Explain how OSPF operates. Implement multiarea OSPF for IPv4 to enable internetwork communications.
• Troubleshoot connectivity issues in OSPFv2 and implement multiarea OSPFv3. Troubleshoot issues with OSPFv3 implementation.
• Configure GBP with advanced features and explain the processes used by BGP for path selection and troubleshoot BGP issues.
• Troubleshoot Route Maps and conditional forwarding issues, configure route redistribution between routing protocols, troubleshoot IPv4 and IPv6 route redistribution.
• Explain the impact of VFR and MPLS on trouting decisions, implement DMVPN tunnels, configure IPsec DMVPN with Pre-Shared Authentication.
• Toubleshoot ACLs and Prefix Lists, troubleshoot security threats to a network, troubleshoot Device Management and Management Tools.

Notes

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