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!!
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?
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. 😂
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.
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....
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!
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?
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 ?
![19 Excel Shortcuts you NEED to use more [with FREE PDF 📃]](http://i.ytimg.com/vi/Q8fghk3DQxY/mqdefault.jpg)
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!!
You are welcome @tomchidwick. I am glad you enjoyed this.
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?
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. 😂
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.
Great points on CTRLA @meniporat3527
I always forget the last one (opens up formula dialog with CTRL A)
Chandoo - I’ve been on your mailing lists etc for a decade or more and love this transition to your super groomed look! ;)
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....
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!
@tomchidwick Thank you!
Really, How awesome is this ...
Thanks 😊 Chandoo..for sharing this magnificent shortcuts to improve work productivity 👍
Just excellent I'm upgrading myself with your videos.. amazing work , transferring knowledge ..... ❤❤❤
Shift+Ctrl+V is Super Hero of the Super Hit video! #KeepRocking #Chandu
Incredibly helpful. Thanks, Chandoo!!
Please sir post end to end power bi projects for resume advanced level since your teaching is so clear and simple
Daily wait for chndoo sir videos .. love from India.❤
This was awesome! Thanks Chandoo
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?
Thank you chando for an awesome tips and tricks❤
Thanks for video and nice to see you back in new Avataar...
Thank you for knowledge sharing sir
Thalaiva on the background is a nice touch
Apart from the content, your t-shirt is incredible! Spiderman is the best 🕸
1) to select an entire column, simply click the column's letter.
2) to select an entire row, simply click the row's number.
These shortcuts already learned from from beginning 😊, I need help on formatting chart 📊 need text inside the charts 📊
Thanks, Chandoo ❤ awesome- Chris from Adelaide, Australia
Thanks for watching!
Brilliant, thank you so much for this, and so many of your other fantastic videos!
Glad you like them!
At last waiting for video from you thank you
5.29 - Superstarrrrrrrrrrrr
Nice new look bro. Thanks for the video.
I like the new look with the beard
There are 347 excel shortcuts?
Then we need shortcuts to the shortcuts.
Superb. Thank you!!!
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 ?
Instead of adding blank cell to data to transform text to numbers, you can directly multiply numbers with 1 and can get number format.
For that you need a cell with number 1. My technique works without any extra items on the page.
Hi. In the bonus calculator find out one column . drag it to another column. how to drag it, kindly reply.
Chandoo how do we practice these excel 365 functions?
❤ great
12:08 Really 💥
Very good information sir
Hi guys....can anyone please tell me that what are the things have to learn in Excel for data analytics
Sir In the MS Excel Ctrl+Shift+0 is not working how to solve it . Pls Tell me
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
how does this alt+e,s,t work because everytime when press alt +e it shows ē
@Chandoo, i wanted to purchase your excel school learning course but it's too costly for me, can we do something about that😢
Save up bro
Finally, you're back
Amazing👍👍
Ausum ❤
Paste special shortcut is ctrl+Alt+V
helpful ..
super
ctrl + shift + V is not working for me 😢
Ctrl, alt, v, v
Excel excels 😊
I suck at remembering shortcuts. If only there was a better way. 😎
Don't memorize. Instead just use Excel regularly and you will build a personalized list of shortcuts over a few months.
CTRL+SHIFT+V is not working.
Alt E S T 👍
What happened to your face