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


Power BI for the Excel Data Analyst

July 2022

A step-by-step guide on how to use Power BI. Written with Excel fans in mind, but with every Power BI student at its heart.


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.


Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)

December 2021

Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business!


Microsoft 365 Excel: The Only App That Matters

June 2022

Excel Worksheet, Power Query, Power Pivot, Power BI. Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight!


see more products »