Summary
Keywords
Full Transcript
#shortcuts time. Here is a list of 19 Excel shortcuts that are my absolute favourite. If you use Excel for data analysis work, then you must know these. ๐The shortcuts & timestamps โฑ ============================ 0:00 - CTRL T - to create a table 1:28 - CTRL Arrow keys โฌโฌโกโฌ - navigation 2:06 - SHIFT CTROL Arrow keys - Selection 2:33 - CTRL A or CTRL * - Select all 2:51 - F2 - Edit a cell 3:17 - CTRL Enter - Put same value in multiple cells 3:53 - CTRL SHIFT 4 - Apply currency formatting 4:16 - CTRL SHIFT 3 - Format dates in d-mmm-yy 4:31 - F4 - Repeat last action 5:14 - CTRL SHIFT L - Filter on / off 5:51 - CTRL 1 - Format selected thing 7:16 - CTRL E - Flash fill 7:57 - CTRL ; - Current date 8:35 - ALT Enter - New line in a cell 9:08 - CTRL D - Copy down 9:48 - ALT Down arrow โฌ - In-cell popup 10:47 - CTRL DRAG - to copy selected item(s) 11:27 - WIN . - Emoji keypad in Excel! 12:18 - CTRL F1 - Collapse / expand Ribbon 12:39 - ALT - Show ribbon shortcuts 13:26 - CTRL - (bonus) Delete cells 13:55 - CTRL + (bonus) Add cells ~~~ ๐Keyboard Shortcuts Poster for you ๐ ================================= Get it from https://chandoo.org/wp/free-keyboard-shortcuts-poster/ โ โ โ More shortcuts & top Excel tips videos ======================================== 10 Excel shortcuts you need to learn - https://youtu.be/ykP-agYOtC4 10 Data cleaning tips & tricks - https://youtu.be/SNVjndgWBlw 10 AMAZING Copy Paste tricks - https://youtu.be/uQoRef0L5Yw 10 Excel formatting tricks - https://youtu.be/2pn47abZCWU 10 AWESOME things you can do in Excel without formulas - https://youtu.be/W1QhTQCasb4 ๐ Need to learn Excelโ ==================== Binge on my FREE Beginner Excel Course playlist - https://www.youtube.com/watch?v=L3-uVawPLKc&list=PLmejDGrsgFyCZ4YC5s8mgdQztj7zt5to5 Or Read up the Excel Basics page - https://chandoo.org/wp/excel-basics/ Have a beautiful day โค๐ผ๐
