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?
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?
Pornhub plug-in. Game changer.