Skip to Main Content
Excel Formulas and Functions For Dummies, 3rd Edition
book

Excel Formulas and Functions For Dummies, 3rd Edition

by Ken Bluttman
February 2013
Beginner content levelBeginner
408 pages
9h 10m
English
For Dummies
Content preview from Excel Formulas and Functions For Dummies, 3rd Edition

Chapter 19

Ten Functions You Really Should Know

In This Chapter

arrow Summing, averaging, and counting

arrow Rounding numbers

arrow Using IF for conditional results

arrow Using the current date and time

arrow Determining whether a value is a number

arrow Finding the smallest and largest values

arrow Using conditional summing and counting

This chapter lists the top ten Excel functions. Actually, it lists the top 15, but in some cases two related functions are treated as a single item. To be fair, there is no absolute top ten list of functions, but over the years (don’t ask how many!) I have worked on hundreds of worksheets and saw some of the same functions used all the time.

The functions in this list are of the type that apply to a wide array of needs. You won’t see a financial function or any advanced statistical function ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Formulas & Functions For Dummies, 5th Edition

Excel Formulas & Functions For Dummies, 5th Edition

Ken Bluttman

Publisher Resources

ISBN: 9781118460856Purchase book