CARLBERG, Conrad George. Business analysis with Microsoft Excel. Fifth edition. [Upper Saddle River]: Pearson Education, [2019]. ISBN 978-0-7897-5958-0.
MAYES, Timothy R. Financial analysis with Microsoft Excel 2019. 9th edition. Boston: Cengage, 2021. ISBN 978-0357-44205-0.
IBARRA, Luis Fernando. Simulation and statistics with Excel: an introduction to business students. Boca Raton: CRC Press, Taylor & Francis Group, 2024. ISBN 978-1-032-69876-2.
WINSTON, Wayne L. Microsoft Excel 2019: data analysis and business modeling. Sixth edition. New York: Pearson Education, 2019. ISBN 978-1-5093-0588-9.
Applications of Computer Technology
| Language of instruction | čeština |
|---|---|
| Code | 545-0198 |
| Abbreviation | AVT |
| Course title | Applications of Computer Technology |
| Coordinating department | Department of Economics and Control Systems |
| Course coordinator | RNDr. Radmila Sousedíková, Ph.D. |
Summary
The course provides students with advanced knowledge and practical skills in the use of computer technology for processing, analyzing and interpreting technical, economic and financial data using Microsoft Excel. Students will learn to use advanced Excel workflows and tools in the analysis of technical-production indicators, evaluation of the financial situation of the company, assessment of investment efficiency and solution of investment financing issues.
After completing the course, the student will achieve the following learning outcomes:
Knowledge: the student will explain the principles of advanced processing and analysis of technical-economic data using Microsoft Excel, explain the principles of horizontal and vertical financial analysis, characterize selected ratio indicators and their significance for evaluating the financial situation of the company, explain the essence of evaluating the effectiveness of capital investments and the profitability of financial investments.
Skills: the student applies advanced workflows and functions of Microsoft Excel in the processing of economic and financial data, analyzes trends in technical-production indicators, calculates selected ratio indicators of financial analysis and graphically displays their development; evaluates the financial and economic situation of the company based on the results of the financial analysis, assesses the effectiveness of the investment in the conditions of the raw materials industry, calculates the repayment of the investment loan and draws up an amortization plan.
General competencies: the student independently selects an appropriate workflow and suitable Microsoft Excel tools for solving an economic or financial problem; critically evaluates the results of the analyses and their usability in economic decision-making, professionally interprets and presents the results of economic calculations, tables and graphic outputs.
After completing the course, the student will achieve the following learning outcomes:
Knowledge: the student will explain the principles of advanced processing and analysis of technical-economic data using Microsoft Excel, explain the principles of horizontal and vertical financial analysis, characterize selected ratio indicators and their significance for evaluating the financial situation of the company, explain the essence of evaluating the effectiveness of capital investments and the profitability of financial investments.
Skills: the student applies advanced workflows and functions of Microsoft Excel in the processing of economic and financial data, analyzes trends in technical-production indicators, calculates selected ratio indicators of financial analysis and graphically displays their development; evaluates the financial and economic situation of the company based on the results of the financial analysis, assesses the effectiveness of the investment in the conditions of the raw materials industry, calculates the repayment of the investment loan and draws up an amortization plan.
General competencies: the student independently selects an appropriate workflow and suitable Microsoft Excel tools for solving an economic or financial problem; critically evaluates the results of the analyses and their usability in economic decision-making, professionally interprets and presents the results of economic calculations, tables and graphic outputs.
Literature
Doporučená literatura
WINSTON, Wayne L. Microsoft Excel 2019: data analysis and business modeling. Sixth edition. [New York]: Pearson Education, [2019]. ISBN 978-1-5093-0588-9.
LAMBERT, Joan; FRYE, Curtis. Microsoft Excel Step by Step (Office 2021 and Microsoft 365). Microsoft Press, 2021. ISBN 9780137564354 .
HOLDEN, Craig W. Excel Modeling in Corporate Finance. 5th edition. Pearson, 2014. ISBN 9780205987252 .
CARLBERG, Conrad George. Predictive analytics: Microsoft Excel. Second edition. Indiana: Que, 2018. ISBN 978-0-7897-5835-4.
LAMBERT, Joan; FRYE, Curtis. Microsoft Excel Step by Step (Office 2021 and Microsoft 365). Microsoft Press, 2021. ISBN 9780137564354 .
HOLDEN, Craig W. Excel Modeling in Corporate Finance. 5th edition. Pearson, 2014. ISBN 9780205987252 .
CARLBERG, Conrad George. Predictive analytics: Microsoft Excel. Second edition. Indiana: Que, 2018. ISBN 978-0-7897-5835-4.