Using Excel for Business and Financial Modelling: A Practical Guide, Third Edition
- 5h 58m
- Danielle Stein Fairhurst
- John Wiley & Sons (UK)
- 2019
A hands-on guide to using Excel in the business context
First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away.
Whilst there are many hundreds of tools, features and functions in Excel, this book focuses on the topics most relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Learn to create financial models to help make business decisions whilst applying modelling best practice methodology, tools and techniques.
- Provides the perfect mix of practice and theory
- Helps you become a DIY Excel modelling specialist
- Includes updates for Excel 2019/365 and Excel for Mac
- May be used as an accompaniment to the author’s online and face-to-face training courses
Many people are often overwhelmed by the hundreds of tools in Excel, and this book gives clarity to the ones you need to know in order to perform your job more efficiently. This book also demystifies the technical, design, logic and financial skills you need for business and financial modelling.
About the Author
DANIELLE STEIN FAIRHURST is the Principal of Plum Solutions, a Sydney-based consultancy specialising in financial modelling and analysis. Her extensive experience as a financial analyst enables her to help her clients create meaningful financial models. She is regularly engaged as a speaker, course facilitator, financial modelling consultant, and analyst.
In this Book
-
What is Financial Modelling?
-
Building a Model
-
Best-Practice Principles of Modelling
-
Financial Modelling Techniques
-
Using Excel in Financial Modelling
-
Functions for Financial Modelling
-
Tools for Model Display
-
Tools for Financial Modelling
-
Common Uses of Tools in Financial Modelling
-
Model Review
-
Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling
-
Presenting Model Output
