04 Nov TECH TOOLS: FUNDAMENTALS OF EXCEL (SEGOVIA 2C-ONLINE – AFTERNOON)
(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
Graduate and Master in Telecommunication Engineer, Universidad de Valladolid
– Graduate and Master in Literary Theory and Comparative Literature, Universidad de Valladolid.
– Master in E.S.O, Bachillerato, Professional training and languages teaching.
– Master in Philolofical studies: professional/business applications.
– Candidate Doctor of Philosophy (Ph. D). Discourse Analysis on Smart Cities. Expected 2017
– Currently. Freelance. Telecommunication and Information Technologies projects.
– Currently. Instructor at IBM Global Services
– Engineer in Acoustics. Acoustic municipal centre Hall of Valladolid
– Solyven S.L. Solar energy projects.
Skills
Upon completion of this seminar, students will be able to:
prepare basic tables, graphs and charts;
create spreadsheets related to investment decision making (i.e. NPV, IRR);
use logical excel functions and create basic macros;
create company valuation models and perform sensitivity analysis;
create and use databases as well as database functions;
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?
18:00-19:30