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

Watch on YouTube

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