Part IV: Working with Data
In this part, you’ll find tips related to working with data of all types. There’s an excellent chance that the tips here will improve your overall efficiency.
Tips and Where to Find Them
Tip 53: Selecting Cells Efficiently
Tip 54: Automatically Filling a Range with a Series
Tip 55: Fixing Trailing Minus Signs
Tip 56: Restricting Cursor Movement to Input Cells
Tip 57: Transforming Data with and Without Using Formulas
Tip 58: Creating a Drop-Down List in a Cell
Tip 59: Comparing Two Ranges by Using Conditional Formatting
Tip 60: Finding Duplicates by Using Conditional Formatting
Tip 61: Working with Credit Card Numbers
Tip 62: Identifying Excess Spaces
Tip 64: Using Flash Fill to Extract Data
Tip 65: Using Flash Fill to Combine Data
Tip 66: Inserting Stock Information
Tip 67: Getting Data from a Web Page
Tip 68: Importing a Text File into a Worksheet Range
Tip 69: Using the Quick Analysis Feature
Tip 70: Filling the Gaps in a Report
Tip 71: Performing Inexact Searches
3.144.154.208