04 Nov TECH TOOLS: FUNDAMENTALS OF EXCEL (ONLINE MADRID) AFTERNOON
(TEN SESSIONS SEMINAR)
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?
21 January 2025
28 January 2025
4 February 2025
11 February 2025
18 February 2025
01-jan
What day?
Tuesday
What time?
09:30-12:30