Excel/Computer Shortcuts
Hey Monkeys
Just lateraled to a new bank as a 2nd yr and everyone is significantly more efficient than me. What courses on computer and Excel shortcuts can you guys recommend?
I use my mouse way too much.
Thanks
Hey Monkeys
Just lateraled to a new bank as a 2nd yr and everyone is significantly more efficient than me. What courses on computer and Excel shortcuts can you guys recommend?
I use my mouse way too much.
Thanks
+145 | How to stop feeling like shit for not making it in IB? | 55 | 4h | |
+108 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 53 | 13m | |
+67 | Updated LA Banking Scene (2024) | 49 | 14h | |
+38 | Ranking banks that went under | 20 | 2h | |
+32 | A strategy for SA applicants late to the game like myself | 15 | 6h | |
+32 | Burnt Out M&A ASO | 17 | 3h | |
+31 | UBS Actual Buyside Exits 2024 Post-Integration | 9 | 3d | |
+29 | Relevance of A-Levels for U.K. London recruiting | 21 | 13h | |
+26 | Series 79 Help / Tips to Pass The First Attempt | 11 | 1d | |
+25 | Intern Ettiquette | 4 | 9h |
Career Resources
Just force yourself to use the shortcuts. Almost everything is driven off the Alt key.
If you haven't yet, be sure to download TTS, Macabacus, or some other macro kit. My bank uses TTS for the most part and I like it a lot.
Check out this free course https://www.udemy.com/ms-excel-from-0-to-working-professional-in-1-hour
good course
NuclearPenguins, got the most important points. Three others things that I would consider would be:
If you ever reach for your mouse, immediately do a Google search for how you could have accomplished this task with just the keyboard.
Ask your fellow analysts. At my MM, an analyst and I started compiling an Excel file with tips and tricks and before we knew it, every analyst was in on it. I probably learned more from that than I did from any class.
Use macros for any repetitive tasks that you have to regularly complete. Examples would be shading every other row (that mod row formula) or setting up the column headings for a DCF.
Good points by Sil here. To those of you who might be thinking "Googling shortcuts / using the Alt tab is going to be so much slower what a waste of time" - the point is that a little bit of pain up front will pay off immensely in the future. Sure, each shortcut will save you maybe 2 or 3 seconds only, but think about how many shortcuts you use in a full workday. That adds up and can mean you get to go home 30 minutes earlier (or more), which is huge.
Google search is the easiest way to find shortcuts in my opinion.
Macabacus also great general finance / modeling materials. The templates are a bit complicated though.
You should use BamSEC for filings and LogoIntern for logos.
Alt F X N - use it daily
classic
Favorite Computer/Browser Shortcuts (non excel)? (Originally Posted: 07/21/2016)
Isn't it annoying when you see someone scanning a page for a certain word or phrase and they don't know to just use ctrl-f?
What are your favorite / most useful keyboard shortcuts for your browser or computer (mac or pc)?
Windows + M
only on a Friday- Ctrl+alt+Del followed by lock this computer followed by getting a cab with a curvy brunette and heading to Marquee
Keyboard Shortcut (Originally Posted: 09/27/2006)
How do you maximize an explorer window using the keyboard? And not F11.
If you've minimized a window, then hit: windows key + shift + M
Is that what you need?
If a window is open and active but not maximized, how do you maximize it?
alt + spacebar + x. Curious to see if anyone has found a faster way.
Voluptas quis ut iusto quis aut. Ipsa quia et qui atque. Officiis reprehenderit hic aliquid modi est impedit. Blanditiis aperiam sed dolore quo. Voluptatem rerum rerum qui molestiae quibusdam.
Fugiat et earum enim molestias earum quia. Sequi quia incidunt distinctio ut excepturi doloribus eligendi. Voluptates aut distinctio cum cum natus consequatur. Ad odio possimus et quis magnam tenetur deleniti rerum. Dignissimos incidunt ratione non ea. Quasi rem amet corrupti rem. Et qui explicabo cum dicta sint earum.
Dolor et et amet nemo at exercitationem voluptates. Et sed nemo nihil qui. Dolores eos voluptatibus in nihil quia fugit. Nostrum veritatis ut rerum assumenda ducimus voluptate fugiat rerum.
Maiores quisquam est ut. Repellendus sit quo doloribus mollitia cupiditate. Qui sequi non quod ea officia. Ut ut maiores fugit. Et odit ea est voluptas quos necessitatibus.
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...