Many cool tricks. Thanks!! 3:00 Ctrl + E = to flash fill 4:28 Ctrl + T = convert to table 6:22 Ctrl + Shift + L = to remove or put back filters 7:00 highlight lists -> Conditional formatting -> Highlight Cells Rules -> Duplicate Values 10:03 Ctrl + Q = to show Quick Analysis 13:50 Data -> Forecast Sheet 15:57 Table Design -> Insert Slicer 16:45 Properties -> Don’t move or size with cells
Hello I have a huge doubt iam going to buy a laptop so can any one suggest me which windows and which is good purchas for all the works like doing excel learning java python sql etc online classes ,games , movies,songs with y5 etcc......
Thanks a lot sir. I appreciate you and your content of excel because many big institutes in India is unable to provide such a clarity and quality of content after Charging couple of lacks or sometimes more which you provide for free. I am also one of them who has gotten stuck in these types of Institutes.
hello Chandoo hope you and family are well. Congrats on Microsoft excel very well deserved you are the clearest speaker on Excel I have listened to and I'm an old LOTUS 123 user :) I am deep into budgeting time on excel some things never change !
ha ha ha ... this is the sweetest example of cheat-sheets I have seen. "No formulas" but we cheat Excel to create formulas for us :D Awesome as ever, @chandoo !!
Thanks Sirji ... I am definitely impressed and feel motivated to think out of the box as what you have done with your Excel ... Your explanation is too good to understand ... thanks again
Thankyou Sir for such an educational video. The problem which I am facing is that few of the options which you have done is not happening in my excel. I dont know the reason why like...Ctrl+E is not flash filling, auto initial filling and few others. Please help me in this...may be few options are not switched on or activated to get the required result.
Hi Amit. I think you are using a different version of Excel. You need Excel 2013 for Flash Fill and 2016 or above for some of the others demoed. May be time for upgrade?
On converting data into a table, first 90 rows are not selected in the table and the rest of the rows (total rows are 387) are shown as a table. I am not able to figure out why?
Now you are about to become a REAL Kiwi citizen, Dear Chandoo. As always, I told my students to subscribe to your "Awesome" Newsletter. If you see a bulk arrival of subscriptions from Turkey on your executive dashboard, that must be due to my lovely students. This was yet another "awesome" video making viewers become simply smarter in Excel. So, I assigned it as an Ad-Hoc Task on the Blackboard course website. Kindest regards to that corner of the Mother Earth. :-)
Is there a shortcut way for running total in Mac. Ctrl+Q doesn't work for quick analysis tool. I tried adding Analysis toolkit but I am not able to calculate the running total. Any suggestions?
Hmm, not sure if Mac Excel has Quick Analysis available. Do you see the QA button when you select some data in Mac? If so, Excel should display the shortcut in tooltip.
hello chandoo....in the 4th tab after you did your analysis using the charts how do you remove it from the sheet? i want to make the sheet come back to its original status.
Use Power Query to link up the files. Whenever you want the master to update, just hit refresh. See my detailed tutorial on Power Query for more on this. - ua-cam.com/video/PiFAa_jjaEI/v-deo.html or read the article here - chandoo.org/wp/combine-excel-files-using-power-query/
Used to follow your website... it had some incredibly smart functions you created that were just magical... Sadly, the last time I checked, they were not available for download... but they were awesome..
@@chandoo_ thanks... I have never seen your incredible functions in any ‘Excel Guru’ books.. to me you were the real and only guru..how did you learn all those tricks... ?? I worked in finance so they were just incredible ... piece of art really... all the success to you in the future
As usual, this was awesome. It feels wonderful to be your subscriber. Also a small request sir, please consider my question on your earlier Power Query video as well, that would be of great help.
Hi Satya... Thanks for watching this. I create videos on Excel + Power BI eco system only. I suggest watching the Power Query intro video. It is Excel + Power BI's version of SQL for data management. See it here - ua-cam.com/video/PiFAa_jjaEI/v-deo.html
You are welcome Tham. You can add one-off pictures by using Insert > Picture option. If you want something dynamic, you can use picture links. I will make a video about this technique next week. Meanwhile, have a read of this. chandoo.org/wp/how-to-use-picture-links/
Great....can you please give me a tip for "extracting specific text from the cell where its place is randomly located in colomn cells (I am aware about "Search" function which I use normally)
Thanks Chandoo, Always amazed at what excel and the engineers can do. Question on how i would go about analyzing data in columns with patterns like EEO EOE EEE OOE or 1 1, 1 10, 1 20, 1 30, 10 20 . Forecasting or pattern recognition feature or formula. Thank you.
I am using Excel 365, but many ideas in this video should work even in Excel 2013. For Excel 2007, refer to this video - ua-cam.com/video/g_tQ4D7wCL0/v-deo.html
Have you done a video recommending top buttons to add to your Quick Access Toolbar? I notice you have several buttons that I don't recognize. Great content as usual!
Great idea. I haven't talked about QAT customization in my videos yet. I will add this. Meanwhile check this page too - chandoo.org/wp/quick-access-bar-poll/
Many cool tricks. Thanks!!
3:00 Ctrl + E = to flash fill
4:28 Ctrl + T = convert to table
6:22 Ctrl + Shift + L = to remove or put back filters
7:00 highlight lists -> Conditional formatting -> Highlight Cells Rules -> Duplicate Values
10:03 Ctrl + Q = to show Quick Analysis
13:50 Data -> Forecast Sheet
15:57 Table Design -> Insert Slicer 16:45 Properties -> Don’t move or size with cells
Nice work! Thanks for the timestamps... :)
Good ji
Thanks for saving my time.
Hello I have a huge doubt iam going to buy a laptop so can any one suggest me which windows and which is good purchas for all the works like doing excel learning java python sql etc online classes ,games , movies,songs with y5 etcc......
My co-workers think I’m some kind of an Excel magician. If they only knew how much knowledge I’ve gained from you.
Thanks George... make them magicians too :)
Thanks a lot sir. I appreciate you and your content of excel because many big institutes in India is unable to provide such a clarity and quality of content after Charging couple of lacks or sometimes more which you provide for free. I am also one of them who has gotten stuck in these types of Institutes.
Only discovered this one today!!! Best tip ever is Cut and Paste Table column totals!!!
This is really amazing. I didn't know Excel had these options.
Glad it was helpful!
Amazing. Loved that video...Greetings from Ireland 🇮🇪
100k views and going strong. Thanks people :)
You are excel genious
Thanks 🙏 Sir , God Bless You 💕
Wow this is incredible.. It will save most of my time. Thank you sir..
Wow! Amazed by what Excel can do! Thank you for sharing this!!!
You're very welcome!
hello Chandoo hope you and family are well. Congrats on Microsoft excel very well deserved you are the clearest speaker on Excel I have listened to and I'm an old LOTUS 123 user :) I am deep into budgeting time on excel some things never change !
I randomly watched your One video, and Haven't stopped since then.
Thanks for staying curious and learning Sagar. More power to you.
Woohoo.. 1000 likes. Thanks everyone for learning and loving this video.
Excel will surprise with a new trick every day.... thanks for sharing this 👍
You bet!
So Knowledgeable. following ur videos. Thank so much.
I know most of them but you are a true teacher i would say.
Thank you Nitin. I love teaching and sharing.
Chandoo bhai. you are great. Love from Pakistan
Thanks Mudasir... 😊
ha ha ha ... this is the sweetest example of cheat-sheets I have seen. "No formulas" but we cheat Excel to create formulas for us :D Awesome as ever, @chandoo !!
🤫
Amazing information on Excel. Thanks a ton for this video. God bless.
Spell amazing... C-h-a-n-d-o-o... 💯🤗
Thank you 😊
Running total is just the best. We hare running this formula manually for years 2-3 times a day. And now - one click
15:30 Says it all.
Excel can’t function without formulae.
Nice collections & saves time. Thanks
Glad it was helpful!
Thanks Chandoo, for the interesting presentation with simple flow of examples. Its been very useful.
You're most welcome
Simply you are WoW Chandoo!!!
Excellent instructor.
Thanks David...
Thanks Sirji ... I am definitely impressed and feel motivated to think out of the box as what you have done with your Excel ... Your explanation is too good to understand ... thanks again
It's my pleasure
nice tutorial. good job. thanks
THANK YOU! This is greatly appreciated 👍🏾
You are so welcome!
Superb and just awesome, Thank you Very Much ...
You are welcome Jaimin.
Thankyou Sir for such an educational video. The problem which I am facing is that few of the options which you have done is not happening in my excel. I dont know the reason why like...Ctrl+E is not flash filling, auto initial filling and few others. Please help me in this...may be few options are not switched on or activated to get the required result.
Hi Amit. I think you are using a different version of Excel. You need Excel 2013 for Flash Fill and 2016 or above for some of the others demoed. May be time for upgrade?
Hello chandoo.....which version of excel are you using please?
On converting data into a table, first 90 rows are not selected in the table and the rest of the rows (total rows are 387) are shown as a table. I am not able to figure out why?
Huge thanks for sharing your knowledge. It is really helpful.
Glad it was helpful!
Thanks for giving the value
You just made my day awesome
My pleasure!!
Thank you very much sir 🙏🙏🙏🙏🙏
Now you are about to become a REAL Kiwi citizen, Dear Chandoo. As always, I told my students to subscribe to your "Awesome" Newsletter. If you see a bulk arrival of subscriptions from Turkey on your executive dashboard, that must be due to my lovely students. This was yet another "awesome" video making viewers become simply smarter in Excel. So, I assigned it as an Ad-Hoc Task on the Blackboard course website. Kindest regards to that corner of the Mother Earth. :-)
Thank you so much for the love and recommendation. Big big hello to your students. :)
Very helpful. Thank you
You're welcome!
Is there a shortcut way for running total in Mac. Ctrl+Q doesn't work for quick analysis tool. I tried adding Analysis toolkit but I am not able to calculate the running total. Any suggestions?
Hmm, not sure if Mac Excel has Quick Analysis available. Do you see the QA button when you select some data in Mac? If so, Excel should display the shortcut in tooltip.
hello chandoo....in the 4th tab after you did your analysis using the charts how do you remove it from the sheet? i want to make the sheet come back to its original status.
You can right click on the sheet and remove it.
To clear all filters you can also do Alt A + C
Awesome shortcut.
Alt S D A
Hi
What is the easiest way to update the master excel in one conputer file with source files in different computers ?
Use Power Query to link up the files. Whenever you want the master to update, just hit refresh. See my detailed tutorial on Power Query for more on this. - ua-cam.com/video/PiFAa_jjaEI/v-deo.html or read the article here - chandoo.org/wp/combine-excel-files-using-power-query/
Truly awesome!
thanks for your valued video for us
Helpful and productive tricks 👍
Thanks a lot
I leant new thing i.e. forecasting. Which is awesome, thanks for the video
You're welcome 😊
It's really awesome that you've managed to colab with Microsoft! Inspiring
:)
Excellent information. I wish there was little more sound. Little more louder please. Many Thanks
Thank Sonia. I have improved my audio process vastly since this went live. Check out newer videos too.
Used to follow your website... it had some incredibly smart functions you created that were just magical... Sadly, the last time I checked, they were not available for download... but they were awesome..
I haven't removed any pages or articles. If you remember the usecases, I suggest searching my site or email me and I can point you in right direction.
@@chandoo_ thanks... I have never seen your incredible functions in any ‘Excel Guru’ books.. to me you were the real and only guru..how did you learn all those tricks... ?? I worked in finance so they were just incredible ... piece of art really... all the success to you in the future
As usual, this was awesome. It feels wonderful to be your subscriber.
Also a small request sir, please consider my question on your earlier Power Query video as well, that would be of great help.
Very very useful.
These are Great, Chandoo! Thanks.
Glad you like them!
Thank you Chandoo, wish I subscribe you before. Thank you is not enough for you.
Thank u so much ...really helpful
Most welcome!
Hello. Useful information, clear explanation, nice English. Thank you.
Thank you. I am glad you enjoyed this.
Explaining of the way very nice and it's very helpful.
Chandoo garu:if any SQL video's plz give link.
Hi Satya... Thanks for watching this. I create videos on Excel + Power BI eco system only. I suggest watching the Power Query intro video. It is Excel + Power BI's version of SQL for data management. See it here - ua-cam.com/video/PiFAa_jjaEI/v-deo.html
Very nice tips. Thanks for sharing
My pleasure 😊
Hello Chando we appriciate your lectures.
Thanks for liking
Hi...thanks for the easy to understand & well-made vdo. Need yr advise on how to attach photo into a cell within excel?
You are welcome Tham. You can add one-off pictures by using Insert > Picture option. If you want something dynamic, you can use picture links. I will make a video about this technique next week. Meanwhile, have a read of this.
chandoo.org/wp/how-to-use-picture-links/
Amazing! Very useful
Glad to hear that!
Thank you. Helpful
Glad it was helpful!
Great....can you please give me a tip for "extracting specific text from the cell where its place is randomly located in colomn cells (I am aware about "Search" function which I use normally)
I would use SEARCH / FIND() functions along with MID. I showed an example of this in my recent video here - ua-cam.com/video/thvE8Eg-Pqg/v-deo.html
@@chandoo_ thanks a lot....delighted to see your response....great
Excellent sir...nice👌
Thanks and welcome
Sir very nice video you explain very nice idea to use without formula for like mis report thank you sir
Cool video bro! Thanks.
Glad you liked it!
Thanks for this really cool content 🙏
Chandoo Sir, this is Extraordinarily Marvelous
Thanks RiNa...
Excellent.Big thank you to you..
Super informative! Thanks 😊
Glad it was helpful!
Awesome tricks , so helpful! Thanks
Glad you liked it!
Thanks Chandoo, Always amazed at what excel and the engineers can do. Question on how i would go about analyzing data in columns with patterns like EEO EOE EEE OOE
or 1 1, 1 10, 1 20, 1 30, 10 20 . Forecasting or pattern recognition feature or formula. Thank you.
INTERESTING VIDEO!!!
Glad you think so!
Thanks! Useful
I am completely amazed!
Thank you... 😍
which version of excel you worked upon I could not do the same in excel 2007
I am using Excel 365, but many ideas in this video should work even in Excel 2013.
For Excel 2007, refer to this video - ua-cam.com/video/g_tQ4D7wCL0/v-deo.html
thanks dude
Very interesting! Thx!
Glad you liked it!
Very useful tips. Thank you
So nice of you
Awesome teaching sir.
I am glad you liked this. Also check out top 10 formulas video - ua-cam.com/video/P7w6JeNS_SA/v-deo.html
how we can get excel 365 ? i have built in 2019 office in my laptop
Excellent Sir.
Does it work on any Excel or only 365?
Most of them should work on any recent version of Excel.
Hi, JI Ctrl+E is not accessed in Excel
Hey Chandoo, you are amazing, thanks for this informative video
Thank you so much 🙂
Great set of tips. Thanks
Glad it was helpful!
how to enable the Table design option?
Very good - thank you
Glad you enjoyed it
thank you for the great tips and ideas, really brilliant
You're so welcome!
Thanks! Sir, your videos are always excellent and speechless.
Not speechless but outspoken. He might leave you speechless if you want to say he has made an impression on you. ;-)
love your explanations
Thanks! 😃
Have you done a video recommending top buttons to add to your Quick Access Toolbar? I notice you have several buttons that I don't recognize. Great content as usual!
Great idea. I haven't talked about QAT customization in my videos yet. I will add this. Meanwhile check this page too - chandoo.org/wp/quick-access-bar-poll/
I need some help with % in when sample 5days work =100% colum show red = out and green - I’m Please advise
Use conditional formatting for this. See this page for an intro - chandoo.org/wp/excel-conditional-formatting-basics/
I don't know why some of the options not available for me. Can i know why ? Somebody help me
I am using Excel 365 here. If you are using a very old version of Excel, then everything will look different.
Thanks Chandoo , really I like your videos 👍
So nice of you
Sir , I want to learn Excel from the beginning. As I have no idea about it .
Thanks so much for the nice tutorials. For the tip 3, is it possible to compare more than 2 tables?
It will get tricky with 3 or more tables. I suggest watching this video for the concept - ua-cam.com/video/kfeFcyDrcvQ/v-deo.html
Please, can someone explain to me how he got the Rate link
You mean the exchange rate? It is just typed in.
Everything ok except Idea tool is not working in Excel 2016 installation. No help found yet.
IDEAS is only available in Excel 365. Download a trial version if you want to give it a try.
Thank you Sir.
Thank's a lot for wonderful information !!!!!!!
Always welcome
You are amazing, thanks for this informative video
Glad it was helpful!
Great job
How can we do flash fill in liberoffice calc?
I am not sure if such a feature is in other office apps.
@@chandoo_ thank you Sir