Learning hundreds Shortcuts is intimating, but learning 18 shortcuts isn't a very difficult task. It is my conviction that if you start to use and master these 18 shortcuts in Excel, your speed of using Excel will go up atleast 3x times.
1. Insert new sheet in Excel )) Shift + F11
2. Go to previous / next sheet )) Ctrl + PageUp / Ctrl + PageDown
3. Go to a point where the next cell is blank / also select )) Ctrl +
Arrow / Ctrl + Shift + Arrow
4. Format cells dialog box open )) Ctrl + 1
5. Change Date format )) Ctrl + Shift + 3
6. Select all data / full sheet )) Ctrl + A
7. Select full column / full row )) Ctrl + Space / Shift + Space
8. Insert / Delete row or column )) Ctrl + + / Ctrl + -
9. Insert today's date )) Ctrl + ;
10. Apply All borders )) Alt - H - B - A
11. Turn on Filter )) Ctrl + Shift + L
12. Open dropdown in filter )) Alt + Down Arrow
13. Sort in ascending / descending order )) Alt - A - S - A / Alt - A - S - D
14. Sort box open )) Alt - A - S - S
15. Find / Replace )) Ctrl + F / Ctrl + H
16. Paste special )) Ctrl + Alt + V
17. Write in same cell but in next line )) Alt + Enter
18. Repeat last action )) F4
_______________
After this video, to learn in-depth about Pivot tables and charts, Enroll for an Online course conducted by me on Master Business Reporting with Pivot tables and charts in Excel
Also, as you are a YouTube Viewer / Subscriber,
we would like to give out a special discount just for you -
[ Ссылка ]
__________________
SUBSCRIBE NOW!
[ Ссылка ]
Click this link to learn more awesome functions in Excel
[ Ссылка ]
Click this link to learn how to manage your personal finance using Excel
[ Ссылка ]
Logo Music - "Blonde" by Nctrnm
Ещё видео!