October 21, 2024 - by Bill Jelen
The use of worksheet protection in Excel is a little strange. Using the steps below, you can quickly protect just the formula cells in your worksheet.
It seems unusual, but all 16 billion cells on a worksheet start out with their Locked property set to True. You need to unlock all of the cells first:
Excel 2024: Split Text into Words Using TEXTSPLIT »
October 18, 2024 - by Bill Jelen
Many people had been asking for TEXTSPLIT. It was one of the most popular requests on the Excel UserVoice site. I often used a three-line User-Defined Function from Excel MVP Brad Yundt to create a function to split text into words.
Excel 2024: Text Before or After a Specific Delimiter »
October 15, 2024 - by Bill Jelen
The new TEXTBEFORE and TEXTAFTER functions debuted on March 16, 2022 for Microsoft 365 Insiders. These functions isolate the text before or after a specific delimiter.
Excel 2024: Find Largest Value That Meets One or More Criteria »
October 11, 2024 - by Bill Jelen
One of the new Office 365 functions added in February 2016 is the MAXIFS function. This function, which is similar to SUMIFS, finds the largest value that meets one or more criteria: You can either hard-code the criterion as in row 7 below or point to cells as in row 9. A similar MINIFS function finds the smallest value that meets one or more criteria.
The Transformative Magic of Power Query M Code in Excel and Power BI
August 2024
A beginner’s guide to mastering the art of data metamorphosis to get just the data structure needed to create insightful data analysis solution
Guerrilla Data Analysis Using Microsoft Excel - 3rd Edition
May 2022
Two of the leading Excel channels on YouTube join forces to combat bad data. This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, "MrExcel," and Oz do Soleil during their careers run as financial analysts.
February 2024
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, and more...
April 2022
The 6th Edition of MrExcel XL, updated with new functions released for Microsoft 365.