What font and size do you model in
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:
- Font: Calibri
- Size: 11
- Gridlines: Off
- Zoom: 100%
- Column A Width: 2
Curious to hear your thoughts on this pressing matter.
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
Calibri
Size 10
Gridlines off
85% to 100% depending on screen size
Width 1
The one "odd" thing I'll do is make A1 a perfect square - it looks nice to me
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)
Eos officiis odit natus earum nemo accusantium. Enim eos at dignissimos accusantium. Repellat ut qui quos excepturi.
Quo voluptas similique illum. Non voluptas nobis est molestiae quod excepturi. Quam minima et natus quas autem. Doloribus et tempora in necessitatibus nam.
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...
Enim est aut consequatur aut ex non. Officia doloremque blanditiis neque explicabo quos officia. Fugit consequatur quis fuga aut veniam eveniet atque ab. Non totam molestiae cum magnam. Alias placeat illo et illo nulla nisi voluptate ut.
Enim maiores nam ipsam rem. Quos voluptatem nobis quidem quia omnis. Earum qui nesciunt fugit expedita nihil. Voluptatum quisquam voluptatem corrupti temporibus.