Microsoft Office Tutorials and References
In Depth Information
Tips and Where to Find Them
Tips and Where to Find Them
Tip 26: Resizing the Formula Bar .................................................................................................. 81
Tip 27: Monitoring Formula Cells from Any Location........................................................... 83
Tip 28: Learning Some AutoSum Tricks ..................................................................................... 85
Tip 29: Knowing When to Use Absolute and Mixed References ....................................... 87
Tip 30: Avoiding Error Displays in Formulas ............................................................................ 90
Tip 31: Creating Worksheet-Level Names ................................................................................. 92
Tip 32: Using Named Constants ................................................................................................... 94
Tip 33: Sending Personalized E-Mail from Excel ..................................................................... 96
Tip 34: Looking Up an Exact Value .............................................................................................. 99
Tip 35: Performing a Two-Way Lookup ....................................................................................101
Tip 36: Performing a Two-Column Lookup ............................................................................103
Tip 37: Calculating Holidays ........................................................................................................105
Tip 38: Calculating a Person’s Age .............................................................................................108
Tip 39: Working with Pre-1900 Dates .......................................................................................110
Tip 40: Displaying a Live Calendar in a Range ......................................................................114
Tip 41: Returning the Last Nonblank Cell in a Column or Row .......................................116
Tip 42: Various Methods of Rounding Numbers ..................................................................118
Tip 43: Converting Between Measurement Systems..........................................................121
Tip 44: Counting Nonduplicated Entries in a Range ..........................................................123
Tip 45: Using the AGGREGATE Function .................................................................................125
Tip 46: Making an Exact Copy of a Range of Formulas ......................................................128
Tip 47: Using the Background Error-Checking Features ...................................................130
Tip 48: Using the Inquire Add-In ................................................................................................132
Tip 49: Hiding and Locking Your Formulas ............................................................................135
Tip 50: Using the INDIRECT Function .......................................................................................138
Tip 51: Formula Editing in Dialog Boxes .................................................................................141
Tip 52: Converting a Vertical Range to a Table .....................................................................142
Search JabSto ::




Custom Search