MrExcel LIVe: The 54 Greatest Excel Tips of All Time

Intro
 Dedication
 About the Author
 About the Contributors
 Foreword
 Introduction
 Part 1: The Top 54 Tips
 #1 Double-Click the Fill Handle to Copy a Formula
 #2 Break Apart Data
 #3 Filter by Selection
 Bonus Tip: Total the Visible Rows
 #4 The Fill Handle Does Know 1, 2, 3a Bonus Tip: Fill Jan, Feb ..., Dec, Total
 Bonus Tip: Fill 1 to 100,000 in a Flash
 #5 Fast Worksheet Copy
 Bonus Tip: Put the Worksheet Name in a Cell
 Bonus Tip: Add a Total Row and a Total Column with One AutoSum
 Bonus Tip: Power Up the Status Bar Statistics Bonus Tip: Create a SUM That Spears Through All WorksheetsBonus Tip: Use INDIRECT for a Different Summary Report
 #6 Use Default Settings for All Future Workbooks
 Bonus Tip: Understand that Changes are Cumulative
 Bonus Tip: Replace the Comma Style in Book.xltx
 #7 Recover Unsaved Workbooks
 #8 Create Perfect One-Click Charts
 #9 Paste New Data on a Chart
 Bonus Tip: Create Interactive Charts
 Bonus Tip: Show Two Different Orders of Magnitude on a Chart
 #10 New in Excel 2016: Create Waterfall Charts and More
 Bonus Tip: Create Funnel Charts in Office 365 Bonus Tip: Create Filled Map Charts in Office 365#11 Add Meaning to Reports Using Data Visualizations
 #12 Sort East, Central, and West Using a Custom List
 #13 Sort Left to Right
 Bonus: Another Way to Move Columns
 #14 Sort Subtotals
 Bonus Tip: Fill in a Text Field on the Subtotal Rows
 Bonus Tip: Format the Subtotal Rows
 Bonus Tip: Copy the Subtotal Rows
 #15 Sort and Filter by Color or Icon
 #16 Consolidate Quarterly Worksheets
 #17 Create a Year-over-Year Report in a Pivot Table
 Bonus Tip: Change the Calculation in a Pivot Table
 #18 Find the True Top Five in a Pivot Table #19 Specify Defaults for All Future Pivot TablesBonus Tip: Change What Drives You Crazy About Excel
 Bonus Tip: Make Pivot Tables Expandable Using Ctrl+T
 Bonus Tip: Use Ctrl+T with VLOOKUP and Charts
 #20 Replicate a Pivot Report for Each Rep
 #21 Use a Pivot Table to Compare Lists
 Bonus Tip: Show Up/Down Markers
 Bonus Tip: Compare Two Lists by Using Go To Special
 #22 Build Dashboards with Sparklines and Slicers
 Bonus Tip: Make Your Workbook into a Web App
 Bonus Tip: Line Up Dashboard Sections with Different Column Widths
 Bonus Tip: Use Picture Lookup #23 See Why GETPIVOTDATA Might Not Be Entirely Evil#24 Eliminate VLOOKUP with the Data Model
 Bonus Tip: Count Distinct
 #25 Compare Budget Versus Actual via Power Pivot
 Bonus Tip: Portable Formulas
 #26 Use F4 for Absolute Reference or Repeating Commands
 Bonus Tip: Use a Named Range Instead of Absolute References
 #27 Quickly Convert Formulas to Values
 Bonus Tip: Skip Blanks While Pasting
 #28 See All Formulas at Once
 Bonus Tip: Highlight All Formula Cells
 Bonus Tip: Trace Precedents to See What Cells Flow into a Formula
 Bonus Tip: See Which Cells Depend on the Current Cell