I consider myself as very detail-focused. However, I consistently get caught making mistakes when seniors turn comments because I’m literally doing 20+ drafts of the same excel or powerpoint. Just naturally you forgot one thing or something didn’t update properly. Anyone can share any tips on how you avoid these mistakes?
| +30 | SpaceX IPO - what are your thoughts | 5 | 18h |
| +27 | Should I use Claude or chatgpt? | 14 | 12h |
| +21 | Funny Things to Say to Interns | 7 | 1h |
| +17 | How did you meet your significant other/partner? | 13 | 15h |
| +17 | London's future as a financial centre | 18 | 1d |
| The Great Debate | 9 | 3h | |
| +7 | Test post will be deleted automatically. | 11 | 21h |
| +7 | E ink/electronic notepads | 4 | 15h |
| +6 | Stay Sharp All Day With Best Modvigil 200 MG Tablet | 0 | 12h |
| +5 | get a model before you model | 3 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
To avoid mistakes when working on multiple drafts of Excel or PowerPoint, here are some of the most helpful strategies from WSO's top-rated advice:
Print and Review: Errors are easier to spot on paper. Print your work and review it with a pen, marking off corrections as you go. Use a highlighter to ensure all comments are addressed.
Create Checklists: Adopt the method from The Checklist Manifesto by Atul Gawande. Create detailed checklists for every task, such as ensuring all comments are incorporated, formatting is consistent, and calculations are accurate.
Set a High Bar for Error Checking: Instead of just "reviewing," challenge yourself to find a specific number of mistakes in each draft. This approach forces you to scrutinize your work more thoroughly.
Use Spell Check and Search Functions: Always run spell check in Excel and PowerPoint. Use "Ctrl+F" to search for common errors, such as inconsistent formatting or missing elements.
Understand the Big Picture: Take a step back and understand the purpose of your work. Knowing the "why" behind your task helps you anticipate potential errors and ensures your work aligns with expectations.
Save Iterative Versions: For Excel models, save versions frequently (e.g., "Save As") to track changes and identify where errors might have been introduced.
Sanity Check Numbers: Perform rough math or back-of-the-envelope calculations to ensure numbers are directionally correct. If something seems off, investigate further.
Avoid Working When Tired: Mistakes are more likely when you're fatigued. If possible, schedule your most detail-oriented tasks when you're most alert.
Ask for a Second Pair of Eyes: Have a peer or colleague review your work, especially someone known for their attention to detail. A fresh perspective can catch things you might miss.
Leave the "To" Field Empty in Emails: When sending drafts or updates, leave the recipient field empty until you're ready to send. This prevents accidental premature emails.
By implementing these strategies, you can significantly reduce errors and improve the quality of your work.
Sources: How to train attention to detail, What I Wish Every First Year Analyst Knew, Practicing attention to detail, https://www.wallstreetoasis.com/forum/investment-banking/advice-on-improving-terrible-attention-to-detail?customgpt=1, Investment Banking Analyst: 15 Things I Wish I Knew
Sit porro et eius rerum nesciunt. Nesciunt omnis omnis cum autem cupiditate eligendi facere tenetur.
Non atque repellendus rerum aliquid voluptates temporibus natus consequuntur. Quis impedit adipisci ut quia sunt quidem.
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...