Excel 2024: Avoid Whiplash with Speak Cells


January 30, 2025 - by

Excel 2024: Avoid Whiplash with Speak Cells

I hate having to hand-key data into Excel. Between the Internet and Power Query, there almost always is a way to find the data somewhere. I hate when people send a PDF where they scanned some numbers and are sending the numbers as a picture. A free trial of Able2Extract Pro (mrx.cl/pdftoxl) will get the actual number into Excel. Even so, sometimes you end up keying data into Excel.

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.

continue reading »

More Reading


Excel 2024: Word for Excellers

Excel 2024: Word for Excellers »

January 27, 2025 - by Bill Jelen


While Excel fans sometimes tease that Word and PowerPoint are freeware apps that come with Excel, there are times when Microsoft Word offers a feature that Excel does not. In those cases, it makes sense to copy your data from Excel, paste to Word, do the command, then copy back to Excel.

Excel 2024: Get the Countries from a Column of Phone Numbers

Excel 2024: Get the Countries from a Column of Phone Numbers »

January 21, 2025 - by Bill Jelen


Someone had a long list of international telephone numbers. They asked if there is a formula to figure out the country from the phone number. It turns out that Country Codes are complicated. Some are a single digit. Some are 2 or 3 digits.

Excel 2024: Stale Value Formatting

Excel 2024: Stale Value Formatting »

January 16, 2025 - by Bill Jelen


The Excel team added Stale Value Formatting in late 2023. The idea is that you might be working in a workbook with Manual Calculation enable. The strike-through formatting will remind you that certain cells need to be re-calculated.

read more articles »

Featured Products


Financial Modelling in Power BI

September 2022

The only book to produce all three financial statements in Power BI.


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!


Your Excel Survival Kit - Second Edition

March 2021

This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.


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.


see more products »