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
Financial Modelling in Power BI
September 2022
The only book to produce all three financial statements in Power BI.
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.
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.
Financial Modelling Using Dynamic Arrays
December 2024
This book tries hard to raze a laugh (yes, that' s what was meant... ). Instead, through numerous examples and case studies, it details the impact of the ecosystem introduced by dynamic arrays in Excel, injecting life into the jaded, stale world of financial modelling.