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 2022 adds information on collaboration features, LET and LAMBDA functions, amazing new data types, dynamic array formulas, and more.
Author(s): Jelen, Bill
Edition: 6
Publisher: Holy Macro! Books
Year: 2022
Language: English
Commentary: Excel 2022 edition, LET and LAMBDA functions, new data types, dynamic array formulas, and more
Pages: 301
Tags: Excel 2022 edition, LET and LAMBDA functions, new data types, dynamic array formulas, and more
"#10 Search While Using File Open" on page 30
"Bonus Tip: Pin an Item to the Top of the Recent Files" on page 30
"#11 Show Changes From Last 60 Days" on page 31
"Bonus Tip: Roll Back to a Previous Version of the Workbook" on page 32
"Bonus Tip: Avoiding the Veto" on page 35
"Bonus Tip: Data Validation Partial Matching Added in 2022" on page 43
Cartoon people added "#25 Use People to Add Interest to Your Worksheet" on page 62
"Bonus Tip: Replace Blank Values Cells With Zero" on page 89
Changed "#35 Create a Year-over-Year Report in a Pivot Table" on page 91
"XLOOKUP Benefit 9: Return All 12 Months in a Single Formula!" on page 164
Updated "Bonus Tip: Use Data, Refresh All to Update Stock Data" on page 176
"#77 Generating Random Numbers in Excel" on page 193
"#81 Stack Multiple Arrays" on page 197
"#82 Dropping, Taking, or Choosing from an Array" on page 198
"#83 Reshaping an Array to a Vector and Back" on page 200
"#84 Getting the UNIQUE of a Rectangular Range" on page 201
"#85 Shuffling and Dealing a Deck of Cards" on page 201
Updated "#95 Store Complex Formula Logic in LAMBDA function" on page 211
"#96 New LAMBDA Helper Functions" on page 224
"#98 Text Before or After a Specific Delimiter" on page 230
"#99 Split Text into Words Using TEXTSPLIT" on page 230
"#105 Interpolate between a starting and ending number" on page 242
"#116 Paste to Another Computer Using Cloud Clipboard" on page 268
"#119 New Scrolling Tricks" on page 271
"25. Ctrl+Shift+F1 for Full Screen Mode" on page 293
What's new in 2021:
Updates to "#44 Ask Excel's A.I. a Question About Your Data" on page 121
Faster "#3 Convert Text Numbers to Numbers Quickly" on page 6
"#13 Save Filter & Sorting in Sheet View" on page 36
Resolve comments in "#14 New Threaded Comments Allow Conversations" on page 39
"#25 Use People to Add Interest to Your Worksheet" on page 62
"Bonus Tip: Use a Formula to Toggle Pictures" on page 65
"#26 Make an Image Semi-Transparent" on page 68
"#27 Save Any Object as an Image" on page 69
"#65 Get Historical Stock History from STOCKHISTORY" on page 178
"#66 More Data Types from Wolfram Alpha" on page 179
"#67 Getting Historical Weather For a City" on page 180
"#89 Unhide Multiple Worksheets" on page 206
"#90 Write Your Data with the Action Pen" on page 207
"#91 Many Task Panes Now Collapse into a Tab Strip" on page 207
"#94 Use the LET Function to Re-Use Variables in a Formula" on page 209
"#95 Store Complex Formula Logic in LAMBDA function" on page 211
"Bonus Tip: Use TypeScript to Write Macros for Excel Online" on page 245
"Bonus Tip: Tame the Sequence of Refresh All" on page 249
"#129 Excel Function Quick Reference" on page 305
Holy Macro! Books
PO Box 541731, Merritt Island FL 32954
"#10 Search While Using File Open" on page 30
"Bonus Tip: Pin an Item to the Top of the Recent Files" on page 30
"#11 Show Changes From Last 60 Days" on page 31
"Bonus Tip: Roll Back to a Previous Version of the Workbook" on page 32
"Bonus Tip: Avoiding the Veto" on page 35
"Bonus Tip: Data Validation Partial Matching Added in 2022" on page 43
Cartoon people added "#25 Use People to Add Interest to Your Worksheet" on page 62
"Bonus Tip: Replace Blank Values Cells With Zero" on page 89
Changed "#35 Create a Year-over-Year Report in a Pivot Table" on page 91
"XLOOKUP Benefit 9: Return All 12 Months in a Single Formula!" on page 164
Updated "Bonus Tip: Use Data, Refresh All to Update Stock Data" on page 176
"#77 Generating Random Numbers in Excel" on page 193
"#81 Stack Multiple Arrays" on page 197
"#82 Dropping, Taking, or Choosing from an Array" on page 198
"#83 Reshaping an Array to a Vector and Back" on page 200
"#84 Getting the UNIQUE of a Rectangular Range" on page 201
"#85 Shuffling and Dealing a Deck of Cards" on page 201
Updated "#95 Store Complex Formula Logic in LAMBDA function" on page 211
"#96 New LAMBDA Helper Functions" on page 224
"#98 Text Before or After a Specific Delimiter" on page 230
"#99 Split Text into Words Using TEXTSPLIT" on page 230
"#105 Interpolate between a starting and ending number" on page 242
"#116 Paste to Another Computer Using Cloud Clipboard" on page 268
"#119 New Scrolling Tricks" on page 271
"25. Ctrl+Shift+F1 for Full Screen Mode" on page 293
What's new in 2021:
Updates to "#44 Ask Excel's A.I. a Question About Your Data" on page 121
Faster "#3 Convert Text Numbers to Numbers Quickly" on page 6
"#13 Save Filter & Sorting in Sheet View" on page 36
Resolve comments in "#14 New Threaded Comments Allow Conversations" on page 39
"#25 Use People to Add Interest to Your Worksheet" on page 62
"Bonus Tip: Use a Formula to Toggle Pictures" on page 65
"#26 Make an Image Semi-Transparent" on page 68
"#27 Save Any Object as an Image" on page 69
"#65 Get Historical Stock History from STOCKHISTORY" on page 178
"#66 More Data Types from Wolfram Alpha" on page 179
"#67 Getting Historical Weather For a City" on page 180
"#89 Unhide Multiple Worksheets" on page 206
"#90 Write Your Data with the Action Pen" on page 207
"#91 Many Task Panes Now Collapse into a Tab Strip" on page 207
"#94 Use the LET Function to Re-Use Variables in a Formula" on page 209
"#95 Store Complex Formula Logic in LAMBDA function" on page 211
"Bonus Tip: Use TypeScript to Write Macros for Excel Online" on page 245
"Bonus Tip: Tame the Sequence of Refresh All" on page 249
"#129 Excel Function Quick Reference" on page 305
