Courses in english

C1055 - Spreadsheets 2 : MS-Excel for Windows

Durée

10 semaines, 3 heures/sem.

Public cible

Every person interested in learning the advanced features of Excel.

Objectifs

• Manipulate the spreadsheet in an effective way.
• Learn the various types of links.
• Check the contents of the cells in the spreadsheet.
• Use and integrate advanced functions.
• Work with lookup functions.
• Know the database management features of a spreadsheet.
• Use the analysis tools.
• Manage scenarios.

Prérequis

Successful completion of the module « Spreadsheets 1 : MS-Excel for Windows » (C1054) or proof of equivalent knowledge.

Notes

Participants are allowed to pass the « Spreadsheets » test of the ECDL without any additional charge.

Voir la fiche technique

C1056 - Spreadsheets 3 : MS-Excel for Windows

Durée

10 semaines, 3 heures/sem.

Public cible

Every person interested in perfecting his or her knowledge by designing a project.

Objectifs

• Methodical design of a new workbook.
• Personalization of the workspace.
• Working with large worksheets.
• Do calculations with any integrated spreadsheet functions.
• Design userfriendly screens with the help of forms.
• Use macros for the automation of repetitive tasks.
• Integrate command buttons.
• Realization and presentation of a project.

Prérequis

Successful completion of the module « Spreadsheets 2 : MS-Excel for Windows » (C1055) or proof of equivalent knowledge.

Notes

Participants are allowed to pass the « Spreadsheets » test of the ECDL without any additional charge.

Voir la fiche technique

C1300 - Office tools fundamentals

Public cible

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

Objectifs

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

Prérequis

None.

Notes

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

Voir la fiche technique

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 course or proof of equivalent certified knowledge.

Notes

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

Voir la fiche technique

C1302 - MS-Powerpoint essentials

Public cible

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

Objectifs

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

Prérequis

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

Notes

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

Voir la fiche technique

C1310 - MS-Word essentials

Public cible

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

Objectifs

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

Prérequis

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

Notes

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

Voir la fiche technique

C1311 - MS-Word advanced

Public cible

Anyone wishing to acquire advanced skills in word processor.

Objectifs

• Work with models and styles.
• Accelerate daily tasks through quick parts and personalized templates.
• Divide large documents in sections.
• Navigate the structure of a document by using hierarchical outlines.
• Create and number all type of references.
• Explore advanced table features.

Prérequis

Successful completion of the module «MS-Word essentials» (C1310) or proof of equivalent knowledge.

Notes

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

C1312 - Project design : MS-Word enhanced

Public cible

Anyone wishing to efficiently design a private or professional word processing project.

Objectifs

• Create and use forms.
• Work with bookmarks, links and cross references.
• Control the features of advanced mass mailing.
• Collaborate on documents and use comments to manage modifications.
• Explore automation features like macros.
• Personalize the word processor, the tool bars and the ribbon.
• Share documents and apply document security features.
• Realize and present a project.

Prérequis

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

Notes

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

Voir la fiche technique

C1320 - MS-Excel essentials

Public cible

Anyone wishing to work with the features of a spreadsheet.

Objectifs

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

Prérequis

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

Notes

Participants are allowed to pass the ECDL certification « Spreadsheet » without any additional 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 allowed to pass the ECDL certification « Spreadsheet advanced » without any additional charge.

Voir la fiche technique

C1322 - Project design : MS-Excel enhanced

Public cible

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

Objectifs

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

Prérequis

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

Notes

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

Voir la fiche technique

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 Wednesday evenings from 18:00 - 21:00 (Labs).

Voir la fiche technique

C1501 - CCNA - Routing and Switching Essentials

Public cible

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

Objectifs

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

Prérequis

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

Notes

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

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 Wednesday evenings from 18:00 - 21:00 (Labs).

Voir la fiche technique

C1503 - CCNA - Connecting Networks

Public cible

Candidates who wish to deepen their knowledge of the concept, the configuration and the maintenance of computer networks.

Objectifs

• Describe different WAN connections and technologies and their benefits.
• Describe the operations and benefits of virtual private networks (VPNs) and tunneling.
• Analyze, simulate and design network architectures.
• Understand borderless networks and the characteristics of Data centers and of virtualization.
• Understand collaboration technology and solutions.
• Configure and troubleshoot serial and broadband connections.
• Configure and troubleshoot IPSec tunneling operations.
• Monitor and troubleshoot network operations using syslog, SNMP, and NetFlow.

Prérequis

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

Notes

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

Voir la fiche technique

C1504 - CCNA - Security

Public cible

Anyone wishing to deepen their knowledge of computer network security.

Objectifs

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

Prérequis

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

Notes

Weekday evenings from 18:00 - 20:00 (Theory) and Saturday mornings from 9:00 - 13:00 (Labs).

Voir la fiche technique

C1510 - CCNP Routing and Switching: Routing

Public cible

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

Objectifs

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

Prérequis

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

Notes

Weekday evenings from 18:00 - 20:00 (Theory) and Saturday mornings from 9:00 - 13:00 (Labs).

Voir la fiche technique

C1511 - CCNP Routing and Switching : Switching

Public cible

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

Objectifs

• Implement, monitor, and maintain switching in converged enterprise campus networks.
• Plan, configure, and verify the implementation of complex enterprise switching solutions.
• Understand the secure integration of VLANs, WLANs, voice, and video into campus networks.
• Reinforce configuration skills.

Prérequis

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

Notes

Weekday evenings from 18:00 - 20:00 (Theory) and Saturday mornings from 9:00 - 13:00 (Labs).

Voir la fiche technique

C1512 - CCNP Routing and Switching : Troubleshooting

Public cible

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

Objectifs

• Monitor and maintain complex, enterprise routed and switched IP networks.
• Plan and execute regular network maintenance.
• Support and troubleshoot using technology-based processes and best practices, based on systematic and industry recognized approaches.
• Reinforce troubleshooting techniques.

Prérequis

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

Notes

Weekday evenings from 18:00 - 20:00 (Theory) and Saturday mornings from 9:00 - 13:00 (Labs).

Voir la fiche technique

C1600 - Organisational, legal and technical basics of the Internet

Public cible

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

Objectifs

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

Prérequis

None.

C1601 - Creating web pages with HTML and CSS

Public cible

All persons who want to create or edit modern, easy to use websites, but have 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.
• Understanding the basic structure of web pages.
• Building a system of web pages. Understanding and creating  link connections between them.
• Writing a proper source code for the created websites, using only text editors.
• Inserting  texts, images, lists. Creating menus with links to other web pages.
• Understanding the concept of user-friendly web pages.
• Understanding and using  the semantics of HTML.
• Creating  web pages using cascading style sheets (CSS).

Prérequis

Successful completion of the module « Organisational, legal and technical basics of the Internet  » (C1600) or proof of 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.

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. The objective of this course is learning Java Script as the first programming language. Practical use of Java Script to create web pages more attractive and user friendly.

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 à la programmation » (C1610) or proof 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 « User friendly web pages with JavaScript » (C1611E) or proof of equivalent 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 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 learn how to use the knowledge of HTML, CSS, JavaScript, PHP and MySQL in order to create professional web systems. Practical learning of PHP and JS frameworks.

Objectifs

• Understand and apply the fundamentals of object-oriented programming in PHP.
• Use PHP Frameworks.
• 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.
• Make use of advanced server configuration.
• Test and optimize the speed and performance of Web pages.

Prérequis

Successful completion of the module « PHP and MySQL Web Development » (C1613) or proof of equivalent knowledge.

Voir la fiche technique

C1630 - Using Java on the server site : Servlets and JavaServer Pages

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 Servlets and Java Server Pages.

Objectifs

• Server site programming concept - Servlet and JSP technology.
• Installing and configuring a servlet container.
• Servlet basics.
• Client requests - Server response.
• Processing HTML forms.
• JavaServer Pages : JSP.
• JavaBeans components in JSP and sessions in Servlets and JSP.
• Servlets and JSP how to integrate MVC Architecture and using JDBC.

Prérequis

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 enroling for this course 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 testing 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

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 enroling or proof of equivalent certified knowledge.

Voir la fiche technique

C1632 - Creating Multi-Platform Mobile Applications with HTML5, CSS and JavaScript

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.

Objectifs

• The concept of Cordova Environment setup.
• One code - multiple platforms.
• Creating apps on your Computer.
• Using PhoneGap Build infrastructure.
• Access the device - storage, camera, media.
• Use frameworks: jQuery Mobile, Framework7.
• Use Ajax, Network connections.
• Create a complex, multi platform application.

Prérequis

It is recommended to complete the module "Creating web pages with HTML and CSS" (C1601E) and "User friendly web pages with JavaScript" (C1611E) prior to enroling for this course or proof of equivalent certified knowledge. A good knowledge of HTML5, CSS and JavaScript is necessary.

Voir la fiche technique

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

Public cible

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

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

Participants should know the basic concepts of programming, data types, algorithms. They should 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 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

C2007 - Analytical accountancy

Public cible

Anyone wishing to learn and apply the skills necessary in order to establish the financial health and performance of a company through examination of the financial statements and other information, and establish how said analysis can affect the decision making of the users of such information.

Objectifs

• Establish a comprehensive overview of the financial situation of an entity with reference to Gearing, Liquidity, and Investment performance.
• Select and apply various decision making techniques in order to maximise efficiency of resources.
• Understand how risk and uncertainty are incorporated into decision making techniques, and how said risks are managed.
• Understand the key methods of investment appraisal.
• Identify appropriate techniques of business and asset valuations.
• Apply appropriate budgeting techniques, and establish alternative sources of business finance.

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.

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

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

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 - Labor 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 - Labor 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 « Labor law : work contracts » (C3003E) prior to enroling to this module or to have equivalent knowledge.

Voir la fiche technique

C3047 - Individual income tax

Public cible

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

Objectifs

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

Prérequis

None.

Notes

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

C3048 - Value added tax

Public cible

Anyone wishing to understand the mechanisms of VAT.

Objectifs

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

Prérequis

None.

Notes

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

Voir la fiche technique

C3049 - Corporate income tax

Public cible

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

Objectifs

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

Prérequis

Previous knowledge of accounting and tax law is recommended.

Notes

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

C3050 - International taxation

Public cible

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

Objectifs

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

Prérequis

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

Notes

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

Voir la fiche technique

C3051 - Introduction to Luxembourg law

Public cible

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

Objectifs

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

Prérequis

None.

Voir la fiche technique

C3053 - General introduction to European Union law

Public cible

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

Objectifs

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

Prérequis

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

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

C4026 - The basics of digital communications

Public cible

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

Objectifs

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

Prérequis

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

Voir la fiche technique

C5019 - Introduction to sophrological relaxation techniques

Public cible

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

Objectifs

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

Prérequis

None.

Notes

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

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 not possible to register for the exam path to validate this module.

Voir la fiche technique

C5047 - Self-Management: focused on resources and target

Public cible

Anyone wishing to optimize their path to target realization.

Objectifs

• Discover some relevant aspects concerning the psychology of motivation.
• Understand the connection of individual inner processes and the "role conception" (based on Transactional Analysis).
• Develop the comprehension of the connection of (pesonal) needs, motivation and negotiation-attitude.
• Understand of passive and active attitude.
• Exercise with a personal target (definition).
• Consolidate the personal target.
• Deal with opposition and clear up with resistances concerning the target.

Prérequis

None.

Voir la fiche technique

C5048 - Working across cultures

Public cible

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

Objectifs

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

Prérequis

None.

Voir la fiche technique

C5049 - Powerful communication techniques

Public cible

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

Objectifs

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

Prérequis

None.

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

C5059 - Project communication and valorisation

Public cible

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

Objectifs

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

Prérequis

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

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.

C6045 - Daily information management

Public cible

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

Objectifs

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

Prérequis

None.

Notes

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

Voir la fiche technique

C6046 - Advanced project management

Public cible

Current project manager wishing to improve its knowledge, skills and competences in its projects management especially in complex project environments, or anyone willing to understand the environment and the challenges faced by the project manager.

Objectifs

• Appreciate the complexity of a project: stakeholder's goals, geographical dispersion, diversity management and change management challenges.
• Identify and analyze of the main groups involved in a project.
• Get an overview of the current main projects models, methods, tools and understand their limits in complex project environments.
• Improve common tools and methods to manage complex projects.
• Understand the components, the objectives of a project quality management plan.
• Understand the components, the objectives of the risk management process and its main pitfalls.

Prérequis

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

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.