Microsoft Office Tutorials and References
In Depth Information
Tips and Where to Find Them
Tips and Where to Find Them
Tip 53: Selecting Cells Efficiently .............................................................................................. 147
Tip 54: Automatically Filling a Range with a Series ............................................................ 151
Tip 55: Fixing Trailing Minus Signs ........................................................................................... 154
Tip 56: Restricting Cursor Movement to Input Cells .......................................................... 155
Tip 57: Transforming Data with and Without Using Formulas ....................................... 157
Tip 58: Creating a Drop-Down List in a Cell .......................................................................... 160
Tip 59: Comparing Two Ranges by Using Conditional Formatting .............................. 162
Tip 60: Finding Duplicates by Using Conditional Formatting ........................................ 165
Tip 61: Working with Credit Card Numbers .......................................................................... 168
Tip 62: Identifying Excess Spaces ............................................................................................. 170
Tip 63: Transposing a Range ....................................................................................................... 173
Tip 64: Using Flash Fill to Extract Data .................................................................................... 176
Tip 65: Using Flash Fill to Combine Data ............................................................................... 179
Tip 66: Inserting Stock Information ......................................................................................... 181
Tip 67: Getting Data from a Web Page .................................................................................... 184
Tip 68: Importing a Text File into a Worksheet Range ....................................................... 188
Tip 69: Using the Quick Analysis Feature ............................................................................... 190
Tip 70: Filling the Gaps in a Report .......................................................................................... 192
Tip 71: Performing Inexact Searches ....................................................................................... 194
Tip 72: Proofing Your Data with Audio ................................................................................... 196
Tip 73: Getting Data from a PDF File ....................................................................................... 198
Search JabSto ::




Custom Search