Welcome to the website to accompany Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals, Third Edition by Danielle Stein Fairhurst, located at www.wiley.com/go/steinfairhurst.
The content of the website consists of several documents that supplement the information in the book, including additional instructions, materials, downloads, and models. Each chapter (except Chapter 1) has its own Excel file(s), which contain a soft copy of the many screenshots shown throughout the book and their applicable page numbers. Using these files, you'll be able to recreate many of the modelling situations, tools, and functions described in the book. Several Excel model exercises and sample models have also been included. These accompanying files have been made freely available by the author, but they might not make sense without the book.
For updated model templates and additional supplementary downloads, please check the author's website, www.plumsolutions.com.au/book. Please also visit www.plumsolutions.com.au/elearning if you would like to register for the author's online courses that correspond to the book.
The supplementary content available on the website includes:
DOWNLOADABLE RESOURCES
These downloadable PDFs contain additional explanations and content we didn't have room for in the book:
Excel versions (Chapter 5) contains an overview of the history and key differences among the versions of Excel in use and how they impact model building.
Online resources (Chapter 1) includes a list of websites, blogs, and tutorials for Excel and financial modelling.
Shortcuts (Chapter 5) is a printable three-page cheat sheet of the most useful shortcuts for financial modelling in Excel.
QA log template (Chapter 10, Appendix 10.1) is a sample template that can be used during the model QA process.
Creating a waterfall chart in previous versions of Excel
Models
These fully functioning models have been referred to in the book:
Scenario comparison (including both exercise and completed versions) (Chapter 11).
Technical Exercise Files
These files contain the examples from the screenshots exactly as they appear in the book. You can use them to work through the examples and follow the instructions in the book to master each tool and technique.