Excel Shortcuts Investment Banking: Quick Tips



You’ll get a quick, but very powerful, tip on how to optimize your Excel setup with the Quick Access Toolbar (QAT) and custom shortcuts in this tutorial. These tips will save you a ton of time when creating valuations, organizing data, and doing any formatting exercise.

http://breakingintowallstreet.com/

„Financial Modeling Training And Career Resources For Aspiring Investment Bankers“

Shortcuts Introduced:

These are all BUILT-IN shortcuts:

Alt, T, O: Options Menu
Alt, H, FC: Font Color
Alt, H, FS: Font Size
Alt, H, H: Fill Color
Alt, H, A, C: Center
Alt, H, B: Borders
Alt, H, O, I: AutoFit Column Width
Alt, H, O, W: Column Width
Alt, H, 0: Increase Decimal Places
Alt, H, 9: Decrease Decimal Places

These are the NEW shortcuts you can create via the Quick Access Toolbar:

Alt, 1: Font Color
Alt, 2: Font Size
Alt, 3: Fill Color
Alt, 4: Center
Alt, 5: Borders
Alt, 6: AutoFit Column Width
Alt, 7: Column Width
Alt, 8: Increase Decimal Places
Alt, 9: Decrease Decimal Places

Lesson Outline:

Many Excel shortcuts that you use repeatedly when creating valuations, models and when formatting data are cumbersome to enter.

Something as simple as changing the font color takes 4 keystrokes – Alt, H, F, C – if you use the built-in method for it.

Other common commands such as alignment, fill colors, borders, and column widths also take 3-4 keystrokes.

A more efficient alternative is to set up the Quick Access Toolbar (QAT) so that you can access the most common commands with shortcuts like Alt, 1 instead.

You can either import our file (see the link below under RESOURCES) or go to the Options menu (Alt, T, O) and then the Quick Access Toolbar tab, and create the menu yourself.

We recommend setting “Font Color” in position #1, followed by Font Size, Fill Color, Center, Borders, AutoFit Column Width, Column Width, and Increase and Decrease Decimal places.

These are some of the most frequently used commands in Excel, and you’ll save a ton of time with the new, shorter versions.

A command like AutoFit Column Width that used to take 4 keystrokes now takes only 2 (Alt, 6) with this approach.

You might realize 30-40% time savings when working in Excel if you use this full set of shortcuts. They’re especially useful for formatting and analyzing data and doing the initial setup in financial models.

RESOURCES:

https://youtube-breakingintowallstreet-com.s3.amazonaws.com/Excel-QAT-Export.exportedUI

https://youtube-breakingintowallstreet-com.s3.amazonaws.com/Excel-Shortcuts-Investment-Banking-Slides.pdf

Kostenlose Immobilienbewertung


source

Immobilienmakler Heidelberg

Makler Heidelberg

Immobilienmakler Heidelberg
Der Immoblienmakler für Heidelberg Mannheim und Karlsruhe
Wir verkaufen für Verkäufer zu 100% kostenfrei
Schnell, zuverlässig und kompetent
>

Walk Me Through Your Resume: Quick Tip for Investment Banking Interviews



In this lesson, you’ll get a quick and easy-to-implement, but still very effective.
By http://breakingintowallstreet.com/ „Financial Modeling Training And Career Resources For Aspiring Investment Bankers“
You’ll also get tips on how to improve your resume / CV walk-through in investment banking, private equity, and other finance interviews.

Your resume walk-through is how you answer the „Tell me about yourself“ or „Walk me through your resume“ or „Why are you here today?“ question when you walk into an interview and first introduce yourself.

This is IMPORTANT because it’s y our first impression, and interviewers often decide your status within the first 5 minutes of the interview.

Come across well, and you can answer other questions poorly but still receive a job offer or move onto the next round; come across poorly, and you won’t move to the next round no matter how great your Excel skills are.

We recommend this outline for your resume walk-through:

1. The Beginning – Where you went to school, where you started out working, your family background, etc.

2. The Spark – What, specifically, made you interested in finance initially? A person? An event? Your parents day trading or running a business? A professor? An internship?

3. Growing Interest – How did you develop this interest via classes, activities, further internships or jobs, and your networking and self-study efforts?

4. The Future / Why You’re Here Today – What’s your future goal (advising / investing in companies?) and how will working at this firm allow you to contribute TO that firm while also achieving your long-term goals?

THE PROBLEM:

Often, the last part – the „Future“ / „Why You’re Here Today“ segment is BORING and what you say sounds identical to everyone else’s statement.

„I want to become a trusted adviser to companies.“

„I want to invest in companies in XX sector.“

THE SOLUTION:

Link it back to the FIRST PART of your story – either your Beginning or Spark – to make it more memorable and attention-grabbing.

It works in movies (see: Inception and The Usual Suspects), and it works in interviews, too!

Example 1: You’re in a private equity interview, and your Spark is how you helped a private tech company raise funds; you saw additional expansion opportunities via partnerships and other deals, but in investment banking you just advise on one deal and that’s it… so you started looking into PE in more detail.

Instead of just saying, „I want to combine my interest in tech with my background in finance and invest in tech companies in the future,“ say:

„So I’m here today because of that original situation with the private company that sparked my interest in the industry – I want to get more opportunities like that, where I can help improve businesses over the long-term via partnerships, acquisitions, and operational changes that you only get to implement in private equity. And in the future, I want to be an investor in the tech sector, and your firm is the best place for that because… [Insert the rest of your reasons here]“

Example 2: You’re in an investment banking interview, and your Spark was working at a non-profit that merged with another non-profit one summer, after which you started taking more finance classes and learning more about the industry.

You have a background in public policy, and your long-term plan is to advise in the Project Finance / Public Finance sectors.

Instead of just saying that for the last part of your story, you could say:

„I want to advise organizations that may not be as ‘savvy’ about finance, like the merged non-profit I was at a few years ago – and become a trusted adviser to those types of public/private organizations. Your firm is the ideal place to do that because of [And insert references to other deals or clients they’ve advised here].“

Kostenlose Immobilienbewertung


source

Immobilienmakler Heidelberg

Makler Heidelberg

Immobilienmakler Heidelberg
Der Immoblienmakler für Heidelberg Mannheim und Karlsruhe
Wir verkaufen für Verkäufer zu 100% kostenfrei
Schnell, zuverlässig und kompetent
>