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


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.


MrExcel 2021 - Unmasking Excel

February 2021

This is a 5th edition of MrExcel XL. Updates for 2021 include: LAMBDA, LET, Power Query Fuzzy Match, Sort & Filter in Sheet View, Cut-out people, Save object as image, STOCKHISTORY, Wolfram Alpha Data Types, Custom Data Types from Power Query, Weather data types, bilingual spreadsheets, Performance improvements, Unhide multiple worksheets, Action pen, Collapsible task panes, LET function to re-use calculations, store formulas using LAMBDA, Recursive LAMBDA, Branching LAMBDA, Lambda to return a picture, Excel function quick reference.


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


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.


see more products »