Aims/Objectives: 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.
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.