MrExcel 2022

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.

#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