MICROSOFT EXCEL IN THE WORK OF A FINANCIER. ANALYSIS AND MODELING OF FINANCIAL DATA

Are you browsing job offers and everywhere requires a very good knowledge of MS Excel, especially in the field of financial data? Or maybe you use Excel at work and spend a lot of time performing standard, daily repeated activities, and the results of your analyzes are not satisfactory? This book is for you!

• Practical applications: A collection of practical applications of Excel for financial modeling.
• Workshop form: Presentation in the form of a workshop, according to the principle of "Learning by doing".
• Excel files: Solutions to all described problems are available in Excel files.
• Financial modeling: The book consists of 8 chapters devoted to financial modeling.
• Investment analysis: Issues related to the time value of money, the analysis of deposits and loans.
• Project evaluation: Evaluation of investment projects, valuation of stocks and bonds.
• Effective portfolios: Creating effective investment portfolios and their evaluation and return forecasting.

The book you are holding in your hands was created on the basis of trainings and is a collection of practical applications of Excel for financial modeling. The whole is presented in the form of a workshop, according to the principle of "Learning by doing". You will not find dry theory here. We focus on practice! Therefore, one of the most important elements of this book are Excel files, which contain solutions to all the issues described in it. The recommended working system is to read the book in parallel and perform exercises in Excel. Excel files can be found at:

To fully understand all the issues and application examples discussed in the book, knowledge of MS Excel at least at an intermediate level is required. The book was developed for the Polish version of the ME Excel program. The book consists of 8 chapters devoted to financial modeling. In the following chapters, we present issues related to the time value of money, the analysis of deposits and loans, the evaluation of investment projects, the valuation of stocks and bonds, the creation of effective investment portfolios and their evaluation and forecasting of return. This book is your key to success in finance!