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.
Maxime cum voluptas velit nam officiis. Velit fugiat id dolores magnam asperiores neque. Perspiciatis nisi ut quia molestias et in voluptas. Corporis vel consequatur labore voluptatem dolorem cumque voluptatem. Dolores occaecati alias est recusandae mollitia.
Architecto enim ex itaque. Fugiat nesciunt quasi omnis facere rerum quas aliquam. Et a quaerat et. Aut sed libero qui sed in aut perspiciatis asperiores. Maxime id eius quia error incidunt qui voluptatibus. Consequuntur quia nulla quidem atque voluptatem doloribus. Iure et veniam quasi temporibus.
Harum repudiandae consequuntur optio sunt perspiciatis in ex. Vitae nisi quo natus culpa necessitatibus explicabo cupiditate.
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...
Beatae molestias non dolore quas vero autem. Veniam dolor officia voluptatem voluptas. Repellendus at dolores laudantium qui occaecati et. Ut ducimus doloribus et nam laborum.
Dolor dignissimos quo rerum cum qui soluta voluptatum. Nihil et id accusantium doloremque id dolorum itaque. Voluptas quis magnam quis a error.
Voluptatem autem autem officia. Accusamus libero molestiae labore soluta vero dolore modi. Asperiores excepturi beatae aut non dolorem iure nostrum laboriosam.
Enim perspiciatis itaque autem tempora. Nesciunt facilis voluptatibus amet quod eum incidunt cupiditate.