Hands-On Financial Modeling with Microsoft Excel 2019
暫譯: 實戰財務模型:使用 Microsoft Excel 2019

Oluwa, Shmuel

相關主題

商品描述

Financial modeling is a core skill required by anyone who wants to build a career in finance. Hands-On Financial Modeling with Microsoft Excel 2019 explores terminologies of financial modeling with the help of Excel.

 

This book will provides you with an overview of the steps you should follow to build an integrated financial model. You will explore the design principles, functions, and techniques of building models in a practical manner. Starting with the key concepts of Excel, such as formulas and functions, you will learn about referencing frameworks and other advanced components for building financial models. Later chapters will help you understand your financial projects, build assumptions, and analyze historical data to develop data-driven models and functional growth drivers. The book takes an intuitive approach to model testing and covers best practices and practical use cases.

 

By the end of this book, you will have examined the data from various use cases, and have the skills you need to build financial models to extract the information required to make informed business decisions.

商品描述(中文翻譯)

金融模型是任何希望在金融領域建立職業生涯的人所需的核心技能。《使用 Microsoft Excel 2019 進行實務金融建模》探討了金融建模的術語,並利用 Excel 進行輔助。

本書將為您提供建立綜合金融模型所需遵循的步驟概述。您將以實務的方式探索模型設計原則、函數和技術。從 Excel 的關鍵概念開始,例如公式和函數,您將學習參考框架及其他用於建立金融模型的進階組件。後面的章節將幫助您理解您的金融專案、建立假設,並分析歷史數據,以開發數據驅動的模型和功能性增長驅動因素。本書採取直觀的方法進行模型測試,並涵蓋最佳實踐和實際使用案例。

在本書結束時,您將檢視來自各種使用案例的數據,並具備建立金融模型所需的技能,以提取做出明智商業決策所需的信息。