Part III: Formulas
The ability to create formulas is what makes a spreadsheet. In this part, you’ll find formula-related tips that can make your workbooks more powerful than ever.
Tips and Where to Find Them
Tip 26: Resizing the Formula Bar
Tip 27: Monitoring Formula Cells from Any Location
Tip 28: Learning Some AutoSum Tricks
Tip 29: Knowing When to Use Absolute and Mixed References
Tip 30: Avoiding Error Displays in Formulas
Tip 31: Creating Worksheet-Level Names
Tip 33: Sending Personalized E-Mail from Excel
Tip 34: Looking Up an Exact Value
Tip 35: Performing a Two-Way Lookup
Tip 36: Performing a Two-Column Lookup
Tip 38: Calculating a Person’s Age
Tip 39: Working with Pre-1900 Dates
Tip 40: Displaying a Live Calendar in a Range
Tip 41: Returning the Last Nonblank Cell in a Column or Row
Tip 42: Various Methods of Rounding Numbers
Tip 43: Converting Between Measurement Systems
Tip 44: Counting Nonduplicated Entries in a Range
Tip 45: Using the AGGREGATE Function
Tip 46: Making an Exact Copy of a Range of Formulas
Tip 47: Using the Background Error-Checking Features
Tip 48: Using the Inquire Add-In
Tip 49: Hiding and Locking Your Formulas
Tip 50: Using the INDIRECT Function
18.116.40.177