Front Cover -- Table of Contents -- About the Authors -- Bill Jelen -- Dwayne K. Dowell -- Excel Details -- Showing Numbers in Thousands -- Here's the Situation -- Here's What to Do -- Gotcha -- Excel Details -- Quickly Seeing Sum or Average -- Here's the Situation -- Here's What to Do -- Excel Details -- Adding Subtotals -- Here's the Situation -- Here's What to Do -- Excel Details -- Removing Subtotals -- Adding a Second Level of Subtotals -- Quickly Filling a Series -- Here's the Situation -- Here's What to Do -- Using a Fixed Value in Your Formula -- Here's the Situation -- Here's What to Do -- Replacing a Thousand Formulas with One -- Here's the Situation -- Here's What to Do -- Excel Details -- Highlighting Outliers -- Here's the Situation -- Here's What to Do -- Using Conditional Formatting in Excel 2007 -- Finding Transactions from the Last Week -- Using Icon Sets to Mark Values -- Excel Secrets: Applying Icons to Only the Top 10% -- Using Conditional Formatting in Excel 2003 -- Turning Your Data on Its Side with Transpose -- Here's the Situation -- Here's What to Do -- Better in Excel 2007 -- Excel Details -- Joining Text -- Here's the Situation -- Here's What to Do -- Looking up Data -- Here's the Situation -- Here's What to Do -- Copying the VLOOKUP Formula to Get Region and District -- Dealing with #N/A for Missing Values -- When You Know There Is a Match but Excel Cannot Find It -- Retrieving Many Columns from the Lookup Range -- Getting Good Records from Bad Data -- VLOOKUPs Take a Long Time to Calculate -- Sorting Your Data -- Here's the Situation -- Here's What to Do -- Sorting Data with One Click -- Gotcha -- Here's the Situation -- Here's What to Do -- Sorting in a Custom Sequence -- Additional Details -- Gotcha -- Excel Details -- Better in Excel 2007 - Sorting by Color -- Dealing with Dates -- Here's the Situation.

Here's What to Do -- Calculating with Dates -- Analyzing Data with Pivot Tables -- Here's the Situation -- Here's What to Do -- Preparing Your Data -- Creating a Summary with a Pivot Table -- Creating Your First Pivot Table in Excel 97-2003 -- Creating Your First PivotTable in Excel 2007 -- Changing the Pivot Table Using the "Add To" Button in Excel 97-2003 -- Changing the Pivot Table in Excel 2007 -- Eliminating Blank Cells from the Data Section -- Changing a Pivot Table by Dragging Fields -- Showing Two or More Fields in the Data Area -- Grouping Date Fields by Year -- Grouping Date Fields by Month -- Removing One of Many Data Items -- Building an Ad-Hoc Report Using Page Fields or Report Filter -- Showing Top 10 Customers -- Drilling Down To See Detail -- Pivot Tables and Recalculation -- Limitations on Using Pivot Tables -- Reporting Percentage of Row -- Analyzing Results by Date -- Here's the Situation -- Here's What to Do -- Filling in Weekdays -- Filling in Conditional Counts -- Further Analysis - Sorting -- Further Analysis - Charting -- Further Analysis - Stratification by Weekday -- Creating a Random Sample from a Dataset -- Here's the Situation -- Here's What to Do -- Gotcha -- Finding and Analyzing Records Using AutoFilter -- Here's the Situation -- Here's What to Do -- Excel Details -- Copying Only Filtered Records -- Still More AutoFilter Options -- Formula Auditing -- Here's the Situation -- Here's What to Do -- Locating All Formulas with Show Formulas Mode -- Highlighting All Formulas with Go To Special -- Evaluating a Formula with the F9 Key -- Evaluating a Formula in Slow Motion -- Tracing Precedents or Dependents -- Finding Dependents Using Formula Auditing Arrows -- Finding Precedents Using Formula Auditing Arrows -- Formula Auditing Tips -- Numeric Headings Included in AutoSum Totals -- Ignoring Order of Operations.

Beware of Reset Error Indicators -- Matching Two Lists -- Here's the Situation -- Here's What to Do -- Viewing Two Files Side-by-Side -- Building a Match Function -- Allowing for More Names to Be Added -- Preventing #N/A Errors -- Retrieving the Date Returned Using VLOOKUP -- Better in Excel 2007 - Replacing #N/A -- Finding Duplicates or Unique Values -- Here's the Situation -- Here's What to Do -- Finding Duplicates -- Finding Duplicates in Excel 2007 -- Finding Unique Values -- Using a Formula to Isolate Unique Values -- Using Advanced Filter to Find Unique Records -- Using a Pivot Table to Find Unique Records -- Using Remove Duplicates in Excel 2007 to Find Unique Records -- Finding the Gaps -- Using AutoFilter in Excel 97-2003 -- Better in Excel 2007 - Using AutoFilter -- Next Steps -- Automating Excel with VBA -- Here's the Situation -- Here's What to Do -- Allowing VBA to Run On Your Computer -- Inserting a VBA Module in Your Workbook -- Writing and Running a Macro -- Creating a Macro to Loop Through All Records -- Referring to Cells in the Loop -- Referring to an Entire Row Using CELLS -- Referring to a Rectangular Range Using CELLS -- Macro to Color Every Third Row Red -- Making Decisions Based on Values in the Row -- Special Handling When Deleting Rows -- Handling an Unknown Number of Rows -- Working with Other Worksheets -- Looping through all Worksheets -- Using the Macro Recorder to Learn Other Code -- A Final Note About Recording Macros -- Conclusion -- Index -- Back Cover.