MrExcel 2022
eBook - ePub

MrExcel 2022

Boosting Excel

  1. 298 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

MrExcel 2022

Boosting Excel

About this book

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.

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription.
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn more here.
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes! You can use the Perlego app on both iOS or Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Yes, you can access MrExcel 2022 by Bill Jelen in PDF and/or ePUB format, as well as other popular books in Computer Science & Desktop Applications. We have over one million books available in our catalogue for you to explore.

Information

Publisher
Holy Macro! Books
Year
2022
Print ISBN
9781615470716
eBook ISBN
9781615471621
Edition
6
Topic
Computer Science
Subtopic
Desktop Applications
Index
Computer Science

Table of contents

  1. Foreword
  2. Sample File Downloads
  3. Double-Click the Fill Handle to Copy a Formula
  4. #1 Break Apart Data
  5. #2 Convert Text Numbers to Numbers Quickly
  6. #3 Filter by Selection
  7. #4 Total the Visible Rows
  8. #5 The Fill Handle Does Know 1, 2, 3…
  9. #6 Fast Worksheet Copy
  10. #7 Use Default Settings for All Future Workbooks
  11. #8 Recover Unsaved Workbooks
  12. #9 Search While Using File Open
  13. #10 Show Changes From Last 60 Days
  14. #11 Simultaneously Edit a Workbook in Microsoft 365
  15. #12 Save Filter & Sorting in Sheet View
  16. #13 New Threaded Comments Allow Conversations
  17. #14 Create Perfect One-Click Charts
  18. #15 Paste New Data on a Chart
  19. #16 Create Interactive Charts
  20. #17 Show Two Different Orders of Magnitude on a Chart
  21. #18 Create Waterfall Charts
  22. #19 Create Funnel Charts
  23. #20 Create Filled Map Charts in Microsoft 365
  24. #21 Create a Bell Curve
  25. #22 Plotting Employees on a Bell Curve
  26. #23 Add Meaning to Reports Using Data Visualizations
  27. #24 Use People to Add Interest to Your Worksheet
  28. #25 Make an Image Semi-Transparent
  29. #26 Save Any Object as an Image
  30. #27 Set Up Your Data for Data Analysis
  31. #28 Sort East, Central, and West Using a Custom List
  32. #29 Sort Left to Right
  33. #30 Sort Subtotals
  34. #31 Sort and Filter by Color or Icon
  35. #32 Consolidate Quarterly Worksheets
  36. #33 Create Your First Pivot Table
  37. #34 Create a Year-over-Year Report in a Pivot Table
  38. #35 Change the Calculation in a Pivot Table
  39. #36 Find the True Top Five in a Pivot Table
  40. #37 Specify Defaults for All Future Pivot Tables
  41. #38 Make Pivot Tables Expandable Using Ctrl+T
  42. #39 Replicate a Pivot Table for Each Rep
  43. #40 Use a Pivot Table to Compare Lists
  44. #41 Build Dashboards with Sparklines and Slicers
  45. #42 See Why GETPIVOTDATA Might Not Be Entirely Evil
  46. #43 Ask Excel's A.I. a Question About Your Data
  47. #44 Eliminate VLOOKUP or XLOOKUP with the Data Model
  48. #45 Compare Budget Versus Actual via Power Pivot
  49. #46 Slicers for Pivot Tables From Two Data Sets
  50. #47 Use F4 for Absolute Reference or Repeating Commands
  51. #48 Quickly Convert Formulas to Values
  52. #49 See All Formulas at Once
  53. #50 Audit a Worksheet With Spreadsheet Inquire
  54. #51 Discover New Functions by Using fx
  55. #52 Use Function Arguments for Nested Functions
  56. #53 Calculate Nonstandard Work Weeks
  57. #54 Turn Data Sideways with a Formula
  58. #55 Handle Multiple Conditions in IF
  59. #56 Troubleshoot VLOOKUP
  60. #57 Use a Wildcard in VLOOKUP or XLOOKUP
  61. #58 Twelve Benefits of XLOOKUP
  62. #59 Preview What Remove Duplicates Will Remove
  63. #60 Replace Nested IFs with a Lookup Table
  64. #61 Suppress Errors with IFERROR
  65. #62 Handle Plural Conditions with SUMIFS
  66. #63 Geography, Exchange Rate & Stock Data Types in Excel
  67. #64 Get Historical Stock History from STOCKHISTORY
  68. #65 More Data Types from Wolfram Alpha
  69. #66 Getting Historical Weather For a City
  70. #67 Create Your Own Data Types Using Power Query
  71. #68 IF Based on Installed Language in a Bilingual Worksheet
  72. #69 Dynamic Arrays Can Spill
  73. #70 Sorting with a Formula
  74. #71 Filter with a Formula
  75. #72 Formula for Unique or Distinct
  76. #73 Other Functions Can Now Accept Arrays as Arguments
  77. #74 One Hit Wonders with UNIQUE
  78. #75 SEQUENCE inside of other Functions such as IPMT
  79. #76 Generating Random Numbers in Excel
  80. #77 Replace a Pivot Table with 3 Dynamic Arrays
  81. #78 Dependent Validation using Dynamic Arrays
  82. #79 Complex Validation Using a Formula
  83. #80 Stack Multiple Arrays
  84. #81 Dropping, Taking, or Choosing from an Array
  85. #82 Reshaping an Array to a Vector and Back
  86. #83 Getting the UNIQUE of a Rectangular Range
  87. #84 Shuffling and Dealing a Deck of Cards
  88. #85 Use A2:INDEX() as a Non-Volatile OFFSET
  89. #86 Subscribe to Microsoft 365 for Monthly Features
  90. #87 Performance Improvements for Microsoft 365
  91. #88 Unhide Multiple Worksheets
  92. #89 Write Your Data with the Action Pen
  93. #90 Many Task Panes Now Collapse into a Tab Strip
  94. #91 How to Provide Usable Feedback to the Excel Team
  95. #92 Date Tricks in Excel
  96. #93 Use the LET Function to Re-Use Variables in a Formula
  97. #94 Store Complex Formula Logic in LAMBDA function
  98. #95 New LAMBDA Helper Functions
  99. #96 Find Largest Value That Meets One or More Criteria
  100. #97 Text Before or After a Specific Delimiter
  101. #98 Split Text into Words Using TEXTSPLIT
  102. #99 Less CSV Nagging and Better AutoComplete
  103. #100 Protect All Formula Cells
  104. #101 Back into an Answer by Using Goal Seek
  105. #102 Do 60 What-If Analyses with a Sensitivity Analysis
  106. #103 Find Optimal Solutions with Solver
  107. #104 Interpolate between a starting and ending number
  108. #105 Improve Your Macro Recording
  109. #106 Clean Data with Power Query
  110. #107 Use Fuzzy Match in Power Query
  111. #108 Build a Pivot Table on a Map Using 3D Maps
  112. #109 The Forecast Sheet Can Handle Some Seasonality
  113. #110 Perform Sentiment Analysis in Excel
  114. #111 Build Org Charts with the Visio Data Visualizer in Excel
  115. #112 Fill in a Flash
  116. #113 Format as a Façade
  117. #114 Show All Open Workbooks in the Windows Taskbar
  118. #115 Paste to Another Computer Using Cloud Clipboard
  119. #116 Surveys & Forms in Excel
  120. #117 Use the Windows Magnifier
  121. #118 New Scrolling Tricks
  122. #119 Word for Excellers
  123. #120 Avoid Whiplash with Speak Cells
  124. #121 Customize the Quick Access Toolbar
  125. #122 Create Your Own QAT Routines Using VBA Macros
  126. #123 Favorite Keyboard Shortcuts
  127. #124 Ctrl+Click to Unselect Cells
  128. #125 Collapse the Search Box
  129. #126 More Excel Tips
  130. #127 Excel Stories
  131. #128 Excel Function Quick Reference
  132. Dedication
  133. About the Author
  134. About the Illustrators
  135. Index