10 things you thought Excel couldn't do, BUT it does them SO WELL

[@kingparc]

And a lot of people do not know that, perhaps, 80% of Power BI can be done directly in Excel !

[@preetipimpalnerkar2910]

Wow, I didn't know

[@tyronewalker5764]

Power Bi?🤔

[@denisvalente6844]

not exactly. Power Query is not Power BI

[@wayneirs6943]

What is Power B

[@imtwum]

What! This is crazy. I was shocked throughout the video, never seen such before in Excel!

[@chandoo_]

Oh well, that was the whole idea :)

[@swapnilvh]

Didn't knew you had a youtube channel.. I have learnt a lot from your posts on your website. Thanks.

[@chandoo_]

Welcome to this corner of my world Swapnil. I opened the channel soon after I started writing on Excel on my site (~2009).

[@georgeb603]

On the Partial Portion Prints, after selecting the data, you can go to Print, then on Settings you can change Print Active Sheets to Print Selection, thus now printing whatever the selection is. Thank you for all the tips and keep doing those extremely helpful videos.

[@chandoo_]

Thanks George. I love the "print selection" option 😀

[@elizabethsimpson6008]

I use Print Selection ALL THE TIME

[@JoannaJChow]

very good tips, thanks a lot for sharing!

[@chandoo_]

My pleasure!

[@ajaygaikwad5308]

Wow amazing 😀👍👌.. thank you

[@chandoo_]

Most welcome 😊

[@greeni01]

Genius! Thank you.

[@belkacemseffari7404]

this video is amazing ! thanks man Indians been solving modern problems for many years cheer to all Indians around the world

[@chandoo_]

Thanks Seffari... We all have the blessing and responsibility to help each other with our skills.

[@phanthibaovien]

This is amazing, especially for the Maps. It took me hours on Power Point and now you save me ages. Thank you Chandoo!!!!!!!!!!

[@chandoo_]

Glad I could help!

[@surenmoodley7744]

Thanks for this! Very, very useful. Another feature that many engineering and science students are not aware of is that Excel can also do matrix and vector calculations.

[@njg5942]

Good one Chandon

[@victoriagleason377]

I absoultely love your videos - they are so helpful.... THANK YOU

[@anandvanapalli7104]

Good explanation sir

[@lisaa6755]

sir, you are a wizard. fabulous.

[@chandoo_]

So nice of you

[@ExcelWithChris]

Picked up a few tricks AGAIN. Thanx!!!

[@chandoo_]

Thanks Chris :)

[@nirmalabolar1382]

Thanks and God bless for such an informative video, very helpful tips.

[@chandoo_]

Glad it was helpful!

[@wayneedmondson1065]

Hi Chandoo. An awesome list of EXCEL goodness! Another way to get to the data form is with the legacy keyboard: ALT, d, o. I use that often, saving space on my QAT and ribbon. Thanks for sharing :)) Thumbs up!!

[@chandoo_]

Great tip! Didn't know that. I will certainly promote it in my future vids :)

[@wayneedmondson1065]

@@chandoo_ Great! :))

[@arunrai2909]

WOW! Its just simply AWESOME!!!

[@chandoo_]

Thanks Arun...

[@MrSpuzzz]

I am a life long data analyst using excel, every day for functions more sophisticated than typical home or business users. I used to consider myself an excel expert but they add new features all the time, and Excel is never high enough on my training priority to truly keep up. So how much did this video surprise me? 1) time forecasting . Knew it. 2) ez form entry didn’t know it. 3) partial printing …. Knew it. 4) stock quotes data type - didn’t know it. 5) goal seek…knew it, (but doesn’t come to mind as often as should). 6) conditional emoji, knew it (didn’t know they could be graphed). 7). Extract numbers… didn’t know it (awesome!) 8) map chart …didn’t know it, pretty cool. 9) excel web - knew it but hate it. 10) more than a million rows … knew it. Not bad, you taught this old dog a few new tricks.

[@venkateshkulkarni1234]

Wonderful Chandoo... this is something new & excellent Tricks.... more power & love to you for such knowledge sharing .. Stay blessed.

[@vijayarjunwadkar]

Don't know how I missed this video, but thank God, I found it! Awesome tips Chandoo! Many of these are going to make my work so much more easy and productive! 😊👍❤

[@barrykelly4848]

Excellent Chandoo, keep these tips coming!

[@chandoo_]

Thanks Barry 😀 Do check out my top videos playlist for more - kzbin.info/www/bejne/rGPSf4qglpyAaKc

[@ApteryxRex]

Thanks Chandoo. Still working in 2013 - great to see what 365 has to offer.

[@chandoo_]

You are welcome Justin. You should be able to do most of these in 2013. Give them a try.

[@nageshwarasharma6373]

Respected sir, Super sir.

[@davidrhodes6016]

Oh my G*d!!! #7, Extracting numbers and text!! I have never seen this, ever. I knew the other 9 very well in fact but I had no clue about extracting text/numbers. This changes everything for me. Thanks so much Chandoo

[@chandoo_]

Flash Fill is my favourite too. You can use it for cleaning up dates, getting user names from emails etc too.

[@InsightfulJourney123]

Love this!👏

[@raziajeena9861]

Excellent tips thanks

[@chandoo_]

My pleasure!

[@prashanthk2214]

Appreciated your efforts in mentoring most of the people in pursuing there passion

[@chandoo_]

I feel blessed to do this. My mission is to help one million people every month.

[@ganeshrkamath8781]

Chandoo,Thanks a lot for this amazing lessons :)

[@chandoo_]

You are welcome Ganesh...

[@tarunparmar6375]

Thanks for sharing your knowledge...you genius

[@awesome_uk]

I like the idea of adding a bit of spice of Hrithik Roshan and Kareena Kapoor in between. As always, very informative and nice tricks to know, I didn't know about more than a million rows, to be honest. Thank you

[@chandoo_]

Thanks CG... Couldn't resist the clip.

[@arslan_TM]

Wah chandoo Bhai, behtreen.

[@chandoo_]

Shukriya...

[@BikashKumar-pz8hc]

Thank you again for great content

[@chandoo_]

My pleasure!

[@ahmedtareq5342]

Great as always

[@chandoo_]

Thank you Ahmed 😀

[@raghvendrasingh9721]

Excel = Chandoo I think that chandoo knows more excel than Microsoft 😂😂 You are awesome sir!!!😍❤

[@jmrth]

Yessss

[@hrsh3329]

no

[@gman8648]

Very nice and very helpful. Thank you.

[@chandoo_]

Glad it was helpful!

[@amandeepkainth9311]

Thanks so much, very useful 👍

[@girijavarma5271]

This is so good. Thank you sir you are teaching us some very interesting and informative things that my syllabi also do not cover. once again thank you sir dill se. 😊

[@chandoo_]

You are welcome Girija 😀

[@DrKesavMaganti]

Data analysis in mean, median, mode, variance, inter quartile, probability kuda (forecasting option unnattu, chesinattu) excel chestunda ?

[@charleswatson3351]

Love this guy!

[@bhanujinaidu]

Super video

[@mohammadjahedhossainbijoy6453]

Can Share the shown / used Excel as Example can tests by ourselves?????

[@mastermaster3843]

very helpful as usual.. thanx my man

[@chandoo_]

Glad to hear it!

[@taizoondean689]

Thank you Sir. It will be great help for all ius

[@chandoo_]

You are welcome Taizoon 😀

[@muratsahinel7302]

Thank you Chandoo, Happy Teachers Day !

[@kalyanaskumar]

Dear Chandoo... you are awesome 👌 any word is very less to appreciate you. My heartful wishes and greetings to you both.

[@chandoo_]

Thank you so much 😀

[@beckyholt]

Chandoo, I just want to add my thanks to all the others. I have a large project coming up and your presentation will be invaluable. I really enjoyed not just the information but your delivery and personality. I have subscribed, liked and am looking forward to your future tips and tricks videos. Do you have a tips and tricks video for dashboards in Excel? If not would you please consider adding one? Best regards

[@chandoo_]

Thanks Becky... Please refer to below resources for your dashboard work. Dashboard playlist - kzbin.info/www/bejne/poHTnIx4btp6b6M Dashboard information, examples and tips - chandoo.org/wp/excel-dashboards/

[@semperdiscendum7439]

You are awesome!! Thank you

[@chandoo_]

You are welcome Semper :)

[@RajeshBachuRadhika]

Thanks for the Video sir. This helps in larger way

[@chandoo_]

Happy to help

[@jmrth]

First like and viewed sir,

[@stevetheanalyst]

I love you......

[@chandoo_]

Woohoo... 😀😀😀

[@excelworx8712]

Mind blowing Chandoo. Yes I knew most of it! And caught you out lying about the coffee. You started with an empty cup anyway ;-)

[@chandoo_]

Thanks EW... Shh... don't tell anyone :)

[@dg.seymour855]

Thanks Chandoo.

[@chandoo_]

You are welcome DG.

[@briandelaney6354]

Brilliant....I only knew 2 of these tips 😀😀

[@chandoo_]

Woohoo... now you know the other 8 too 😎

[@tumo27]

This is really informative

[@chandoo_]

Thanks Tushar 😀

[@bijaytanty8434]

Thanks

[@teoxengineer]

Chandoo, it will be great if you make a tutorial video about advanced forecast data analysis in excel. I'm waiting for your support on this, my friend.

[@Canal_de_gedece]

I hope you can do it soon

[@chandoo_]

Thanks for the topic suggestion Emre. I have this in my notebook for 2022. I will be doing either a live stream masterclass or detailed video on forecasting in Excel. Meanwhile, do read this series of articles: chandoo.org/wp/trendlines-and-forecasting-in-excel/ chandoo.org/wp/trendlines-and-forecasting-in-excel-part-2/ chandoo.org/wp/trendlines-and-forecasting-in-excel-part-3/ All the best.

[@y2nsamy2nsam3]

Just subscribed... thanks

[@chandoo_]

Thank you and welcome Y2NSAM :)

[@frenan82]

Amazing video , thanks!

[@chandoo_]

You are welcome Fernando...

[@pgkannan]

Thanks for sharing

[@chandoo_]

My pleasure Kannan.

[@srikanththogarchedu]

Chandoo at the very Best!

[@chandoo_]

Thanks Srikanth 😀

[@poornimagupta3503]

Hi Chandoo. Could you please tell how did you use emojis in the graph at 9:22. It is really nice

[@chandoo_]

I will add a proper video tutorial on this soon. Meanwhile, here is the instruction. 1. Add emoji column next to your data (as shown in the video) 2. Make a line chart from your data 3. Add data labels on the line chart 4. Right click on data labels, go to format 5. From label options, choose "from cell" thing 6. Point to the emoji column 7. Set label to just show the value and nothing else. 💥boom. you are done.

[@poornimagupta3503]

@@chandoo_ Thank you . I have tried and it looks amazing

[@rekha3280]

Thank you so much for useful video 🤘🤘🤘🤘

[@chandoo_]

My pleasure 😊

[@Dany-ns6hg]

Good one Chandoo, Learned something new but how did you add emoji to graph as that was not demonstrated in this video. I tried but I am not able to get it on graph.

[@chandoo_]

I used "Data Labels" > Labels from Cells option. I will do a video on this feature soon.

[@Dany-ns6hg]

@@chandoo_ actually I used that option as well but didn't work.

[@profha2]

Great video brother. I feel like I know nothing whenn I watch your videos.... Have been using it for 20+ years now.... You should have a donation button on your channel

[@chandoo_]

Thanks Profha2. I do have a LIKE button. So hit it everytime you learn something.

[@SMCGPRA]

Super

[@rameshharidhasa7107]

Hi chandoo, this is amazig video. Once again I am telling that You are welcome 😍😍😍

[@chandoo_]

😀😀😀

[@alexanderkozlov1704]

Hey Chandoo, is forecasting option available at Mac version? I cant find it

[@TeeFat]

Thank you for these tips. How did you produce the emoji chart?

[@chandoo_]

I used the sales & date columns for the line chart. Then I set the labels. Finally, I went to label format options and chose "values from cells" option, pointed to Emoji column.

[@wayneirs6943]

Wow that's amazing .. definitely want to see more of your videos ..

[@chandoo_]

Welcome aboard Wayne... 😀

[@srinaga1975]

Hello Chandoo, all the tips are useful. Whether stocks ribbon will work in office 365 only ? I am not getting in 2013

[@chandoo_]

Hi Naga... Yes, this is a feature that is currently available in Office 365 (and probably in 2019 / 2021).

[@nayasachin]

Hi Chandoo!! As you know google sheets is widespread in all corporate offices now.. can you please tell us the difference between excel and sheets? Your views matters the most.. Please cover it.. and thanks for the wonderful work you do!,

[@chandoo_]

Thanks for the suggestion Sachin. I have a video on Google sheets vs. Excel coming up in new year. Watch out for it. Depending on the topic interest, I will add few more videos if needed.

[@GettingAlpha]

which excel version you are working on?

[@chandoo_]

I am using Excel 365 in these videos.

[@dgjanes917]

I personally hate the default forms in excel. A better option for data entry may be using Microsoft Lists and exporting. It will automatically create a synchronzied connection. There's also Microsoft Forms, but Lists is a much easier out of the box solution.

[@chandoo_]

I use it sparingly too, but in some cases this can be helpful. I will have to investigate more about the list forms option :)

[@YoungMcQueen]

I hope the BG music was a once in a lifetime experment

[@danp6101]

Hi Chandoo Thanks For the tips. I would like to know is there anyway to add a Click event or MouseMove event Dynamically when you add a Control Dynamically on a Userform in Excel. Like a Label, Button or a Textbox

[@chandoo_]

You can set up many mouse related events on the form controls. Just go to the VBA Editor, select the form, view code and then pick the control from top to add the events.

[@danp6101]

@@chandoo_ I'm sorry I guess I didn't word the question correctly. What I mean is when you run the form initialize event. You dynamically add a control. Lets say 5 labels. With me.control.add(form.label.1) Using a for loop. Now you want to add a mousemove event or a click event for each label At runtime.

[@chandoo_]

Hmm.. I haven't done something like this in 15 years so, my understanding is patchy. But you would need a class module and events can be attached at class level. That way, when you create an object of the class, the event is automatically bound to it. This page might help - www.mrexcel.com/board/threads/vba-mousemove-event-for-dynamic-userform-controls-labels.979332/

[@HikeStory-1]

Am actually using excel 2016 and when I want to add that emoji my excel hangs after i click windows and dot is it only in 360 it works?? And i couldn't get the disc in market can I get it online??

[@JoseAntonioMorato]

I notice that you are no longer making the file used in the video available for download. 🙁

[@chandoo_]

I do have files on most videos. For the 10 tips style videos, the files are rather tricky to make (because I often use 2-3 files to make the demos). I will add some links to relevant articles / videos later to the description.

[@Canal_de_gedece]

Excelent

[@sursunny76]

Mastaruuu.. I am not able to get the emojis in the chart.. Did I do anything wrong. Help cheyyarooo....

[@miqbal7032]

Use of VBA and Macros in advance excel

[@MrSpuzzz]

Bleh…..obviously vba makes excel incredibly flexible but there are limits to what average users can and should endure. Most vba is for advanced customization and to get really good at it requires more training and practice than most business users have interest or even authority to dive into (this is why we have IT departments…specialization). Let the business user brain to focus on business. Us IT geeks will focus on forms and methods and application development.

[@masternecrushne]

thank you for this nice video. Is there a way to add new icons to the Ribbon?

[@chandoo_]

What do you mean by "new icons" to ribbon?

[@masternecrushne]

@@chandoo_ symbols. When I am adding new shortcuts or macros....

[@chandoo_]

You can use the "Rename" option and from there select one of the icons. There are only a few set ones available in Excel. Adding new ones requires extra VBA customization I guess.

[@bdeepakkishore5872]

ok just know I try to apply emojis in excel 2016 but when applying emojis in if condition then it suddenly not respond

[@johosephatcopp3339]

I like the Emoji idea, but I when I press the windows button on my laptop, my windows application opens, where I have to search for something. I don't get the menu you are showing. I am using Windows 10 if that makes any difference. How would I substitute emojis with something else like arrows or something?

[@chandoo_]

You need to press both Windows & . keys together. Just like you press CTRL+C Once on the Emoji keypad, use the "symbol" option to see arrows etc.

[@susantakumar8711]

Sir can you upload full power query vedio

[@chandoo_]

I did. See here please - kzbin.info/www/bejne/hpqpcpSVn8-Ue6s

[@susantakumar8711]

@@chandoo_ already I have seen this class sir . In this vedio only 4 formulas there

[@chandoo_]

You may join my online classes. I cover Power Query with more examples in both Excel School & Power BI Play Date. Links: chandoo.org/wp/excel-school-program/ chandoo.org/wp/resources/power-bi-play-date/

[@venkateshmech5691]

My excel file size reaches 7 MB , it was too slow in my PC, How can I overcome this issue, because I have to update it for 4 more months.

[@agape13]

🏆

[@bossof95]

Hi but iam unable to add Forms to Home tab like you did

[@chandoo_]

You need to first make a GROUP and then add the command.

[@bossof95]

@@chandoo_ Thank you

[@bckzilla]

Awesome! I don't have a "Data type" option in my data-tab, but even so, all the other tips were great.

[@chandoo_]

Thank you. Datatypes are introduced recently, so they should appear whenever you upgrade to new version of Excel / 365.

[@mohebulahbarakzai2525]

how to calculate the sales for the month only for fridays

[@chandoo_]

You can use SUM & FILTER to do this. Example: =SUM(FILTER(data[sales], WEEKDAY(data[sales date])=6)) will add up all sales where sales date is on Friday.

[@otisiawosley9547]

Can Excel 2013 do all these?

[@chandoo_]

Most of them yes... See this list for more: 0:26 - Timeseries Forecasting - Excel 2016 + 1:58 - One click Data Entry forms - Excel 2007 + 4:08 - Printing Partial Portions - Excel 2003 + 5:02 - Live Stock / BTC quotes in Excel - Excel 365 6:46 - Reversing a formula - Excel 2003 + 8:30 - EMOJI 😀😂🙄 in Excel - Most Excel on Windows 8+ 9:44 - Extr4ct Numb3rs from mixed data - Excel 2013+ 10:57 - Maps in Excel 🗺 - Excel 2016 + 11:51 - Excel on the Web 🌐 - Excel Online / 365 13:17 - More than 1,000,000 rows in Excel - Excel 2013 + Power Pivot

[@yasincomps2056]

Desperately waiting for excel web or android to integrate macros to it

[@theaccidentaltask1660]

PDF to editable word Free 4 indian language?? Tutorial of any process

[@ExcelWithChris]

Love the Bollywood insert. My x-wife and I are BIG Bollywood fans.

[@chandoo_]

Nothing like a good Bollywood film on a lazy evening.

[@arpitbaslas336]

04:14 : Hritik knows chandoo and his Chacha Chachi s 🤣🤣

[@chandoo_]

After all he works in RAW, so I expect him to know EVERYTHING 🤣

[@iji_k]

Lol I thought the video will be about animation and games and replacing PowerPoint with Excel 😅

[@iji_k]

1,4,5,7,8,9,10 - I am never required to use them and I find this lack of need as unbelievably sad and ridiculous. 2. One click data entry forms Did this evolve in some way over the years? When I tried it some 20 years ago it easily classified as the most unsatisfactory part of Excel. 3. Printing partial portion I like Set Print Area more than Print Selection. I’m a control freak 😂 6. Emoji That’s spicy lol I think I’ll put a huge one next to “the pivot needs refresh”

[@chandoo_]

That is sad indeed. May be you can use them in personal / volunteer spaces? I like the HUGE red light (would be fun if Excel allows animated Emoji so we can have it glowing) next to "needs refresh"

[@alphaindian2847]

I donot know a single one 😀😀

[@chandoo_]

And now you know all 10 😎

[@Mr.Potato23]

Excel on the web doesn't have advanced features.

[@tizme2311]

Was looking forward to the video content, but could not comprehend with your accent and the awful background music, pity!

[@chandoo_]

Thanks for letting me know. I suggest finding another teacher as I won't change my accent.