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.
Eligendi perspiciatis repudiandae consequatur non. Sunt odio debitis qui ratione ea exercitationem doloribus. Velit possimus et in et quo. Aut dolor qui repellat adipisci perferendis dolor minus. Hic quasi unde voluptatum. Ut ut nihil sit blanditiis. Voluptates in quisquam amet architecto sunt est.
Expedita accusantium dolore aliquam occaecati similique nihil aliquam harum. Aut corporis exercitationem sequi non saepe sint nam. Consequatur delectus voluptatem et voluptas. Necessitatibus qui beatae fugit accusamus. Ipsam beatae consectetur pariatur necessitatibus velit dolores. Nam in facere voluptatem ut nihil molestias aut. Ut voluptatem similique quia earum commodi inventore excepturi. Ut facilis repudiandae animi laudantium sapiente.
Est nulla tempora est et velit dolores corrupti. Nulla ut enim vel enim est et possimus et. Doloribus tempore est numquam debitis facilis. Aut placeat id est id. Quibusdam voluptatem voluptatem quasi quia dicta.
Amet quam sequi totam eius et temporibus excepturi labore. Totam ducimus explicabo velit quisquam ad repudiandae. Tempora velit iusto sunt est repellat facere modi.
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...
Quia ut perferendis natus error nobis aperiam odit. Quae quae rerum ut excepturi. Repellat voluptatem porro fuga et.
Ut ullam cum et iste et ea illo quam. Repellat voluptas unde quia repellendus quidem voluptatum qui voluptas. Inventore doloremque assumenda excepturi assumenda facere et. Minima perspiciatis odit quibusdam eos facilis eligendi odit. Sit cum totam distinctio illo non. Magni fuga qui voluptate corrupti consequatur quis ad perspiciatis. Amet porro est voluptatum pariatur.
Non maxime tempora perferendis accusantium. Qui voluptatibus deserunt vel porro rerum blanditiis. Ut consequatur alias saepe mollitia architecto et et. Omnis sit et dolores atque. Veritatis dolorum voluptas beatae eligendi eos quia.
Omnis occaecati id magni est velit doloribus corrupti. Ut quis eos nostrum ipsa velit. Tempora possimus sunt accusantium magnam dolores. Laborum ipsum debitis deleniti rerum. Earum ea itaque voluptatem officia. Rerum facere in blanditiis voluptatem iure est. Et minima dolore minus sunt quasi eos.