# MrExcel 2024 Igniting Excel

February 2024

The 7th Edition of MrExcel XL, updated with new functions released for Microsoft 365.

Add to Cart: $14.95 »- 326 pages
**Publisher:**Holy Macro! Books**PDF ISBN:**978-1-61547-171-3

This is the 7th edition of MrExcel XL. Updates for 2024 include: Remove Filter Items Using Search Box, The Consolas Font Makes it Easy to Tell Zero from the Letter O, Display Online Pictures In a Cell Using a Formula, Place Pictures In Cell From Local Computer, Using Artificial Intelligence with Copilot for Excel, Ask OpenAI Questions from Excel Using Excel Labs, Pivot Table with Sum and Average Total Rows (MDX), Sort into a Random Sequence, Create a Summary Table With the GROUPBY Function, Counting with GROUPBY, Moving from GROUPBY to PIVOTBY, Calculate Percent of Total with PERCENTOF Function, Number the Visible Rows in a Filtered Data Set, Using Python in Excel, Excel Pre-Loads Many Python Libraries, Python for K-Means Clustering of Excel Data, Combining Subformulas into a Single Lambda, Data From Picture is Not Power Query, Checkboxes, Prevent Default Conversions, Check Performance in Excel, See Intermediate Calculations, Stale Value Formatting, Sort by Font Width?!, Get the Countries from a Column of Phone Numbers, Temporarily Make Formula Bar Font Size Larger, Oddity 1: The Year 2025 is the Square of 45, Circle Invalid Data Automatically, The Advanced Filter Treats Criteria as Begins With"", Generate All Combinations Using BASE Function, Why a Dark Rectangle Around the Formula Bar?, Unhide One Specific Column Without Unhiding Others

Updates for 2022 include: Show Changes, Version History, Collaboration, Data Validation Partial Matching, Cartoon People, Stacking arrays with VSTACK, Array shaping with WRAP, TOCOL, and TOROW, Advanced Formula Editor, LAMBDA helper functions, TEXTSPLIT, TEXTBEFORE, TEXTAFTER, Paste between computers with the cloud clipboard, smooth scrolling, full screen mode, and more.

Updates for 2021 included: LAMBDA, LET, Power Query Fuzzy Match, Sort & Filter in Sheet View, Cut-out people, Save object as image, STOCKHISTORY, Wolfram Alpha Data Types, Custom Data Types from Power Query, Weather data types, bilingual spreadsheets, Performance improvements, Unhide multiple worksheets, Action pen, Collapsible task panes, LET function to re-use calculations, store formulas using LAMBDA, Recursive LAMBDA, Branching LAMBDA, Lambda to return a picture, Excel function quick reference.

Updates in 2020 included Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.