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

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!

[miteshshah]

Really helpful! Would love to learn more detailed tricks as well :)

[ZaidAnwarAhmedAl-Shehhi]

I think you need to consider beginners whenever you are doing these complicated assumptions and what not. Meaning, to slow it down a little and explain it bit by bit.

[prakashsathyapriya]

Actually it is very difficult to watch. Please zoom the area you are going to work sir that everyone can get a clear picture. Thank you

[mannases]

prolly should add a time mark on the description of the video

[xyth]

IS THERE ANYWAY TO AUTOMATE THE SYSTEM OF ADDING WEIGHT WHEN THE SPECIFIC KEYWORD ENTERED AND THE VALUE WILL BE ENTERED NEXT TO THAT ROW?

[matthewv]

Using plus will cause errors further down thenline

[rogercharlie]

Very small fonts. So much negative space. Difficult to see what's going on

[christinehyun]

Really unclear, blurry. Cannot see. Items mentioned sounded important n useful but could not see visuals.

[hankk]

Read my about page I can do your spreadsheet work for you in a timely manner

[aaron]

lol .. this is too basic .. it doesnt help much on operations