Chapter 6
Excel Tools and Techniques for Financial Modeling
IN THIS CHAPTER
Introducing cell referencing
Applying named ranges
Dealing with links and the potential errors they can cause
Improving your modeling skills with shortcuts
Restricting user entry with data validations
Working out a break-even point with goal seek
When you’re using Excel for the purpose of financial modeling, much of the emphasis is on selecting the right function to include in the formulas to calculate the results of the model. Besides functions, a number of tools and techniques are also useful to include in your models. Chapter 7 focuses on Excel formulas. This chapter looks at some of the other practical tools and techniques commonly used in financial modeling in Excel.
Referencing Cells
In Chapter 1, I explain why not every spreadsheet built in Excel is a financial model. In order to be able to call your ...
Get Financial Modeling in Excel For Dummies, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
