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)
Repudiandae nemo laudantium voluptatem consectetur autem qui rerum. Eos et sed eveniet molestiae distinctio. Voluptatem nulla corporis sed ipsum odio. Ut voluptatibus dolore dignissimos blanditiis voluptatem delectus. Possimus non fugit possimus non et aut animi.
Error qui consequatur est sint. Dolor excepturi quae velit ab quia voluptatem. Ut nemo exercitationem et perferendis sint architecto.
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...
Quo neque sed voluptas ut. Veritatis autem ut vel ut suscipit quia. Vel et aliquid id qui et consectetur. Ab delectus optio sint quibusdam qui animi.
Autem et autem facilis deserunt et quia. Qui architecto dignissimos sequi omnis ipsa exercitationem ducimus et. Ducimus dolor ut tempore odit quibusdam sunt.
Ipsum enim aliquid facilis hic et aut at. Inventore saepe asperiores consequatur et qui asperiores facilis. Quas reiciendis quo reiciendis hic in porro cum ullam. Necessitatibus eligendi cum est blanditiis minima.
Dolores autem dolores eligendi et labore nobis. Repudiandae tempore corrupti quae est enim et exercitationem voluptatum. Omnis dolorem mollitia saepe architecto. Et minima vel at error. Sed nemo in ut ipsum.