BEST Excel Shortcuts for Investment Banking: 'F' Functions | Shortcut Sundays #1

On Shortcut Sundays, we'll be discussing the BEST Excel shortcuts for investment banking so we can optimize your work productivity and save time so you can go home ASAP! Today we'll be going over the 'F' functions that will be critical to your day-to-day

0:00 Mastering Excel Shortcuts
0:26 F2 = AUDIT
0:39 F2 + ESC demo in financial model
1:38 Why bankers HATE the F1 key
2:03 F4 = REPEAT task ~or~ "LOCK" cell in formula
2:23 F4 live demo
3:01 F7 = SPELLCHECK
3:33 F9 = REFRESH (esp. when model is not on automatic)
3:55 F12 = SAVE AS

How to Find Your ~DREAM~ JOB | 3 Key Steps to Land Your Dream Job

BEST WORK HABITS YOU NEED TO START PRACTICING | Post-Grad Success Series

Dating and Relationships in INVESTMENT BANKING | What it's like to date a banker...

I QUIT INVESTMENT BANKING:

INVESTMENT BANKING NETWORKING 101 | 5 Step Guide to Networking in IB

Dear 1st Year Analysts... (My Advice for Investment Banking Analysts)

HOW TO GET INVESTMENT BANKING RETURN OFFER | 8 Foolproof Steps to Secure A Full-Time Return Offer

DON'T GO INTO INVESTMENT BANKING! | 10 Reasons IB is NOT for you:

How I Became a TOP BUCKET Analyst | Investment Banking Bonuses

How to Be HEALTHY in INVESTMENT BANKING | Gaining the FIRST YEAR 15??:

10 BEST PRACTICES for Investment Banking Analysts | Investment Banking Excel Shortcuts:

6 Reasons I HATE Investment Banking in 6 Minutes | WORST PARTS ABOUT INVESTMENT BANKING:

INVESTMENT BANKING ANALYST DAY IN THE LIFE (aka 16 hour workdays):

WORKING 100+ HOURS A WEEK?? | Common MISCONCEPTIONS about Investment Banking:

INVESTMENT BANKING GROUP PLACEMENT | How to Get Into Your TOP GROUP:

NEVER HAVE I EVER | Investment Banking Edition:

TOP BUCKET TUESDAYS | INVESTMENT BANKING playlist:

The TRUTH about INVESTMENT BANKING playlist:

700+ GMAT PREP IN 2 WEEKS playlist:

Tags: investment banking explained, goldman sachs survey, investment banking culture, wolf of wall street, investment banking pay, investment banking bonus, investment banking compensation, investment banking salary, investment banking all nighter, why investment banking, investment banking skills, investment banking internship, wall street, investment banking exit opportunities, investment banking private equity, investment banking hours, how to get into investment banking, investment banking day in the life, investment banking analyst, investment banking hours, wall street, bulge bracket investment banking, how to get investment banking internship, investment banking analyst day in the life, never have i ever investment banking, breaking into wall street, investment banking interview prep, investment banking books, best finance books, mergersandinquisitions, wallstreetoasis, investment banking deals, wsj, monkey business, ib shortcuts, investment banking shortcuts, excel shortcuts, investment banking return offer, internship return offer, excel shortcuts for investment banking

[swaggyskye]

Hey! Good video - just wanted to know how you can hit the function keys on mac, do you have to click fn everytime before you hit them? :D