Перейти к содержимому

Advance Excel Full course class_12(Remove duplicate, Freeze Panes, Transpose, Shortcuts Keys)

Tech-Knowledge-Buddha

0:00 / 0:00

Advance Excel Full course class_12(Remove duplicate, Freeze Panes, Transpose, Shortcuts Keys)

32 просмотра · 2 недели назад
Tech-Knowledge-Buddha
34 подписчика
32 просмотра · 2 недели назад
We are going to learn about Remove duplicate, Freeze Panes, Transpose, Shortcuts Keys(Ctrl + N → New workbook, Ctrl + O → Open workbook, Ctrl + S → Save workbook, Ctrl + P → Print, Ctrl + Z → Undo, Ctrl + Y → Redo, Ctrl + X → Cut, Ctrl+Shift+Arrow Key, Ctrl+Shift+Page Up/Page Down-Move between sheet of excel, Ctrl + B → Bold, Ctrl + I → Italic, Ctrl + U → Underline, Ctrl + Shift + $ → Currency format, Ctrl + Shift + # → Date format, Ctrl + Space → Select entire column, Shift + Space → Select entire row, Ctrl + Shift + "+" → Insert row/column, Alt + H + O + I → Auto-fit column width, Ctrl+F2 → Edit the selected cell, Alt + = → AutoSum, fn + F4 → Repeat last action, Ctrl + Shift + L → Apply/remove filters, etc.....