Hello All,
I'm a recent graduate starting soon on a structured product desk and I want brush up on my Excel and PowerPoint skills. Does anyone have any ideas or resources that they would recommend?
Thanks, Jgills
| +286 | UBS Tech MD hires Son (from no-name college) as an Intern | 49 | 19h |
| +124 | Is banking in the south more sustainable? | 29 | 15h |
| +101 | The Intern Starter Pack | 17 | 7h |
| +76 | Current State of the League Tables | 28 | 1d |
| +75 | [Official] 2026 IB Analyst Bonus Megathread (with 2025 Consolidated Pay and Perks/Benefits) | 11 | 11h |
| +51 | Perella Weinberg to Cut 10% of Workforce, Including Partners | 33 | 7h |
| +40 | UBS Groups Ranked by Future Outlook | 20 | 2d |
| +34 | Are all Tech / TMT groups sweaty? | 19 | 1h |
| +32 | PWP Layoffs????? | 18 | 4d |
| +32 | UVA McIntire vs Cornell Dyson for IB | 19 | 10h |
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.
http://www.amazon.com/Excel-2007-Bible-John-Walkenbach/dp/0470044039/ref=sr_1_2?ie=UTF8&qid=1314575974&sr=8-2
http://www.amazon.com/PowerPoint-2007-Bible-Faithe-Wempen/dp/0470043687…
http://www.traders-library.com/download/Brealey%20&%20Myers%20-%20Finan…
http://www.traders-library.com/download/Microsoft%20Office%20Excel%2020…
Free.
Excellent! http://www.traders-library.com
How to learn banking excel and powerpoint? (Originally Posted: 04/09/2011)
Is there a website that has a tutorial teaching excel shortcuts (used in banking), and powerpoint presentations (for company profiles and pitchbooks)?
google it. there are a lot of good youtube videos as well
pretty sure there is a thread on shortcuts. do a search.
alt + e + s + t ................done.
http://www.google.com/url?sa=t&source=web&cd=1&ved=0CBQQFjAA&url=http%3…
I don't know excel or powerpoint too well - how bad is this? (Originally Posted: 07/12/2010)
Starting my BB FT analyst program soon, and I don't really know excel or powerpoint beyond the basics (very few shortcuts, none of the advanced functions etc.).
I can basically use excel as far as understanding data in there and putting in simple formulas. Powerpoint is even worse.
How much of a disadvantage is this going to be? Do many of you (students or current analysts) learn excel specifically for the job before starting or just pick things up on the job?
you'll pick it up on the job dude. i used to stress about this too before i realized that i'll be spending 80 hours a week getting better at it
just print out excel short cuts off the millions of websites. http://www.WallStreetPrep.com/blog/excel_resources.php
http://www.youtube.com/user/ExcelIsFun
Download the workbook to go with the tutorials. Helped me a ton
Developing your Excel and Powerpoint skills (Originally Posted: 08/05/2010)
Hi,
I've been on the IBD desk now for a few months but I am still finding tasks on Powerpoint and Excel that should really take 1 hour actually take me a lot longer beacuse of my weak computer skills.
Does anyone know of any books, tuition courses, computer programs that I could use so that I can develop my computer skills further in spare time?
Any advice much appreciated, Thanks
Did they not train you in Excel?
Pick up a book at Borders or B&N on excel skills. Also, there are some good youtube tutorials on how to use some of excel's more powerful features.
With powerpoint, take some time to mess around to figure out how to make things look nice. The new version of ppt has some auto graphics features and a better color palette, so even if you're not all that good, it can make your presentation look pretty nice.
How long have you been using the programs for? It is a steep learning curve but the tasks get easier with every attempt.
How to get better at ecel and powerpoint? (Originally Posted: 06/12/2013)
Okay guys, If I suck terribly at Excel (since as a former poly sci major I never really had to use it that often), do you think I should try to teach myself how to use it better if I plan on getting an internship next summer? I should be able to get some more exposure to it during this upcoming college year since I'll be switching my major to economics but I still highly doubt it will be enough for me to become at least an intermediate at it. I don't want to be that annoying intern who doesn't know how do simple shit like formatting and whose incredibly slow and always has to ask questions and on top of that who does things wrong. I also want to be able to help full timers out if I see them getting overwhelmed instead of sitting there and being useless. Your feedback would be greatly appreciated, thanks.practice. there's no shortcut.
I know a shortcut or two with Excel.
You should learn to properly spell Excel, otherwise you'll end up "ref'ing" out on all your formulas.
I knew at least one asshole was going to write that. It was a typing mistake that I didn't catch until after I posted it. Dick.
Mollitia delectus aut qui. Incidunt ratione labore eos deleniti assumenda. Dolores eligendi cupiditate voluptas nemo cupiditate ea recusandae. Voluptatem at earum eius porro.
Voluptas rerum beatae distinctio ad qui quas. Ipsum eligendi porro dolorum et qui est. Corrupti enim culpa consequuntur.
Sunt est consequatur sit nulla corporis esse voluptas. Possimus cum est ipsum dolores unde. Quae facere voluptas aliquid vitae molestias ratione debitis.
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...
Perspiciatis quo cum autem repudiandae dolorem et. Modi odio fugit nesciunt voluptatem itaque doloribus eum velit. Sed natus non sit sunt et rerum velit. Qui quo eius voluptatem velit quod nobis ut.
Qui quaerat fugiat exercitationem debitis est. Laborum delectus molestiae sit qui ipsum necessitatibus. Quod quia sunt tempore. Et pariatur eveniet accusantium quia facilis sint quo et. Quisquam et ipsum quae deserunt rem. Quae adipisci laudantium accusamus minima. Incidunt illo aut quae dolor.