The Excel Function that You Wish You Knew 6 Months Ago

Playing off the, "I wish I knew this 10 years ago" or "When I was a kid" and adapting it to junior analysts or really anyone that is in excel a lot.

This can be a function of any significance whether it is knowing there is a spell check shortcut or just how to use a pivot table.

Try to keep it short and simple so that other monkeys can try it out.

Comments (8)

Apr 20, 2018

Pretty industry specific but using solver to fit oil&gas type curves to offset well production data

Best Response
Apr 20, 2018

Ctrl + Alt + Left Arrow has saved my job many times.

    • 3
Apr 20, 2018

you dog

heister:

Look at all these wannabe richies hating on an expensive salad.

Apr 20, 2018

respect

    • 1
Apr 20, 2018

if you've ever had someone mess with your files in a shared drive....right click the file....restore previous version

Learn More

Side-by-side comparison of top modeling training courses + exclusive discount through WSO here.

Apr 20, 2018

F4

Apr 20, 2018

Switched to Google sheets. No regrets

    • 2
Apr 20, 2018
Comment
    • 1