Excel - Discover the Unconventional Read Aloud Method for Adding Numbers in Excel - Episode 1427
856 views · Published 15 September 2011 · 2:54 · Indexed 16 November 2026
Channel: MrExcel.com · 2011 · Education
Microsoft Excel Tutorial: Discover the Unconventional Read Aloud Method for Adding Numbers in Excel. Welcome to the MrExcel podcast. In this episode, #1427, we will be discussing the read aloud method in Excel. As many of you know, I recently released a new book called "Don't Fear The Spreadsheet" for those who are new to Excel. And let me tell you, the response has been amazing. I've received some great stories from readers, and today I want to share one of them with you. This story comes from a man named K, who works in IT support. He received a call from a new contractor who was struggling with VLOOKUP. K went over to help and quickly realized that the issue was not just with VLOOKUP, but with the contractor's method of adding up numbers. She would select the cells and then use the read aloud method to add them up. This involved saying the numbers out loud and then typing them in. K was amazed by this method and decided to share it with us. Now, I know what you're thinking - why not just use the SUM formula? Well, K tried to show her this, but she couldn't quite get the hang of it and went back to her read aloud method. This got me thinking, how many other people out there are using unconventional methods in Excel? According to statistics, there are 750 million Excel users and 40% of them have never entered a formula. That's a lot of potential for unique methods like the read aloud method. So, I want to hear from you. Have you ever come across a co-worker who has a unique way of using Excel? Maybe they have their own version of the read aloud method. Share your stories with me at [email protected] and you could be featured in an upcoming episode. And if your story beats K's, I'll even send you a copy of my book "Don't Fear The Spreadsheet" to share with your co-worker. I hope you enjoyed this episode and learned something new about Excel. Don't forget to subscribe to our channel for more helpful tips and tricks. Thanks for watching and I'll see you in the next netcast from MrExcel. Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) The Read Aloud Method for Copying Totals (00:20) Stories from new Excel users (01:00) Explanation of the method (01:31) Half the time, the numbers were transposed (01:47) Introduction to the SUM formula (02:01) Woman's reaction to the formula (02:11) Encouraging viewers to share their own stories (02:44) Clicking Like really helps the algorithm This video answers these common search terms: =SUM formula Adding up numbers in Excel Don't Fear The Spreadsheet Episode 1427 Excel for beginners Funny Excel stories IT support Learn Excel MrExcel podcast Read aloud method VLOOKUP Today, in Episode #1427, Bill shares an interesting way to find totals in Excel ... the Read Aloud Method! This episode is another in our series for Don't Fear the Spreadsheet. Send in your best Excel Newbie stories! Learn Excel from MrExcel! Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153105/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920