Excel 2024: The Advanced Filter Treats Criteria as "Begins With"
February 17, 2025 - by Bill Jelen
Check out this simple use of Advanced Filter. You are asking for all rows with the Product of Apple to be copied to the output range.
More Reading
Excel 2024: Circle Invalid Data Automatically »
February 10, 2025 - by Bill Jelen
You have some numbers in a worksheet. Those cells should be between 60 and 90 inclusive.
Excel 2024: Temporarily Make Formula Bar Font Size Larger »
February 5, 2025 - by Bill Jelen
Say you have a Zoom or Teams call and you temporarily need to make the font size in the formula bar larger.
Excel 2024: Avoid Whiplash with Speak Cells »
January 30, 2025 - by Bill Jelen
One of the painful parts about keying in data is that you have to proofread the numbers. So, you are looking at the sheet of paper, then the screen, then the paper, then the screen. You will end up with a sore neck. Wouldn't it be nice if you had someone to read you the screen so you can keep your eye on the paper? It's built in to Excel.
Featured Products
April 2022
The 6th Edition of MrExcel XL, updated with new functions released for Microsoft 365.
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...
Programming PowerPoint with VBA
February 2022
This book assumes you already use PowerPoint and want to automate or enhance your presentations using Visual Basic for Applications (VBA). This book includes VBA samples for working with layouts, themes & masters, creating tables, drawing objects, charting, animation effects and event programming.