6. Using Functions

In This Chapter

• Search Excel’s library of over 400 functions.

• Use multiple criteria to look up values.

• Calculate overtime in timesheets.

• Create formulas using multiple functions.

• Troubleshoot formulas.

A function is like a shortcut for using a long or complex formula. If you’ve ever summed cells like this: =A1+A2+A3+A4+A5, you could have instead used the SUM function like this: =SUM(A1:A5). Excel offers more than 400 functions. These include logical functions, lookup functions, statistical functions, financial functions, and more.

This chapter shows you how to look up functions available in Excel and reviews some functions helpful for everyday use. Another useful tool, Goal Seek, is also introduced.


Only a ...

Get Excel® 2013 Absolute Beginner’s Guide now with the O’Reilly learning platform.

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