19 Excel Shortcuts you NEED to use more [with FREE PDF 📃]
#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-...
✅✅✅ More shortcuts & top Excel tips videos
========================================
10 Excel shortcuts you need to learn - • The *ONLY* 10 Excel keyboard shortcut...
10 Data cleaning tips & tricks - • Data cleaning in Excel - 10 tricks *P...
10 AMAZING Copy Paste tricks - • 10 *SURPRISING* Copy Paste Secrets fo...
10 Excel formatting tricks - • 10 Excel formatting tricks *ONLY* exp...
10 AWESOME things you can do in Excel without formulas - • 10 awesome things you can do in Excel...
👉 Need to learn Excel❓
====================
Binge on my FREE Beginner Excel Course playlist - • What is Excel and How to use it?
Or Read up the Excel Basics page - https://chandoo.org/wp/excel-basics/
Have a beautiful day ❤🌼😀
Watch video 19 Excel Shortcuts you NEED to use more [with FREE PDF 📃] online without registration, duration hours minute second in high quality. This video was added by user Chandoo 31 August 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 128,901 once and liked it 5.8 thousand people.