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
Get 101 Excel 2013 Tips, Tricks and Timesavers now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.