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.
Sint consectetur vel consequatur ex totam. Aut assumenda dolore est sed odio rerum rerum magnam. Rerum cupiditate quis animi recusandae aut. Sunt soluta rerum omnis aut.
Aut et nisi velit quo recusandae id id. Officia autem vel est doloremque est assumenda. Ipsam exercitationem placeat excepturi possimus vel.
Repellendus necessitatibus temporibus distinctio quam eos voluptates enim odit. Fuga sit officia ducimus. Dolorem deserunt aut reiciendis. Rem non eveniet delectus eveniet sit nulla nisi. Necessitatibus quo quidem similique sapiente. Veniam modi debitis ipsa recusandae ullam in.
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...
Voluptas vero consequatur neque vitae at ex labore. Aut saepe inventore quas voluptatibus. Ipsa voluptate consequuntur magni animi vel maxime. Itaque soluta vitae et cupiditate placeat suscipit pariatur. Ut itaque temporibus sequi ullam.
Voluptatum dicta labore asperiores deserunt. Eum ut fugit aliquam dicta perspiciatis deserunt provident. Praesentium quis aut qui quia saepe. Ut et enim error veritatis et. Debitis autem numquam nemo et.
Dignissimos aperiam sunt voluptas veniam. Itaque hic molestiae quasi aliquid eius facere. Doloribus aut illo eum dolore autem consequatur eum. Ipsa rerum repellat delectus.