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.
CHAPTER 2. Building a Model
CHAPTER 3. Best-Practice Principles of Modelling
CHAPTER 4. Financial Modelling Techniques
CHAPTER 5. Using Excel in Financial Modelling
CHAPTER 6. Functions for Financial Modelling
CHAPTER 7. Tools for Model Display
CHAPTER 8. Tools for Financial Modelling
CHAPTER 9. Common Uses of Tools in Financial Modelling
CHAPTER 10. Model Review
CHAPTER 11. Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling
CHAPTER 12. Presenting Model Output
Download Using Excel for Business and Financial Modelling: A Practical Guide, 3rd Edition PDF or ePUB format free