Skip to Content
Excel金融建模
book

Excel金融建模

by Posts & Telecom Press, Shmuel Oluwa
May 2024
Intermediate to advanced
211 pages
3h 41m
Chinese
Packt Publishing

Overview

通过一系列金融建模实践和Excel实操技巧,帮助读者掌握高效率的金融建模解决方案

Key Features

  • 金融建模是许多金融从业者需要具备的核心技能。
  • 可以借助随书提供的配套数据表格和彩色图片,跟随书中提示,逐步进行实践操作。
  • 自带大量 Excel 金融数据应用场景,案例中的操作描述紧凑且干货满满。

Book Description

Excel是大众熟知的Office软件之一,它不仅拥有优秀的统计功能、数据分析功能,在金融建模领域也被广泛应用。

本书基于Excel 2019编写,全书共10章内容,涉及财务模型及Excel简介、建立财务模型的步骤、Excel函数和公式的使用、各种财务表格、比率分析、估值以及如何测试模型的合理性和准确性等知识点。

本书将Excel用于金融建模实践,囊括了丰富的案例和操作演示,力求帮助读者了解金融建模场景中常用的Excel工具,解决金融领域的预测、估值、交易、数据分析等业务难题。

本书适合金融及财务方向的从业者阅读,对企业并购、估值建模等具有参考价值,是一本实用的工具书。

What you will learn

  • 财务模型及Excel简介
  • 建立财务模型的步骤
  • Excel函数和公式的使用
  • 各种财务表格
  • 比率分析
  • 估值
  • 测试模型的合理性和准确性

Who this book is for

本书适合金融及财务方向的从业者阅读,对企业并购、估值建模等具有参考价值。

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

编写整洁的Python代码(第2版)

编写整洁的Python代码(第2版)

Posts & Telecom Press, Mariano Anaya
Python编程入门与实战

Python编程入门与实战

Posts & Telecom Press, Fabrizio Romano
TensorFlow深度学习项目实战

TensorFlow深度学习项目实战

Posts & Telecom Press, Luca Massaron, Alberto Boschetti, Alexey Grigorev, Abhishek Thakur
解密金融数据

解密金融数据

Justin Pauley

Publisher Resources

ISBN: 9781836207535