How To – Tutorial – Top 10 Excel Hacks, Tips and Tricks

How To – Tutorial – Top 10 Excel Hacks, Tips and Tricks

Want to negotiate the best term sheet? http://www.captablecourse.com

In this video I show my top 10 hacks for getting better at excel. Some are very basic, others are a little more advanced. Here they are in order:

1. Using the + Sign instead of =
2. Navigating with ctrl and shift
3. Using Alt to navigate without the mouse
4. How to select all the cells at once
5. How to Use assumptions in your model (avoid hardcoding)
6. How to Lock cells, rows and columns using F4
7. How to insert rows and multiple rows using hot keys
8. How vlookup works and how to make it dynamic
9. How dates work in excel and how to use them
10. How to use If statements and embedding an if within an if

Thanks! Please like and subscribe!

Leave a Reply

Close Menu