Excel - Spaces in Formula - ModelOff Alex Gordon - Episode 1841
2,024 views · Published 23 December 2013 · 4:02 · Indexed 30 October 2026
Channel: MrExcel.com · 2013 · Education
Microsoft Excel Tutorial: Improving Readability in Excel Formulas: Using Spaces to Enhance Clarity and Organization. Welcome back to the MrExcel netcast! I'm Bill Jelen and I am thrilled to be here at the 2013 ModelOff Financial Modeling Championships with last year's champion, Alex Gordon. In this podcast, we discuss a simple yet effective trick using spaces in formulas, as demonstrated by Alex himself. For those who may not know, Alex found out about the competition through a tweet I sent out last year. And now, he's back to defend his title and compete for the grand prize of $30,000. But before we get into the details of his winning formula, let's take a moment to appreciate the power of spaces in Excel. As Alex explains, using spaces in formulas can greatly improve readability and make it easier to understand complex calculations. By simply adding a space after each argument, the formula remains the same but becomes much more organized and easier to follow. However, it's important to note that a space should not be added before the first argument, as it can cause the formula to malfunction. But what about functions that require multiple arguments, such as the average function? Alex advises to be cautious when using spaces in these situations, as it can affect the accuracy of the calculation. It's best to add a space after the equals sign, but not between the function and the bracket. And for functions with multiple arguments, adding a space after each comma can greatly improve readability. So, why should we care about using spaces in formulas? Well, as Alex points out, it may not make a huge difference for the person building the formula, but it can greatly benefit those who need to read and understand it. And in a competition like ModelOff, where time is of the essence, every little advantage counts. Thank you for tuning in to this episode of the MrExcel netcast. And a special thank you to Alex Gordon for sharing his insights and tips with us. Don't forget to follow us on Twitter @MrExcel for more Excel tips and updates. And who knows, maybe you'll be the next ModelOff champion! 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) Meet Alex Gordon, ModelOff champion (00:38) Alex's tip for using spaces in formulas (01:16) Example of using spaces in a formula (02:03) Benefits of using spaces in formulas (03:00) Potential issues with using spaces in formulas (03:40) Alex's chances of winning again (03:50) 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: Alex Gordon Competition Financial modeling championships Model of champion Podcast Spaces and formula Total revenue calculation Tweet Wellington, New Zealand Winner prizes World champion Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153666/ Wouldyouthinkoftypingsentencewithoutspaces? Well, then why are you typing formulas without spaces? ModelOff 2012 World Champion Alex Gordon suggests you should be adding spaces in your formulas to make things easier to read.
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