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

Everybody interested to the effective use of Information and Communication Technologies (ICT), to the management of the graphical interface of Windows, to the knowledge of how to handle files on the computer and to the discovering of 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.

Voir la fiche technique

C1301 - Online Essentials: MS-Outlook and the Web

Public cible

Everybody interested in best practice in effective online computer use 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

Future participants are encouraged to complete the module « Office tools fundamentals » (C1300) before enroling for this course or to make sure that they possess equivalent skills.

Voir la fiche technique

C1302 - Presentation essentials : MS-Powerpoint

Public cible

Everybody interested in best practice in effective presentation software use.

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 and 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

Future participants are encouraged to complete the module « Office tools fundamentals » (C1300) before enroling for this course or to make sure that they possess equivalent skills.

Voir la fiche technique

C1310 - Word Processing essentials: MS-Word

Public cible

Everybody interested in getting 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

Future participants are encouraged to complete the module « Office tools fundamentals » (C1300) before enroling for this course or to make sure that they possess equivalent skills.

Voir la fiche technique

C1311 - Word Processing advanced features : MS-Word

Public cible

Everybody interested to acquire advanced skills in word processor utilization.

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 « Word Processing essentials : MS-Word » (C1310) or proof of equivalent knowledge.

C1312 - Enhanced Word Processing skills training - project design : MS-Word

Public cible

Every person interested in best practice design of a private or professional word processor 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 « Word Processing advanced features : MS-Word » (C1311) or proof of equivalent knowledge.

Voir la fiche technique

C1320 - Spreadsheets essentials : MS-Excel

Public cible

Everybody interested in getting to work with the basic 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.

Voir la fiche technique

C1321 - Spreadsheets advanced features : MS-Excel

Public cible

Everybody interested 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 « Spreadsheets essentials : MS-Excel » (C1320) or proof of equivalent certified knowledge.

Voir la fiche technique

C1322 - Enhanced Spreadsheets skills training - project design : MS-Excel

Public cible

Every person interested in best practice design of 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 functions.
• 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 « Spreadsheets advanced features : MS-Excel » (C1321) or proof of equivalent certified knowledge.

Voir la fiche technique

C1500 - CCNA - Introduction to Networks

Public cible

Candidates who wish 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

Duration of the course : 12 weeks (2x per week) Weekday evenings 18:00-20:00 and/or Saturday mornings 08:00-12:00

Voir la fiche technique

C1501 - CCNA - Routing and Switching Essentials

Public cible

Candidates who wish 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

C1500 CCNA - Introduction to Networks

Notes

Duration of the course : 12 weeks (2x per week) Weekday evenings 18:00-20:00 and/or Saturday mornings 08:00-12:00

Voir la fiche technique

C1502 - CCNA - Scaling Networks

Public cible

Candidates who wish 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

C1501 CCNA - Routing and Switching Essentials

Notes

Duration of the course : 12 weeks (2x per week) Weekday evenings 18:00-20:00 and/or Saturday mornings 08:00-12:00

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

C1502 CCNA - Scaling Networks

Notes

Duration of the course : 12 weeks (2x per week) Weekday evenings 18:00-20:00 and/or Saturday mornings 08:00-12:00

Voir la fiche technique

C1504 - CCNA - Security

Public cible

Candidates who wish 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

C1501 CCNA - Routing and Switching Essentials

Notes

Duration of the course : 12 weeks (2x per week) Weekday evenings 18:00-20:00 and/or Saturday mornings 08:00-12:00

Voir la fiche technique

C1510 - CCNP Routing and Switching: Routing

Public cible

Candidates who wish 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

C1503 CCNA - Connecting Networks

Notes

Duration of the course : 12 weeks (2x per week) Weekday evenings 18:00-20:00 and/or Saturday mornings 08:00-12:00

Voir la fiche technique

C1511 - CCNP Routing and Switching : Switching

Public cible

Candidates who wish 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

C1510 CCNP Routing and Switching : Routing

Notes

Duration of the course : 12 weeks (2x per week) Weekday evenings 18:00-20:00 and/or Saturday mornings 08:00-12:00

Voir la fiche technique

C1512 - CCNP Routing and Switching : Troubleshooting

Public cible

Candidates who wish 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

C1511 CCNP Routing and Switching : Switching

Notes

Duration of the course : 12 weeks (2x per week) Weekday evenings 18:00-20:00 and/or Saturday mornings 08:00-12:00

Voir la fiche technique

C1600 - Organisational, legal and technical basics of the Internet

Public cible

Participants who wish 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). The objective of this course is learning how to create web pages. Creating and testing the pages locally. Learning the basic 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).
• Checking  the source code of web pages for errors. Correcting and validating the created HTML.

Prérequis

Future participants are encouraged to complete the module « Les notions organisationnelles, juridiques et techniques de l'Internet »(C1600) before enrolling for this course or to make sure that they possess equivalent skills

Voir la fiche technique

C1610 - Introduction to programming

Public cible

Being an introduction, this course is suitable for people who have no knowledge of programming. This course is designed for future programmers or web developers. The objective of the course is to understand the common basics of modern programming languages.

Objectifs

• The basics.
• Algorithms.
• Programming languages.
• Variables.
• Data types.
• Functions and procedures.
• Object based programming.
• Debugging.

Prérequis

None.

Voir la fiche technique

C1611 - User friendly web pages with JavaScript

Public cible

All persons working in a professional environment who want 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

• Acquiring fundamental programming skills using JavaScript, a client-side language.
• Developing simple functions in JavaScript to make websites more interactive.
• Creating user-friendly web forms.
• Checking the data given by the user and displaying a corresponding message.
• Creating a simple image gallery.
• Using JavaScript libraries such as jQuery.
• Finding and correcting errors in JavaScript code using debugging tools.
• Improving the usability of a Web page.

Prérequis

Future participants are encouraged to complete the modules « Creating web pages with HTML and CSS » (C1601) and « Introduction à la programmation » (C1610) before enrolling for this course or to make sure that they possess equivalent skills.

Voir la fiche technique

C1612 - Concepts of creating dynamic Web pages using PHP

Public cible

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

Objectifs

• Installing and configuring a local web server as a development environment.
• Understanding the differences between client-side and server-side programming languages.
• Getting to know the different data types in PHP and learning how to use them.
• Creating and editing strings and texts with PHP.
• Understanding regular expressions and their use.
• Creating HTML code with PHP.
• Creating, checking and handle web forms with PHP.
• Sending automatically generated emails with PHP.
• Uploading files.

Prérequis

Successful completion of the module « User friendly web pages with JavaScript » (C1611) or proof of equivalent knowledge.

Voir la fiche technique

C1613 - PHP and MySQL Web Development

Public cible

All persons who want 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

All persons 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

• Understanding and applying the fundamentals of object-oriented programming in PHP.
• Using PHP Frameworks.
• The cakePHP framework in practice.
• Interaction Java Script PHP.
• Using advanced techniques such as AJAX and JSON.
• Creating layouts. Using jQuery, Bootstrap and ZURB Foundation.
• Creating multilingual websites - internationalization and localization.
• Making use of advanced server configuration.
• Testing and optimizing 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

All persons who want 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

We recommend participants to complete the module « Java crash course for programmers » (C1127) or « Le langage Java : partie 1 » (C1040) and « Le langage Java : partie 2 » (C1041, before enrolling for this course or to make sure that they possess equivalent skills.

Voir la fiche technique

C1631 - Android Programming

Public cible

All persons who, on the basis of their Java programming skills, want to write programs for mobile devices running under Android operating system. The objective of this course is learning how to write native android applications.

Objectifs

• Acquiring an overview of Android.
• Installing the needed software and running existing example applications.
• Creating and testing Android projects in Eclipse. Understanding the structure of the given project.
• Organizing the screen. Different layouts.
• Event Handling - Invoking Activities.
• Networking under Android.
• Multi-threading.
• Graphics and Animations.

Prérequis

We recommend participants to complete the module « Java crash course for programmers » (C1635) or « Le langage Java : partie 1 » (C1040) and « Le langage Java : partie 2 » (C1041, before enrolling for this course or to make sure that they possess equivalent skills.

Voir la fiche technique

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

Public cible

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

Objectifs

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

Prérequis

Participants should complete the modules « Creating web pages with HTML and CSS » (C1601) and « User friendly web pages with JavaScript »(C1611) before enrolling for this course or to make sure that they possess equivalent skills. 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

All persons who want to create or 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.

C1635 - Java crash course for programmers

Public cible

Everybody who wants 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.
• Classes and Objects, Interfaces.
• Inheritance, Overriding.
• Data types.
• Exceptions Handling.
• Multithreading.
• Files and I/O. Using JDBC.
• Networking. Clients and Servers. NIO (New Input Output).
• Introduction to Swing and Applets.

Prérequis

Participants should know the basic concepts of programming, data types, algorithms. They should be familiar with another programming language.

C2001 - General accounting : current operations

Public cible

Beginners who wish 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...
• Record current operations.
• Record invoices : purchase and sales invoices, credit notes...
• Understand the mechanism of VAT.
• Learn to record bank statements.

Prérequis

None.

Notes

Course is based on the luxemburgish accounting plan

C2003 - General accounting : year-end operations

Public cible

Persons who wish 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...).
• 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

Course is based on the luxemburgish accounting plan.

C2007 - Analytical accountancy

Public cible

All those who wish 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

• To establish a comprehensive overview of the financial situation of an entity with reference to Gearing, Liquidity, and Investment performance.
• To select and apply various decision making techniques in order to maximise efficiency of resources.
• To understand how risk and uncertainty are incorporated into decision making techniques, and how said risks are managed.
• To understand the key methods of investment appraisal.
• To identify appropriate techniques of business and asset valuations.
• To 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 knowledge.

Voir la fiche technique

C2020 - Financial mathematics on Excel

Public cible

People 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 «Spreadsheets essentials : MS-Excel » (C1320E) or proof of equivalent knowledge.

C3001 - Overview of Luxembourg Company Law

Public cible

Professionals 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. Any persons generally 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

Successful completion of the module « General accounting : current operations » (C2001) or « La comptabilité pour non-comptables » (C2002) or proof of equivalent knowledge is recommended.

Voir la fiche technique

C3047 - Individual income tax

Public cible

Beginners who wish 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 (are not covered by this course : commercial profit, profit from agriculture and forestry).
• Be familiar with provisions reducing the taxable basis : special expenses, extraordinary charges, 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

Beginners, candidates who wish 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

Candidates who wish 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

None.

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

Successful completition of the module "Corporate Income tax" (C3049) is recommended.

Notes

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

Voir la fiche technique

C5019 - Introduction to sophrological relaxation techniques

Public cible

Candidates who wish to release their daily tension and achieve greater balance in life and wellbeing.

Objectifs

• Discover the history of sophrology and its fundamental principles.
• Be able to use relaxing and energizing breathing techniques throughout the day.
• Get acquainted with the most significant sophrological relaxation techniques.
• Develop a better body awareness through sensation and movement.
• Learn to release physical and mental tension.
• Meet the day with a positive state of mind.
• Learn simple techniques for managing stress in daily life.
• Relax after a working day and achieve a better physical and mental recovery.

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).