50 Excel Keyboard Shortcuts You Must know
Excel Is Simple
50 Excel Keyboard Shortcuts you must know #excelkeybaordshortcuts #excelshortcuts #exceltips #excelformulasandfunctions
Download the spreadsheet with Shortcuts from this link: https://drive.google.com/file/d/1N9I5o4ELQO5emOyI5IOdPJJ8pyWLKGAd/view?usp=sharing
Video - Chapters 00:00 Introduction 00:07 ⌨ ① Copy and Paste 00:50 ⌨ ② Select the active cell(s) Row and Column 01:13 ⌨ ③ Hide and Unhide Rows of active cell(s) 01:40 ⌨ ④ Hide and Unhide Columns of active cell(s) 01:59 ⌨ ⑤ Move to end of your data or start of next data point 02:50 ⌨ ⑥ Open Format Dialogue Box 03:14 ⌨ ⑦ Insert Current Date 03:27 ⌨ ⑧ Insert current time 03:39 ⌨ ⑨ Auto sum a range 04:13 ⌨ ⑩ Replicate the above cell 04:39 ⌨ ⑪ Apply border to selection 05:13 ⌨ ⑫ Paste a cell/Range 05:45 ⌨ ⑬ Paste above cell as value 06:17 ⌨ ⑭ Paste above cell's function 07:00 ⌨ ⑮ Navigate Between Worksheets 07:22 ⌨ ⑯ Bold Italics and Underline 07:35 ⌨ ⑰ Expand and Collapse Ribbon 07:58 ⌨ ⑱ Select Non Adjacent Cells 08:17 ⌨ ⑲ Insert Line Break in a cell 08:42 ⌨ ⑳ Find and Replace 09:24 ⌨ ㉑ Hyperlink 09:32 ⌨ ㉒ Fill contents from the cell on the left of active cell 09:55 ⌨ ㉓ Strikethrough and Toggle 10:08 ⌨ ㉔ Apply time formatting :10:2 ⌨ ㉕ Apply comma formatting 10:48 ⌨ ㉖ Apply currency formatting 11:01 ⌨ ㉗ Apply Date formatting 11:27 ⌨ ㉘ Apply Percent formatting 12:17 ⌨ ㉙ Remove borders from selection 12:47 ⌨ ㉚ Go to a particular cell address 13:09 ⌨ ㉛ Print Preview 13:18 ⌨ ㉜ Edit a cell 13:54 ⌨ ㉝ Cancel an entry 14:25 ⌨ ㉞ Close Sheet 14:32 ⌨ ㉟ Undo and Redo 14:41 ⌨ ㊱ Toggle Auto-filter 15:08 ⌨ ㊲ Align cell to centre 15:26 ⌨ ㊳ Increase Font Size one Step 15:51 ⌨ ㊴ decrease Font Size one Step 16:11 ⌨ ㊵ Insert Rows and Columns 16:37 ⌨ ㊶ Delete Rows and columns 16:57 ⌨ ㊷ Group rows or columns 17:24 ⌨ ㊸ Ungroup rows or columns 17:49 ⌨ ㊹ Open Spell checker 17:58 ⌨ ㊺ Delete Comment 18:07 ⌨ ㊻ Display AutoComplete list 18:28 ⌨ ㊼ Toggle Absolute and relative reference in a function 18:59 ⌨ ㊽ Add an Indent in the cell 19:16 ⌨ ㊾ Repeat last Action 19:42 ⌨ ㊿ Display Paste Special Dialogue Box
------------------------
Welcome to Excel is Simple. A place where excel is taught in the dumbest possible way. You will find every type of excel tutorial; excel 2013 tutorial for beginners, excel 2010 tutorial for beginners, excel formulas and functions, excel pivot table tutorial, excel vlookup. Aptly this is one place which has all excel tutorial for beginners.
Subscribe to my channel at http://www.youtube.com/user/excelissimple?sub_confirmation=1
Want some focused playlists. Click here and lean ba
...
https://www.youtube.com/watch?v=v577SOxyacQ
61543038 Bytes