Скачать или смотреть Learn Top10 Excel Keyboard Shortcuts|Quick Excel Hacks| Excel Function|On Demand Excel Shortcut Keys

Welcome Back to Zacs Hub and this is your Host - Solomon Zaccheus.
Learn Top 10 Excel Keyboard Shortcuts.
Make yourself pro and genius and reduce dependency on mouse and make the most of the keyboard and Shine like an Ace in Excel.
For MacBook users, I will be covering the excel keyboard short-keys in another tutorial.

Please find the Scripted Text for the Top 10 Excel Keyboard Shortcuts.

1. Ctrl + T = Converts Data into Table
2. Ctrl + D = To fill the entire column with the contents of the upper cell
3. Ctrl+Shift+L= Enable the Filter and Disable the filter
4. Ctrl + Shift +8= Select any cell in the data, it highlight every cell contain data
5. Ctrl + 1 = Allows to formal cell by opening format cell dialog box
6. Ctrl+Alt+V = Open the paste special Dialog Box
7. F2 = Allows you edit inside the cell
8. Alt + = Sign = Sums the total at the bottom calculating all the sub totals from above
9.Ctrl + E(Flash Fill) = Flash Fill automatically fills your data when it senses a pattern
10. Time and Date Stamp :-
For Date - Ctrl+;
For time- Ctrl + Shift+: It place the current date and time as per default date and time format.


Please do write and comment if you know of some more trick then share so I can create content and put it on the channel for people to learn.

Please do Subscribe my Channel and Share this video to many as possible for better reach to develop people with the right skills needed for the Current Industry.
Do follow my link below of Facebook page for other areas of Interest.

  / acespace778