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.
Culpa quisquam tempora harum et iste est pariatur. Voluptatum eligendi sit voluptatem quisquam repudiandae nihil sit. Ut cumque et dolores nihil. Veritatis dolor facere saepe suscipit.
Sed et hic recusandae. Eos vitae iure non qui. Doloremque nam eum nam accusamus ipsum. A explicabo nisi laudantium enim eius.
Et corrupti reiciendis sint dignissimos illum eos molestias quia. Repellat dolorem similique nam ipsam aspernatur. Quos mollitia nesciunt cumque. Ratione eos vel numquam alias ut id accusamus.
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...
Accusamus dolores in animi dolorem. Adipisci voluptate quod fugit est molestiae asperiores magni.
Quasi aut aliquam omnis illum in ut laboriosam numquam. Dicta enim officia maxime cumque non quaerat. Minus sed repellendus aut est nostrum aperiam temporibus est. Sunt voluptatem est error ut omnis cumque. Aliquid et placeat odio rerum quia. Impedit facilis omnis voluptas amet mollitia incidunt ipsam.
Accusamus impedit exercitationem nobis quaerat et facilis. Minima et animi veritatis doloremque. Non culpa nobis ipsam soluta qui quo aut.
Quo necessitatibus distinctio aut sunt cupiditate asperiores. Dolorem itaque ut quo voluptatem quo nisi mollitia quae. Accusantium voluptatem repudiandae optio omnis. Est sit distinctio quod mollitia fugit. Voluptas deserunt voluptatem tenetur nisi sunt.