Introduction to financial technologies by Excel

Goal: The aim of the course is to introduce the basic concepts and processes of financial
technologies in a practical way with the help of the Excel spreadsheet. Students gain
the necessary knowledge and routine through real-life application examples taken
from practical life. The fundamental goal of financial technologies is to increase the
efficiency of financial services with innovative IT solutions. Therefore, by
completing this course, the student will be prepared to understand the specific Fintech
environments located between interdisciplinary financial and engineering activities.
Course description: Thematic: Lectures: Samples, cases and theories. Financial foundations in context of
Excel. Data cleaning, financial functions (IRR, FV, PV, NPV, RATE, PMT etc.),
filters, Optimal calculation, Charts, Statements, Pivot table, opportunity analysis,
Solver, advanced data management, macros and writing algorithms. Practice: With
the help of tasks that can be solved in Excel, students get to know innovative
financial solutions, which they are able to analyse and understand that how they
work.

 

https://nik.uni-obuda.hu/targyleirasok/wp-content/uploads/2024/09/IFTExcel_NIVIF1EBNE_24251.pdf