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

Watch on YouTube

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