What additional Excel functions do you wish for?
I am of the opinion that overall the years, Excel hasn't addressed some of the key issues that make an Analyst's life harder.
For starters: 1. Trace precedents - I can't think of an excuse to not develop a function that allows you to trace multiple precedents or dependents. If you're auditing a model and you see a formula with 15 ifs, 5 chooses and 2 index matches, you'll want to kill yourself going through each reference using F5.
Shortcut for align across selection - my biggest pet peeve is when I see someone use Merge and Center instead of Align Across Selection. There is not a lot of instances where you really need to merge cells. People like to use it just for the center function. So, why not make the Align Across Selection easier to use?
A mode that automatically turns constant numbers blue, direct links green and external links red
And how can I forget - the Eyedropper
What is your wish list?
Hopefully this goes to the front page, then WallStreetOasis.com can do a poll and send it to Satya Nadella. Lol.
Macabacus is a godsend. They'll typically give you a free membership for their plug-in as well.
You could disable F1 with a macro:
Private Sub Workbook_Open()
Application.OnKey "{F1}", ""
End Sub
Try using crtl+alt+v instead to bring up paste special. I’ve found it to be faster as it’s a more fluid motion than alt+e+s
I wish the VLookup function could find me a nice MD with tight buns so I cold park one in his ass for the night!
As mentioned, plug-ins solve this.
Ctrl 1, bro. Then right arrow, tab, down 6, enter. Second nature to me. You can also just use it once and then paste format whenever you want something else. You can also record a macro and put it up on QAT but you can't undo a macro so it's kind of a pain.
IDK, there's not much excel can't do when you start writing macros. I've experimented with some formatting macros that I couldn't figure out how to get to work without super complicated code so maybe some sort of dumbed down VBA for those of us who don't have time/patience to learn it?
Faster if you do Ctrl 1 > Right Arrow > Tab > C > C
:)
Nice!
I tried doing this in the past and it didn't work so I didn't go back but I just did it and it works now so thanks!
^Next level contingency planning right there. SB.
Good point but if you've got your own computer then you can put formatting macros in your "Personal" workbook and run them in non macro-enabled files.
This is so nerdy.
Not sure if your firm allows you to download addins for excel but there is one called Boost that allows you to map any ctrl + "key" command to just about any toolbar function. (I admit I have gotten quite used to Alt + commands to navigate the toolbar but Boost is really useful for those formatting shortcuts you seem to use every 20 seconds. It would be (marginally) easier to map a ctrl command to align and center than Ctrl 1 > right > tab > c > c
Fuck it, record a macro, takes ten seconds and then center / align is CTRL + Shift + Q.
Keyboard shortcuts for choosing colors, not just bringing up the color menu. Arrowing around that shit is annoying as hell. Also putting recent colors at the top. And the ability to change standard colors (assuming this is possible somehow but I've never looked into it).
But even more important, saving defaults. This might be possible and if it is someone please let me know, but things like automatically open without gridlines so I don't have to hit Alt WVG every time I start a new sheet. And automatically set auto calc to exclude data tables. Set default font/size, etc
Kid at my last bank wrote a macro that cycled our primary colours, so he'd write titles in the first row, hit CTRL +x once, boom, title row is BB Blue, second row: add units, CTRL+x twice, boom, unit row is now BB second colour, etc.
Only downside is that some clients can't accept books with Macros, so you have to add removing the macros to your pre-send checks.
1
Or just use ctrl + 1
F1
I know that this thread is old, but FYI QAT can add fill up, [down], [left], right under the home tab commands. I QAT up and left... Unless your issue is that excel doesn't recognize a series [e.g Jan, Feb, Mar] with key commands... then I cannot help.
A shortcut for balancing the model.
1) FactSet plug-in 2) FactSet plug-in 3) FactSet plug-in
Dude get Macabacus. It's free and it's a life-changer....
Pornhub plug-in. Game changer.
Making data tables with inputs across sheets less cumbersome.
For #1 I use ALT+ M + P for Precedents and for dependents: ALT + M + D.
Native trace indirects. If you're outputting data from a terribly formatted company template, or if your firm's comps template is built around indirects (mine was; it sucked), it's a complete pain to trace without a macro.
Yes, I know the macro is easy to write, but there's really no excuse for MS not supporting this function natively.
Nemo autem odio aspernatur itaque distinctio. Perspiciatis rerum in et et. Maiores rerum qui quasi voluptatibus corporis error amet aperiam.
Aliquid est ex aut quas. Et aliquam ut veniam eum. Eos dolores vel vitae quod deserunt exercitationem nostrum. Est sed molestiae sequi dolor et illum consequatur.
Consequatur quo in minus natus unde rerum. Voluptas officia est voluptatem atque ut illo. Ut laborum placeat qui nulla molestiae autem ut. Similique non et ea aut reprehenderit quam et sunt. Voluptas ipsa ut porro dolores odio vero laudantium. Expedita consequatur suscipit voluptate totam cupiditate perspiciatis esse.
Quia est nulla ut impedit deleniti rem sed. Aperiam mollitia qui reiciendis dolore est perspiciatis maiores. Aut repellat et quia est aperiam.
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...
Ullam aut pariatur perspiciatis voluptate ut. Unde et earum et. Eum doloremque non saepe sed ducimus possimus maiores.
Commodi magni ea optio quis non culpa fuga. Consequatur in tempore aut. Sit nihil ut praesentium saepe animi id. Facere ex alias rem ab consequatur voluptate et. Aliquam culpa eum omnis dolores ducimus qui sed.
Minima exercitationem consequuntur sint nemo inventore amet quisquam voluptas. Nulla animi labore quaerat ut. Explicabo accusantium ad illo necessitatibus excepturi odio. Qui similique optio doloremque ut perspiciatis.