Part II

Doing the Math

9781118460856-pp02.eps

In this part . . .

Are you a money-minded person? I have just the thing for you. Part II is all about loans, investments, depreciation, and internal rates of return. Chapter 5 explains how Excel works with and formats monetary values. Did you know that Excel is so smart it can work with your local currency?

Keeping tabs on loans has never been easier. Heck, you can even figure whether a loan is worth it in the first place! Chapter 6 takes this up a notch to demonstrate advanced financial functions that calculate depreciation and internal rates of returns — the kind of stuff you would think to ask an accountant about. Only now you can figure it out yourself.

Chapters 7 and 8 round this part out with a one-two punch of math functions, from the simple SUM to the super SUMIF. I even throw in a little PI in case you need a snack.

Get Excel Formulas and Functions For Dummies, 3rd 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.