Dream Excel Update

Full Disclosure: Most of my work/background is in c++ or python, so please excuse any typos in the hypothetical excel equations.

Oftentimes on anything remotely advanced, the formulas used in a cell of excel can get very long and cumbersome to read, even if you wrote it yourself. The colored "()" help some, but there is a much better way of making longer equations more readable. Just use multiple lines and indentions like any programming language has been doing for decades.
For those of you not familiar with programming, you can think of a program as the longest excel equation imaginable. Programmers keep things organized by keeping logical steps, and more importantly sub-steps broken up on new lines and indented to clearly show differences and hierarchies. It takes a little getting used to, but once you pass that point, even the most complicated, multi step, multi hierarchies make perfect sense at a glance.

Excel could keep everything as is, but add a tiny button on the far right hand side of the equation bar, that when pressed shows the equation below automatically broken out with logical spaces and indentations. It would be easy to toggle it back to normal, and once you are done with the cell, either way that stuff goes off of the screen.
I'm pretty sure algorithyms to automatically indent and spread a program/equation out over multiple lines logically already exist, especially for things as simple as advanced/long excel equations.

So, my question is, why hasn't excel already done something like this? (note: I realize that you can already alt-enter to space the equation out, but that takes time and doesn't indent or do it all automatically)

Some hypothetical examples:
=left(
        mid(
               substitute(
                                trim((A4)," ", "^",
                                len(trim(a4) ....
.....
......

=if(C7>1100,100,
                            if(C8>12,100,
                                                  else(C9>15,150,0)
                              )
   )

Attachment Size
long excel equation 25.49 KB 25.49 KB
 
Most Helpful

Have you heard of alt + enter ? It can create a line indent in the forumla bar of Excel. Although not perfect, it does remedy the excel formula lengthn and allows for easier readability. 

I also agree with the sentiment that Excel is best used as bursts of small, non-complex formulas across a workbook or formulas broken up into multiple formulas. The fact is, Excel's limitations are imminent in statistical analysis or text analysis. That's just not what excel was initially designed to do and despite the integrations and add-ons, it will look clunky. 

My Dream Excel update would be to simplfy the find text features and to also have "Left Align across Selection" + "Right Align across Selection". There are some very small grievances of mine regarding the formatting notions in specific. One core notion is how you can have boarders above or below cells that differ from boarders in adjacent cells and there's no easy way to tell which cell contains the boarder formatting. Think about that one for a section. 

 

Eum omnis facere dolores ut expedita consequuntur natus. Porro quam explicabo in distinctio ducimus mollitia. Iure architecto ipsa quia. Minima non dolorem corrupti.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”