04 Nov TECH TOOLS: FUNDAMENTALS OF EXCEL (MADRID 1C-ONLINE – AFTERNOON)
An excel model helps building an abstract representation of a decision-making situation and represents a simplified version of the past or projected performance of a business, project, or any other marketing, HR or commercial problem. The purpose of this course is to provide students with good knowledge needed to build a model in excel through different steps:
(a) basic functions (i.e. format, formulas) to introduce modeling in excel; and create charts and tables in excel;
(b) model cash flow projections and financial statements;
(c) prepare NPV analysis leading to project evaluation;
(d) create alternative scenarios and linking scenarios into projected financial statements;
(e) use tables, databases, and logical functions for statistical analysis.
PAOLO GIANCANE
An investment banker with 20+year experience in corporate finance, M&A, and VC in the largest financial markets (NYC, London, HK). Serial investor in digital brands, enterprise software and ecommerce ventures.
Skills
Upon completion of this seminar, students will be able to:
(1) prepare basic tables, graphs and charts;
(2) create spreadsheets related to investment decision making (i.e. NPV, IRR);
(3) use logical excel functions and create basic macros;
(4) create company valuation models and perform sensitivity analysis;
(5) create and use databases as well as database functions;
(6) become familiar with main statistical tools (i.e. frequency, correlation, regression); and problem-solving algorithms for finance, marketing or human resource-related decisions.
Schedule
Which dates?
23 September 2024
30 September 2024
07 October 2024
14 October 2024
21 October 2024
01-jan
What day?
Mondays
What time?
15.00-18.00 (x2)