The Wayback Machine - https://web.archive.org/web/20170911003310/http://www.dummies.com:80/software/

Software

Understanding How the Discounted Cash Flow Valuati...

Knowing how the discounted cash flow (DCF) valuation works is good to know in financial mo...

What to Do if Someone Messes Up Your Financial Mod

You’ve finished with your financial model and convinced yourself to hand it over to the...

Conducting a Scenario Analysis in Your Financial M

After you’ve finished all the calculations in your financial model, do lots and lots of...

Financial Modeling in Excel: What to Do if the Fil...

When you start getting a fair amount of data in your financial model, it’s pretty easy t...

How to Report Sales in Your Financial Model with S

If you need to report sales in your financial model, use SUMIF. SUMIF is similar to COUNTI...

How to Use Goal Seeking in Your Excel Financial Mo

One tool that’s very useful for financial modeling is goal seek. If you know the answer...

How to Restrict and Validate Data in Your Excel Fi...

After you finish building a financial model, you may be tempted to keep it to yourself, be...

Naming Ranges in Your Excel Financial Model

Many financial modelers like to include named ranges in their models. Named ranges are jus...

How to Build in Error Checks in Your Excel Financi

Even if you’ve only just started modeling, you’re probably well aware how easy it is t...

Deciding Which Data to Display in Your Excel Finan

The output of your financial model may be very detailed and contain a myriad of numbers, c...