#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 ❤🌼😀