Always been a default Calibri 11pt guy (esp because all the Cap IQ shortcuts follow that format and I’m too lazy to change them) but wondering if Arial pt10 is the way to go.
Current settings:
Curious to hear your thoughts on this pressing matter.
| +111 | I think I’m logging off after ER visit | 23 | 9h |
| +97 | Article: UBS Quietly Hollowing Out Its Onshore Workforce and Rebuilding the Bank in India | 25 | 6d |
| +93 | Fitting In as a first gen | 28 | 1d |
| +85 | Is it Bad That I ALREADY Don’t Care? | 26 | 11h |
| +84 | Senior Banker's Guide to IB Recruiting / Group Placement (with a Healthcare Bent) | 9 | 8h |
| +73 | AI Creating More Work | 25 | 9m |
| +59 | Consulting Son or CorpDev Daughter? | 6 | 4d |
| +55 | Shit PWP Culture | 39 | 3h |
| +44 | How easy was recruiting for you? | 21 | 4d |
| +35 | 22yo IB Analyst just had mental health breakdown | 11 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
calibri
size 9
no gridlines
zoom set to 90%
column A width = 1
Nice. Will also add my preferences too that’s a good call
Arial 8, 100%, no gridlines
Size 8 arial
Seems like Arial is the most prestigious. Changing my Excel settings as we speak.
Arial, 9, 90%, ALT+WVG
Font: Garamond/comic-sans
Size: 11
Gridlines during making the model, remove at end
Zoom: Usually 80-90%
Column A width 3
Wing Dings, size 30, gridlines on, 2% zoom
if you cant model in wingdings FS (font size...) 1 - may be best to re-evaluate a career in banking
Cambria size 6
The key to good modeling is having the excel be in size 5 or so, but make the outputs and sensitivities in size 20. This way, your associate will focus more on the output but less on the model itself as the font will be too small
The fact this was posted at ~2am speaks volumes
poor analyst - 2 in cov
Amateur hour over here Font: Wingdings Size: 8 Gridline: TBH I just highlight the tabs fill in the cells as white Zoom: 125% Mouse: yes Columns widths: vary to whatever the flavor of the hour is
Hey there, I currently model in
Font: Gill Sans Light Shadowed
Size: 6
Gridlines: On
Zoom: 160%
Column A Width: 0.5
How come no grid line?
Preftige
No way this is real. Any banker would know Alt W VG is the most important sequence of keys known to mankind. On the first day of my summer internship, my associate made me do 5 hours of Alt W VG reps until my fingers bled. To this day, the red marks on the keys show my devotion to the lack of gridlines.
arial 10
no gridlines
column A 2 width
zoom depends on monitor size
(matt ting also uses this and i worship him)
Based settings
Bump for Arial 10. I'll do 2 empty rows on all 4 sides and print screen capturing the 1 empty row and not capturing the other, was taught that way and looks clean
Holy shit this sounds beautiful. Will incorporate
This is 100% the way brother
Yessir - if helpful I also prefer adding in running mini-excel headers too on all my tabs. So something like:
I feel like such a nerd for writing that lol
what are your column widths for filled and empty columns?
I use size 3 for both side columns, and default for the top / bottom ones.
Also - Arial Narrow >> Arial IMO
No gridlines
Page Break Preview
Print Format: Landscape Orientation, Fit All Columns on One Page
Rows to repeat at top: 2:X
1 space row top (outside print area)
2 space columns left & right @ 1.5 (first outside print area, second inside)
Bottom of tab 2 rows @ 8 with Alt H B H line in between
Arial 9
Row height 10.75 (spacing rows 3,5,8 depending on relationship with row above/below)
Column width 6-7.75
Hardcodes 0/0/255
Cell links 0/128/0
Numbers #,##0.0;(#,##0.0);- [I hate _)]
Bravo
What does the "- [I hate _)]" do in the format? new to formatting
Arial 8
ALT W V G
Zoom depends on the monitor I am using and the hour of the day (eyes don't really work the same after looking at the screen for 15 hours)
Sequi qui itaque mollitia at et vero qui. Vel possimus perspiciatis quis minus consequatur dolores. Ea qui aperiam est praesentium temporibus tenetur sequi.
Velit quia fugit quo et rerum corporis recusandae. In ex animi reiciendis tempore inventore. Ut molestiae vero consequatur earum magnam omnis ea.
Odio quidem nisi voluptate ipsum sequi laboriosam. Nostrum ea nihil officiis et. In tempore et tempore officia ea ipsum. Quaerat rerum vel nihil et perspiciatis in. Rerum magni ut sint corrupti cum vel voluptatum. Natus non porro omnis perferendis iusto.
Est dolorum id labore pariatur aliquid sit culpa. Dolorem debitis quaerat voluptates ad nostrum sunt fugit. Voluptatem tempora numquam quos totam minus quisquam ab. Porro adipisci enim sapiente vitae est nihil dolor. Amet odio nihil fugit et. Ea animi ut nostrum. Temporibus consequatur mollitia expedita neque accusantium laborum odio est.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...
Mollitia dolores cumque sint consequatur architecto unde eos. Omnis doloribus sit amet quia sint vitae sapiente. Rerum rerum omnis omnis. Quos non veniam magnam laborum. Voluptatibus error quo est repellat.