- Cover
- Introduction
- Part 1: Getting Started with Formulas and Functions
- Part 2: Doing the Math
- Part 3: Solving with Statistics
- Part 4: Dancing with Data
- Chapter 12: Dressing Up for Date Functions
- Chapter 13: Keeping Well-Timed Functions
- Chapter 14: Using Lookup, Logical, and Reference Functions
- Chapter 15: Digging Up the Facts
- Chapter 16: Writing Home About Text Functions
- Chapter 17: Playing Records with Database Functions
- Putting Your Data into a Database Structure
- Working with Database Functions
- Fine-Tuning Criteria with AND and OR
- Adding Only What Matters with DSUM
- Going for the Middle with DAVERAGE
- Counting Only What Matters with DCOUNT
- Finding Highest and Lowest with DMIN and DMAX
- Finding Duplicate Values with DGET
- Being Productive with DPRODUCT
- Part 5: The Part of Tens
- Chapter 18: Ten Tips for Working with Formulas
- Chapter 19: Ten Functions You Really Should Know
- Chapter 20: Ten Really Cool Functions
- Work with Hexadecimal, Octal, Decimal, and Binary Numbers
- Convert Units of Measurement
- Find the Greatest Common Divisor and the Least Common Multiple
- Easily Generate a Random Number
- Convert to Roman Numerals
- Factor in a Factorial
- Determine Part of a Year with YEARFRAC
- Find the Data TYPE
- Find the LENgth of Your Text
- Just in CASE
- Index
- About the Author
- Connect with Dummies
- End User License Agreement
Part 5
The Part of Tens
IN THIS PART …
Discover ten top tips for working with formulas.
See ten functions you really should know.
Use ten really cool functions.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.