Table of Contents

# Copying a Worksheet # Showing Numbers in Thousands # Quickly Seeing Sum or Average - Better in XL 2007! # Adding Subtotals # Quickly Filling a Series # Using a Fixed Value in Your Formula # Replacing a Thousand Formulas with One # Highlighting Outliers # Using Conditional Formatting in Excel 2007 - Better in XL 2007! # Finding Transactions from the Last Week # Using Icon Sets to Mark Values # Excel Secrets: Applying Icons to Only the Top 10% # Turning Your Data on Its Side with Transpose - Better in XL 2007! # Joining Text # Looking up Data # 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 # Sorting Your Data - Better in XL 2007 - Sort by Color! # Dealing with Dates # Fiscal Responsibility (Fiscal Years NOT Ending on 12/31) # Analyzing Data with Pivot Tables # Analyzing Results by Date # Creating a Random Sample from a Dataset # Finding and Analyzing Records Using AutoFilter # Formula Auditing # Matching Two Lists # Finding Duplicates or Unique Values - Better in XL 2007! # Finding Missing Dates in Data # Automating Excel with VBA # Conclusion # Index

About the Author

Bill Jelen is the host of www.MrExcel.com, a Microsoft MVP, and the author of 65 books about Excel. He lives in Merritt Island, Florida.