Chapter 8

Creating Excel Formulas and Functions

In This Chapter

arrow Writing basic formulas

arrow Copying and moving formulas

arrow Inserting functions

arrow Showing the current date or time with a function

arrow Calculating loan terms

arrow Evaluating a condition with an IF function

arrow Referring to named ranges

arrow Using the Quick Analysis feature

Math. Excel is really good at it, and it’s what makes Excel more than just data storage. Even if you hated math in school, you might still like Excel because it does the math for you.

In Excel, you can write math formulas that perform calculations on the values in various cells, and then, if those values change later, you can see the formula results update automatically. You can ...

Get Office 2016 at Work For Dummies now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.