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.

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 entitled to take the ECDL "Computer essentials " test free of charge.

Voir la fiche technique

C1301 - Online Essentials: MS-Outlook and the Web

Public cible

Anyone wishing to go online efficiently, for daily emailing and web browsing.

Objectifs

• Connect to a local network, to the Internet and to the Intranet.
• Understand web browsing and online security concepts.
• Use the web browser and manage browser settings, bookmarks and web outputs.
• Search effectively for online information and critically evaluate web content.
• Understand key copyright and data protection issues.
• Understand concepts of online communities, communications and email.
• Send, receive e-mails and manage email settings.
• Organize and search emails.
• Use calendars.

Prérequis

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

Notes

Participants are entitled to take the ECDL « Online essentials » 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

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

Voir la fiche technique

C1500 - CCNA - Introduction to Networks

Public cible

Anyone wishing to learn about the concept, the configuration and the maintenance of computer networks.

Objectifs

• Understand and describe the devices and services used to support communications in data networks and the Internet.
• Understand and describe the role of protocol layers in data networks.
• Understand and describe the importance of addressing and naming schemes at various layers of data networks in IPv4 and IPv6 environments.
• Design, calculate, and apply subnet masks and addresses to fulfill given requirements in IPv4 and IPv6 networks.
• Explain fundamental Ethernet concepts such as media, services, and operations and build a simple Ethernet network using routers and switches.
• Understand and use Cisco command-line interface (CLI) commands to perform basic router and switch configurations.
• Understand and utilize common network utilities to verify small network operations.
• Analyze data traffic.

Prérequis

None.

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) No reduced price for unemployment possible.

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 - 21:00 (Lab) and Thursday evenings from 18:00 - 20:00 (Theory). 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 Saturday mornings from 08:00 - 12: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

Tuesday 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

Tuesday 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

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. Once collected, this data 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.
• Understand what constitutes an IoT design solution.
• Start developing IoT ideas in your environment.
• 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 willing 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.

C1531 - CCNA – Cybersecurity Ops

Public cible

Objectifs

• Install virtual machines to create a safe environment for implementing and analysing cybersecurity threat events.
• Explain the Windows Operating System features and characteristics needed to support cybersecurity analyses.
• Explain the features and characteristics of the Linux Operating System.
• Classify the various types of network attack.
• Use network monitoring tools to identify attacks against network protocols and services.
• Explain the impacts of cryptography on network security monitoring.
• Apply incident response models to manage network security incidents.
• Deepen knowledge in how best to detect and respond to security incidents.
• Gain job-ready, practical skills in cybersecurity operations.
• Develop critical thinking and problem-solving skills using real equipment and Cisco Packet Tracer.
• Prepare the candidates for CCNA Cyber Ops Certification.
• How to monitor, detect and respond to cybersecurity threats.
• Covers cryptography, host-based security analysis, security monitoring, computer forensics, attack methods and incident reporting and handling.
• Prepare for the CCNA Cyber Ops Certification.

Prérequis

Successful completion of the module “Cybersecurity essentials” (C1530) or proof equivalent certified knowledge. The candidates should have the following knowledge or skills: Basic Windows and Linux system concepts; Basic Networking concepts; Binary and Hexadecimal understanding; Awareness of basic programming concepts; Awareness of basic SQL queries

Notes

Tuesday evenings from 18:00 - 20:00 (Theory) and Wednesday evenings from 18:00 - 21:00 (Labs).

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

C1610 - Introduction to programming

Public cible

Future programer or web developer, with no knowledge of programming, wishing to understand the common basics of modern programming languages.

Objectifs

• Learn the basics.
• Familiarize with algorithms.
• Discover programming languages.
• Apprehend the variables.
• Distinguish data types.
• Determine functions and procedures.
• Proceed to object based programming.
• Execute debugging.

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.

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

C1614 - Interactive Web pages with HTML, CSS, JavaScript, PHP and MySQL

Public cible

Anyone wishing to deepen their knowledge of previous courses from the Web Developer profile in order to be able to enhance the functionality of their Web pages.

Objectifs

• Understand and apply the fundamentals of object-oriented programming in PHP.
• Use PHP Frameworks.
• The cakePHP framework in practice.
• Interact Java Script PHP.
• Use advanced techniques such as AJAX and JSON.
• Create layouts, using jQuery, Bootstrap and ZURB Foundation.
• Create multilingual websites - internationalization and localization.
• Test and optimize the speed and performance of Web pages.
• Make use of advanced server configuration.

Prérequis

Successful completion of the module « PHP and MySQL web development » (C1613E) or proof of equivalent certified knowledge.

Voir la fiche technique

C1633 - Joomla: create your web pages only with a mouse

Public cible

Anyone wishing to learn how to use Joomla, the most known Content Management System, to create or to edit modern, easy to use websites without any programing knowledge.

Objectifs

• The concept of CMS systems.
• Downloading and installing Joomla; local and using a Web Hosting.
• Creating articles.
• Creating menus.
• Using of standard modules and components.
• Adding extensions. Installing plugins, modules and components.
• Managing the Home Page.
• Custom templates.

Prérequis

None. However knowledge of HTML or CSS will be an advantage.

Voir la fiche technique

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

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.

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

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

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

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

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

C4020 - How to establish and deliver a commercial business plan

Public cible

Everyone who wants to get an understanding of how a business strategy is build, and how to establish, deliver and implement a commercial business plan in practice.

Objectifs

• Identify the strategic objectives within a commercial environment, and conduct external and internal analysis.
• Define business objectives, and establish and implement a commercial business plan.
• Implement a commercial budgeting process, and learn how to measure results.
• Establish, implement and measure a yearly commercial action plan, including marketing, sales, communication and finance.
• Improve your personal analytical and entrepreneurial skills.
• Develop personal commercial leadership skills in a competitive environment.

Prérequis

None.

Voir la fiche technique

C4021 - The marketing and the digital age

Public cible

Professionnals, entrepreneurs and anyone wishing to discover the new digital marketing tools.

Objectifs

• Manage the new technologies related to marketing.
• Learn how to use the new media platforms and to leverage their marketing tactics.
• Manage the new marketing techniques and tools for the sales people.
• Analyse and manage digital communities.
• Implement and develop content marketing strategies.
• Develop mobile marketing tactics.

Prérequis

Successful completion of the module « Introduction to marketing » (C4005) or proof of equivalent certified knowledge.

Voir la fiche technique

C4023 - Generating traffic for your website

Public cible

Entry level digital communication professionals, Webmasters and anyone wishing to learn about Search Engine Optimization (SEO) or generate more traffic for their web site.

Objectifs

• Understand the basic rules of SEO.
• Master the main SEO criteria.
• Assess the SEO performance of a page or site.
• Use basic SEO tools.
• Understand how paid search programs are working.
• Improve the visibility or traffic of a page or site.

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

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

C5029 - Transition to management

Public cible

Anyone wishing to make the transition to a management position, looking to prepare for team management or wanting to improve the skills in this area.

Objectifs

• Define and identify the various forms of management.
• Define the role to be assumed by the manager of today according to the organization of the company.
• Become aware of the manager's power zone.
• Identify and implement management specific functions and tasks: to set objectives, to organize the work, to delegate, etc.
• Use the tools and basic managerial techniques.
• Influence team dynamics.
• Build and manage a team on a daily basis.

Prérequis

None.

Notes

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

Voir la fiche technique

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

C6003 - Economy and statistics

Public cible

Anyone wishing to understand how to design statistical indicators, how to interpret and challenge the statistics understanding.

Objectifs

• Understand the mathematical and statistical notations of variables.
• Understand how to compute and interpret statistical indicators over the time : unemployment rate, Gross Domestic product.
• Understand the computation of significant statistical indicators : Price indice.
• Understand the computation of central parameters : Average income, Median income.
• Understand how to compute and interpret the dispersion around the central parameters : standard deviation, decile, percentile.
• Understand the link between different statistical indicators : correlation between the salary and the seniority.
• Predict the evolution of simple statistical indicators.
• Perform statistical tests.

Prérequis

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

Voir la fiche technique

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.

C6032 - International trade challenged by globalisation

Public cible

Anyone willing to acquire knowledge in international trade and to get tools to understand and analysed the challenges and opportunities of the globalization or anyone interested in contemporary societal issues

Objectifs

• Understand the different concepts and the stages of globalization in the long term.
• Know the theoretical, traditional and recent tools that govern international trade.
• Get a common understanding of international trade and business.
• Understand the role of international organizations in regulating international trade.
• Analyze the strategy of multinational firms in globalization: motivation, dynamics and investments
• Determine the place of the developing countries in international economic relations.
• Understand the impact of raw materials values in the global economy.

Prérequis

None.

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

C7002 - Supply chain management

Public cible

Anyone preparing to take up a position as charterer, logistics agent, dispatch manager, flow manager or willing to enter a purchasing service, a transport organization service.

Objectifs

• Understand the logistics chain concept.
• Know the most common tools and methods used within this sector.
• Apprehend the process approach and understand the notion of flow.
• Understand the processes, the actions carried out at each steps and the challenges of better control of the logistics circuits: product quality, customer satisfaction, ecological footprint, etc.
• Know the different modes of transport, their specificities, their limits and the opportunities offered by their combination.
• Understand and analyze the concept of stream optimization and apply common associated methods: ERP or WMS management tools.
• Understand and apply cost management.
• Understand dashboards, design and select performance indicators.

Prérequis

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

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