Excel tips to skyrocket white-collar productivity.
Originally designed for Bill Jelen's live Power Excel seminars, the target audience already uses Excel 40 hours a week. These tips are the "aha" tips that uncover secret methods in Excel. The book covers general Excel functions, pivot tables, and formulas such as VLOOKUP and the new XLOOKUP. It introduces elements of modern Excel such as the Power Pivot Data Model and cleaning data with Power Query. Updated annually, this edition for 2021 adds information on LET and LAMBDA functions, amazing new data types, dynamic array formulas, and more.
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
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.
