Optimal Excel Options / Settings?

What are the optimal excel settings / options when setting up a fresh computer?

Some standard ones:

  • Ensure Iterative Calculations are set to "Automatic except for data tables" & Maximum Iterations set to 100 (Should be default) [<Formulas]
  • Turn off "Allow editing directly in cells" [<Advanced]
    • This will allow you to edit in the formula bar for more complex / long equations
  • Set default font and size to Arial 10 (Optional) [<General]
  • Quick Access Toolbar
    • Font Size
    • Font Color
    • Fill Color
    • Borders
    • More Borders...
    • Size and Properties

Let me know of any other goods ones I'm missing.

Comments (1)

  • Analyst 1 in IB-M&A
1y 

Consectetur illum cum voluptatum quia velit sed totam. Quasi molestiae adipisci eum nulla quidem nesciunt. Optio ut qui placeat nesciunt ea. Pariatur ut quisquam consequatur sunt quia soluta. Fugiat dicta laudantium ut consequatur eos non.

Qui itaque vitae quia porro dolor. Est error qui quam quibusdam ducimus quo amet. Reiciendis enim et vero consequatur. Cupiditate rerum perspiciatis qui est.

Odit eos unde fuga. Non ratione suscipit ut sed. Provident necessitatibus ipsum nam ea non pariatur vel. Vero ipsa cupiditate totam qui rerum animi nihil. Ea at in corporis id.

Start Discussion

Career Advancement Opportunities

June 2023 Investment Banking

  • Lincoln International (▲01) 99.6%
  • Jefferies & Company (▽01) 99.1%
  • Financial Technology Partners (= =) 98.7%
  • William Blair (▲11) 98.2%
  • Lazard Freres (+ +) 97.8%

Overall Employee Satisfaction

June 2023 Investment Banking

  • William Blair (▲04) 99.5%
  • Lincoln International (▲11) 99.1%
  • Canaccord Genuity (▲18) 98.6%
  • Stephens Inc (▲12) 98.2%
  • Financial Technology Partners (▲09) 97.7%

Professional Growth Opportunities

June 2023 Investment Banking

  • Lincoln International (▲01) 99.5%
  • Financial Technology Partners (▲06) 99.1%
  • Jefferies & Company (▽02) 98.6%
  • Lazard Freres (▲15) 98.2%
  • UBS AG (▲19) 97.7%

Total Avg Compensation

June 2023 Investment Banking

  • Director/MD (6) $592
  • Vice President (32) $396
  • Associates (148) $260
  • 3rd+ Year Analyst (11) $198
  • 1st Year Analyst (280) $170
  • 2nd Year Analyst (91) $170
  • Intern/Summer Associate (46) $166
  • Intern/Summer Analyst (206) $93