101 Excel 2013 Tips, Tricks and Timesavers

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
Tip 51: Formula Editing in Dialog Boxes
Tip 52: Converting a Vertical Range to a Table

Part IV: Working with Data
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 63: Transposing a Range
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
Tip 72: Proofing Your Data with Audio
Tip 73: Getting Data from a PDF File

Part V: Tables and Pivot Tables
Tip 74: Understanding Tables
Tip 75: Using Formulas with a Table
Tip 76: Numbering Table Rows Automatically
Tip 77: Identifying Data Appropriate for a Pivot Table
Tip 78: Using a Pivot Table Instead of Formulas
Tip 79: Controlling References to Cells Within a Pivot Table
Tip 80: Creating a Quick Frequency Tabulation
Tip 81: Grouping Items by Date in a Pivot Table
Tip 82: Creating Pivot Tables with Multiple Groupings
Tip 83: Using Pivot Table Slicers and Timelines

Part VI: Charts and Graphics
Tip 84: Understanding Recommended Charts
Tip 85: Customizing Charts
Tip 86: Making Charts the Same Size
Tip 87: Creating a Chart Template
Tip 88: Creating a Combination Chart
Tip 89: Handling Missing Data in a Chart
Tip 90: Using High-Low Lines in a Chart
Tip 91: Using Multi-Level Category Labels
Tip 92: Linking Chart Text to Cells
Tip 93: Freezing a Chart
Tip 94: Creating a Chart Directly in a Range
Tip 95: Creating Minimalistic Charts
Tip 96: Applying Chart Data Labels from a Range
Tip 97: Grouping Charts and Other Objects
Tip 98: Taking Pictures of Ranges
Tip 99: Changing the Look of Cell Comments
Tip 100: Enhancing Images
Tip 101: Saving Shapes, Charts, and Ranges as Images
Index