I tried all 347 Excel Shortcuts, and here are the BEST ones you need to know

💥35 Excel Tricks PDF - chandoo.org/wp/wp-content/upl...
0:00 - Best Excel Shortcuts to get things done
0:33 - Shortcuts for Working with Data
3:18 - Shortcuts to Format the Data
5:32 - Shortcuts on Copy Pasting
9:40 - Shortcuts for writing formulas faster
12:55 - Shortcuts for making Charts
15:41 - The best trick!!!
📁 Sample file to practice - chandoo.org/wp/wp-content/upl...
~
More shortcuts?
Checkout these videos for more shortcuts and power tricks.
10 Excel tricks to impress my boss - • 10 things my boss stru...
50 Things you didn't know Excel can do - • 50 things you didn't k...
10 things my teammate is doing in Excel - • 10 things my teammate ...
I saw my boss do these 10 things in Excel! - • I saw my boss do these...
Data Cleaning with Excel - 10 Tricks - • Data Cleaning in Excel...
Excel Tips & Shortcuts PLAYLIST - • Excel Tips & Shortcuts
~
#excelshortcuts

[@tomchidwick]

I've been an Excel power user since 1995. While I knew (and use frequently!) most of these, I did learn a few new ones. The Copy -> Paste Special -> Add method of getting numeric text to actual number types AS A RANGE just rocked my world! That's a problem I've never been able to solve well within Excel, without using notepad or something else to help the conversion. Add to that the dynamic array vectored selection solution, and I'm fairly blown away. Great stuff. Well done Chandoo! Thanks for the awesome video!!

[@chandoo_]

You are welcome @tomchidwick. I am glad you enjoyed this.

[@subratkumarpurohit8686]

Converting text to number by "add". This is one of the most useful Technic.. I always found difficulties.. hope the issue sorted.. what about Google sheets.. is there any trick?

[@Oldschoolfille]

Really enjoyed the videos. I use almost all the shortcuts shown in the video and these are literally quite helpful! Some of the other shortcuts that I use are: -Like Shift+space is used to select a row, Ctrl+Space is used to select a column. -Ctrl - is used to delete a selected cell, row, column -Ctrl+shift = (i.e Ctrl + is used to add a cell, row, column -Ctrl R to drag the formula to right side, Ctrl D is for dragging downway -Ctrl + Pg Up and Ctrl + pg down to navigate different tabs in a sheet. It helps when you’re using keys more instead of mouse. I must say Ctrl + shift + V for pasting cells as values has been a hero for me lately. 😂

[@7sevens]

Chandoo - I’ve been on your mailing lists etc for a decade or more and love this transition to your super groomed look! ;)

[@chanduchax]

Incredibly helpful. Thanks, Chandoo!!

[@arbazahmad7177]

Really, How awesome is this ... Thanks 😊 Chandoo..for sharing this magnificent shortcuts to improve work productivity 👍

[@chrism9037]

This was awesome! Thanks Chandoo

[@ucatchrajesh]

Just excellent I'm upgrading myself with your videos.. amazing work , transferring knowledge ..... ❤❤❤

[@user-ur8ph9lj6f]

Please sir post end to end power bi projects for resume advanced level since your teaching is so clear and simple

[@abhilashn2993]

Thanks for video and nice to see you back in new Avataar...

[@meniporat3527]

some "insights" about the CTRL+A keyboard shortcut: 1. When the active cell is surrounded by empty cells - selects the entire worksheet 2. a. When the active cell is surrounded by cells containing data - selects the entire range of cells. 2. b. Repetition of Ctrl+A - selects the entire worksheet 3. a. When active cell is in a table - selects the entire table (only data, without headers) 3. b. Repetition of Ctrl+A - adds the summary row and headers to the selection 3.c. Repetition of Ctrl+A - selects the entire worksheet 4. When an object is selected (chart, shape) - selects all the objects of the worksheet 5. When typing a formula, pressing Ctrl+A after the first left parenthesis, displays the Function Arguments dialogue box.

[@chandoo_]

Great points on CTRLA @meniporat3527 I always forget the last one (opens up formula dialog with CTRL A)

[@junaidtahir9014]

Thank you chando for an awesome tips and tricks❤

[@kamleshrane5138]

Thank you for knowledge sharing sir

[@millerdane]

I like the new look with the beard

[@kandukurisravankumar5781]

Shift+Ctrl+V is Super Hero of the Super Hit video! #KeepRocking #Chandu

[@v_fiver]

Daily wait for chndoo sir videos .. love from India.❤

[@ivancortinas5427]

Superb. Thank you!!!

[@swayme67]

Brilliant, thank you so much for this, and so many of your other fantastic videos!

[@chandoo_]

Glad you like them!

[@samphoenix1623]

At last waiting for video from you thank you

[@rangerover5635]

This was totally awesome Chandoo!! Learned 2-3 new features that I didn't knew... like the dynamic array option was totally new and game changer for me!!! Just had a quick question regarding using the shift button to move a column in data.... Does that dynamically adjust formula or not, if those cells are linked??? One solution that I generally use for that was to cut the entire column and paste it to new column... That way the formula and everything remained fine....

[@tomchidwick]

FYI, the select-column, shift and drag technique he used is the same as Insert Cut Cells on the Home menu. Select source column/row, Ctrl + X, select target column/row, then Alt I E, or Ctrl + Shift + =. Everything (relative references, formatting) is preserved on the target/moved column. Very handy!

[@rangerover5635]

@tomchidwick Thank you!

[@UKJ28]

Nice new look bro. Thanks for the video.

[@rakeshsinghprs]

Thalaiva on the background is a nice touch

[@cbbcbb6803]

There are 347 excel shortcuts? Then we need shortcuts to the shortcuts.

[@huseyinburaktasci1638]

Apart from the content, your t-shirt is incredible! Spiderman is the best 🕸

[@yhharishadyar7843]

Very good information sir

[@ihgamingfun6295]

Amazing👍👍

[@lavaant8219]

Hi Chandoo Garu, Thank you for the covering the topics. I am a financial analyst i want to move data analytics role i learned power bi is it necessary to learn alteryx also?

[@lovableameer]

These shortcuts already learned from from beginning 😊, I need help on formatting chart 📊 need text inside the charts 📊

[@christinethompson6860]

Thanks, Chandoo ❤ awesome- Chris from Adelaide, Australia

[@chandoo_]

Thanks for watching!

[@khurramtea]

❤ great

[@nithins4240]

5.29 - Superstarrrrrrrrrrrr

[@rashs9901]

helpful ..

[@meniporat3527]

1) to select an entire column, simply click the column's letter. 2) to select an entire row, simply click the row's number.

[@swapnilkapadi5868]

Hi Chandoo, When I try to apply a Dynamic Array formula on a table it shows me a Spill error. Without a table, it worked fine. Is there a way we can use a Batch formula on a Table ?

[@yashshah_18]

Chandoo how do we practice these excel 365 functions?

[@ajithkumar4904]

Hi. In the bonus calculator find out one column . drag it to another column. how to drag it, kindly reply.

[@Jobin.Thomas]

12:08 Really 💥

[@VijayPawar-sz6gq]

Ausum ❤

[@lijikumarbalan6038]

super

[@mrbartuss1]

Finally, you're back

[@jeevan937]

Sir In the MS Excel Ctrl+Shift+0 is not working how to solve it . Pls Tell me

[@SanthoshKumar-qw8mx]

how does this alt+e,s,t work because everytime when press alt +e it shows ē

[@sindhuja1038]

Hi guys....can anyone please tell me that what are the things have to learn in Excel for data analytics

[@Pkhyber]

Instead of adding blank cell to data to transform text to numbers, you can directly multiply numbers with 1 and can get number format.

[@chandoo_]

For that you need a cell with number 1. My technique works without any extra items on the page.

[@vidyasworld26]

Excel excels 😊

[@ajayshivpuje3797]

Paste special shortcut is ctrl+Alt+V

[@AtulSingh-lu1kp]

@Chandoo, i wanted to purchase your excel school learning course but it's too costly for me, can we do something about that😢

[@Alpacastan21m]

Save up bro

[@vishalkumar-rl3rc]

ctrl + shift + V is not working for me 😢

[@shivanshshukla5883]

Ctrl, alt, v, v

[@mehulmandirwala2318]

Alt E S T 👍

[@excelrobot]

I suck at remembering shortcuts. If only there was a better way. 😎

[@chandoo_]

Don't memorize. Instead just use Excel regularly and you will build a personalized list of shortcuts over a few months.

[@meniporat3527]

CTRL+HOME - will NOT bring you to the "top left corner of your data" CTRL+HOME - will ALWAYS bring you to cell A1, no matter where your data starts

[@farazhussain4046]

CTRL+SHIFT+V is not working.

[@KamranKhanmba]

What happened to your face