04 Nov TECH TOOLS: FUNDAMENTALS OF EXCEL (SEGOVIA 2C-ONLINE – MORNING)
(TEN SESSIONS SEMINAR)
The purpose of this course is to provide students with a basic knowledge necessary to build simple models in excel through different steps:
Navigate Excel home menu and basic functions (i.e. format cells, formulas, use of $ sign, print preview and layout, paste and paste special);
Introduce key rules to simple modeling;
Create charts, tables and presentations;
Create and link financial statements;
Introduce databases and logical functions;
Introduce essential statistical tools.
MARIANO ALVAREZ_DIENTE
macroeconomics and development economics, with politics.
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?
06 February 2025
13 February 2025
20 February 2025
27 February 2025
06 March 2025
13 March 2025
What day?
Thursday
What time?
09:00-10:30