Excel - Craziest Newbie Excel Question: Excel Budgeting on a Piece of Paper?! - Episode 1422
741 views · Published 7 September 2011 · 3:04 · Indexed 8 November 2026
Channel: MrExcel.com · 2011 · Education
Microsoft Excel Tutorial: Craziest Newbie Excel Question: Excel Budgeting on a Piece of Paper?! Welcome back to the MrExcel netcast! In this episode, I want to talk about the craziest newbie question I've encountered when it comes to Excel. But before we dive into that, I want to give a shoutout to our sponsor, MrExcel.com. And if you're new here, make sure to subscribe to our channel for more Excel tips and tricks. As many of you know, I'm currently working on a new book for those who are new to Excel and may be a bit intimidated by it. And to make things more interesting, I want to hear your best stories about the craziest newbie questions you've encountered. We all have co-workers who are new to Excel and may not understand it as well as we do. So let's have some fun and share our experiences. Now, let me share one of my favorite newbie questions. I was on a finance committee and one of my colleagues had put together the budget for the next year on a piece of notebook paper. And to make things worse, he was using a calculator to add everything up. I couldn't help but suggest that it would be much easier to do it in Excel. But when he entered the heading for the fiscal year, something strange happened. The numbers changed to a date and he was completely baffled. He refused to use Excel after that, thinking that it would randomly change his numbers. Of course, we know that all he had to do was add an apostrophe before the numbers, but for a newbie, it can be quite confusing. And that's just one example of the many crazy newbie questions I've encountered. So, I want to hear from you. Shoot me an email at [email protected] with your best story and we'll feature it on our blog. And as a thank you, we'll choose some of the best stories and send you a selection of books from the MrExcel store. So, don't be shy, share your experiences with us. And for those of you who may be wondering why Excel doesn't do calculations automatically, well, you probably already know the answer. But for those who are new to Excel, it's important to remember that you need to start your formula with an equal sign or a plus/minus sign in order for it to work. It may seem like common knowledge to us, but for newbies, it can be quite confusing. So, let's have some fun and share our craziest newbie questions. And don't forget to subscribe to our channel for more Excel tips and tricks. Thanks for watching and we'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 Craziest Newbie Question (00:28) Example of a Newbie Question (01:14) Newbie's Reaction (01:24) Solution to the Problem (01:34) Explanation of Excel's Functionality (01:45) Confusion for New Users (02:43) Explanation of Excel's Calculation Process (02:54) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Episode 1422 Excel book Excel budgeting Excel calculator Excel date formatting Excel formula syntax Learn Excel MrExcel store Newbie question Worst Excel question Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153100/ Today in Episode #1422, a call to Excel-lers! What is the craziest newbie Excel question you've ever heard - or asked!? Send in your questions for a chance to win a prize.
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