MrExcel 2024
eBook - ePub

MrExcel 2024

Igniting Excel

  1. 332 pages
  2. English
  3. ePUB (mobile friendly)
  4. Only available on web
eBook - ePub

MrExcel 2024

Igniting Excel

Book details
Table of contents
Citations

About This Book

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.

Frequently asked questions

Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
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 access MrExcel 2024 by Bill Jelen in PDF and/or ePUB format, as well as other popular books in Informatique & Applications de bureau. We have over one million books available in our catalogue for you to explore.

Information

Publisher
Holy Macro! Books
Year
2024
ISBN
9781615471713
Edition
1
Topic
Informatique
Subtopic
Applications de bureau

Table of contents

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