MrExcel 23

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

1 - Fast Formula Copy2 - Break Apart Data3 - Convert text #'s4 - Filter by Selection5 - Total Visible Rows6 - The Fill Handle 1, 2, 3… 7 - Fast Worksheet Copy8 - Defaults Future WB9 - Recover Unsaved Workbooks10 - Search in File, Open11 - Show Changes 60 Days12 - Collab13 - Sheet View14 - Threaded Comments 15 - Perfect 1-Click Charts16 - Paste New Data on a Chart17 - Create Interactive Charts18 - Chart 2 Orders of Magnitude19 - Waterfall Charts20 - Funnel Charts21 - Map Charts22 - Bell Curve23 - Plot People on a Bell Curve24 - Data Visualizations25 - Cutout People26 - Semi-Transparent Image27 - Save any object as image28 - List Format29 - Sort Using a Custom List30 - Sort Left to Right31 - Sort Subtotals32 - Sort & Filter by Color / Icon33 - Consolidate Qtr Worksheets34 - Create Your First Pivot Table35 - PT Year-over-Year36 - Change PT Calculation37 - True Top 5 in a PT38 - Defaults for All Future PT39 - PT Expandable Using Ctrl+T40 - Replicate a PT for Each Rep41 - Use a PT to Compare Lists42 - Sparklines and Slicers43 - GETPIVOTDATA use44 - Ask a Question45 - Data Model to Eliminate XLOOKUP46 - Budg v. Act'l via Power Pivot47 - PT Slicers from 2 Data Sets48 - F4 for $A$1 or Repeat49 - Formulas to Values50 - See All Formulas51 - Audit With Inquire52 - New Fx by Using fx 53 - Fx Args Nested Fx54 - Nonstandard Work Weeks55 - Sideways with a Formula56 - Multiple Conditions IF57 - Troubleshoot VLOOKUP58 - Wildcard in Lookup59 - 12 Benefits of XLOOKUP60 - Preview Remove Duplicates61 - Nested IFs v. Lookup62 - Suppress Errors with IFERROR63 - Plural Conditions w/ SUMIFS64 - Geo, XE & Stock Data Types 65 - STOCKHISTORY66 - Wolfram Alpha67 - Historical Weather for City68 - Create Data Types using PQ69 - Which language in Bilingual70 - Dynamic Arrays Can Spill71 - Sorting with a Formula72 - Filter with a Formula73 - Formula for Unique or Distinct74 - Fx Can Accept Arrays75 - 1 Hit Wonders with UNIQUE76 - SEQUENCE inside IPMT77 - Random #'s in Excel78 - PT with 3 DA79 - Dependent Validation DA80 - Complex Validation Formula81 - Stack Arrays82 - Drop, Take, Choose from Array83 - Reshaping Arrays84 - UNIQUE of Rectangular Range85 - Shuffle & Deal Cards86 - A2:INDEX() non-Volatile OFFSET87 - Microsoft 365 features88 - Perf Improvements89 - Unhide Multiple Worksheets90 - Action Pen91 - Take Panes Collapse92 - Feedback to the Excel Team93 - Date Tricks94 - LET95 - LAMBDA96 - Lamda helper functions97 - MAXIFS98 - TEXTBEFORE or AFTER99 - TEXTSPLIT100 - Less CSV Nagging+Autocomplete101 - Protect All Formula Cells102 - Goal Seek103 - Do 60 What-If Analyses104 - Solver105 - Interpolate106 - Improve Macro Recording107 - Clean Data Power Query108 - Fuzzy Match in PQ109 - PT on a Map 3D Maps110 - Forecast Seasonality111 - Sentiment Analysis112 - Visio Flowcharts113 - Fill in a Flash114 - Format as a Faç ade115 - Taskbar all open workbooks116 - Paste to Other Computer117 - Surveys & Forms in Excel118 - Windows Magnifier119 - Scrolling Tricks120 - Word for Excellers121 - Speak Cells122 - Customize QAT123 - QAT VBA Macros124 - Fav Keyb Shortcuts125 - Ctrl+Click to Unselect126 - Collapse the Search Box127 - More Excel Tips128 - Excel Stories129 - Quick Fx Reference