#1 Double-Click the Fill Handle to Copy a Formula #2 Break Apart Data #3 Filter by Selection #4 The Fill Handle Does Know 1, 2, 3. #5 Fast Worksheet Copy #6 Recover Unsaved Workbooks #7 Simultaneously Edit the Same Workbook in Office 365 #8 New Threaded Comments Allow Conversations #9 Create Perfect One-Click Charts #10 Paste New Data on a Chart #11 Create Waterfall Charts #12 Creat a Bell Curve #13 Add Meaning to Reports Using Data Visualizations #14 Sort East, Central, and West Using a Custom List #15 Sort Left to Right #16 Sort Subtotals #17 Sort and Filter by Color or Icon #18 Consolidate Quarterly Worksheets #19 Get Ideas from Artificial Intelligence #20 Create Your First Pivot Table #21 Create a Year-over-Year Report in a Pivot Table #22 Find the True Top Five in a Pivot Table #23 Specify Defaults for All Future Pivot Tables #24 Replicate a Pivot Table for Each Rep #25 Use a Pivot Table to Compare Lists #26 Build Dashboards with Sparklines and Slicers #27 See Why GETPIVOTDATA Might Not Be Entirely Evil #28 Eliminate VLOOKUP with the Data Model #29 Compare Budget Versus Actual via Power Pivot #30 Slicers for Pivot Tables From Two Data Sets #31 Use F4 for Absolute Reference or Repeating Commands #32 Quickly Convert Formulas to Values #33 See All Formulas at Once #34 Discover New Functions by Using fx #35 Calculate Nonstandard Work Weeks #36 Turn Data Sideways with a Formula #37 Handle Multiple Conditions in IF #38 Troubleshoot VLOOKUP #39 Replace Nested IFs with a Lookup Table #40 Suppress Errors with IFERROR #41 Handle Plural Conditions with SUMIFS #42 Geography & Stock Data Types in Excel #43 Dynamic Arrays Can Spill #44 Sorting with a Formula #45 Formula for Unique or Distinct #46 Other Functions Can Now Accept Arrays as Arguments #47 One Hit Wonders with UNIQUE #48 SEQUENCE inside of other Functions such as IPMT #49 Replace a Pivot Table with 3 Dynamic Arrays #50 Complex Validation Using a Formula #51 Use A2:INDEX() as a Non-Volatile OFFSET #52 Subscribe to Office 365 for Monthly Features #53 Speed Up VLOOKUP #54 Protect All Formula Cells #55 Back into an Answer by Using Goal Seek #56 Do 60 What-If Analyses with a Sensitivity Analysis #57 Find Optimal Solutions with Solver #58 Improve Your Macro Recording #59 Clean Data with Power Query #60 Render Excel Data on an iPad Dashboard Using Power BI #61 Build a Pivot Table on a Map Using 3D Maps #62 The Forecast Sheet Can Handle Some Seasonality #63 Perform Sentiment Analysis in Excel #64 Fill in a Flash #65 Format as a Façade #66 Surveys & Forms in Excel #67 Use the Windows Magnifier #68 Word for Excellers #69 Avoid Whiplash with Speak Cells #70 Customize the Quick Access Toolbar #71 Favorite Keyboard Shortcuts #72 More Excel Tips.