20 Feb 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.
#N/A
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?
16-jan
23-jan
30-jan
06-feb
13-feb
20/02/2024 (async)
What day?
TUESDAY
What time?
09,00-10,30