Jelen B. MrExcel 2022. Boosting Excel 6ed 2022

Textbook in PDF format

This is a 6th edition of MrExcel XL. 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