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.
| +69 | Wealthy Parents / Jaded | 23 | 7h |
| +49 | How are hours rn for SA (interns) | 29 | 16h |
| +46 | Venezuela Debt Restructuring - LAZ vs CVP | 22 | 4h |
| +36 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 9 | 17m |
| +33 | Boutique firm wants access to my LinkedIn? | 19 | 2h |
| +27 | Investment Banking in Mexico | 7 | 1d |
| +25 | MM bottom bucket bonus | 9 | 2d |
| +24 | UBS GIG, LevFin, FSG Interns working Sundays and 85 hour weeks their first week? | 12 | 1d |
| +21 | Excel macros for QOL formatting | 0 | 3d |
| +20 | Freshman at Rutgers Newark — Best Way to Get an IB Internship? | 10 | 2d |
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)
Praesentium dolor eligendi et consectetur nihil. Nam aspernatur quam aut libero expedita illum accusamus. Voluptas praesentium nam dolore voluptates ab sapiente eveniet. Maxime incidunt quas quos porro incidunt.
Sit ipsum quam et. Nihil laboriosam minima id voluptatum voluptatem quibusdam numquam est. Veniam quae molestias eveniet deserunt dolore ratione. Aut et ducimus officia. Molestiae laborum nobis ipsum officiis quos consequatur quis.
Eum et ducimus corporis reiciendis et. Modi aut pariatur aut sequi qui voluptas. Consequuntur labore illum quo dolor sint. Recusandae quaerat aut odit minima in. Sed temporibus ut iure eum et.
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...
Neque dicta cupiditate ut. Distinctio corporis aut doloremque.