Excel 2024: The Advanced Filter Treats Criteria as "Begins With"


February 17, 2025 - by

Excel 2024: The Advanced Filter Treats Criteria as "Begins With"

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.

continue reading »

More Reading


Excel 2024: Circle Invalid Data Automatically

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

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

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.

read more articles »

Featured Products


Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot

January 2025

Learn to use pivot tables and pivot charts in Microsoft Excel to produce powerful, dynamic reports in minutes: take control of your data and your business! Even if you’ve never created a pivot table before, this book will help you leverage their flexibility and analytical power and includes exploration of new array functions and Copilot capabilities in analysis creation.


Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)

April 2022

Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful.


MrExcel 2024 Igniting Excel

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...


MrExcel 2022 Boosting Excel

April 2022

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


see more products »