DECISION AND DATA MODELING (LEVEL 2)

Description

The purpose of this class is to learn advanced modelling skills and get additional training on spreadsheets, as they are an essential tool in corporate life. This is a practical class dedicated, with a very hands-on approach. The democratization of personal computers has fostered the use of models in corporate life: virtually all decisions are taken only after having been comprehensively modelled on a spreadsheet software: - Should we make this new investment? - What is the cash impact of hiring new staff? - How can I optimize my marketing strategy? - What was the performance of foreign subsidiaries last year? - Being able to build such models has become a highly valuable knowledge. Audience Whether you are looking at a career in Finance, in Audit, in Strategy or as an Entrepreneur, improving your modelling skills will save you a lot of time & energy down the road. This course will prove extremely useful to whoever uses models in a professional environment. French and International Students who have followed this elective are, in average, extremely satisfied (with ratings above 4.0, and often above 4.5). They specifically value the very hands-on approach, and the practical competencies learnt throughout the class. Thèmes clés / Key Topics: Modelling, Spreadsheet, Data Organisation du cours – plan détaillé / Course organization - detailed outline: 6 sessions of 3 hours, once per week during one bimester The course starts with some good practices and useful shortcuts. We then study a series of advanced functions and functionalities of Excel: - Names - Automating Reporting, using the LARGE function - Dates & Times - Data Analysis Functions: SUMIFS, COUNTIFS, SUMPRODUCT… - The INDIRECT & OFFSET Functions - The Text Functions - The Best Practices to format a worksheet Contenus ESG / ESG-related content (Environmental – Social – Governance): Environmental-r elated content Social-relat ed content Governance-re lated content 1. Minimal content 1. Minimal content 1. Minimal content Assessment Information: Pondération dans Outils / support / mode d’évaluation Durée et format la notation finale Tool/method of evaluation Duration Weight in the final grading In-class participation (attendance, short online quizzes, overall Individual 10-20% commitment) Homework control, if applicable Individual 0-10% Final Exam on Excel: a series of independent questions to answer, using the 90 to 120 min / 70-90% functions, functionalities and best practices seen in class Individual