Excel AI with Analyze Data Tool. PivotTable, Pivot Chart & X-Y Scatter Charts Excel Magic Trick 1732

Learn how to:
1. (00:00) Introduction
2. (00:36) PivotTable and Pivot Charts in just one click!
3. (02:50) X Y Scatter Chart has NEVER been better!
4. (04:06) Summary, Closing and Video Links

[excelisfun]

There have been a number of comments of users who say this feature only works on small data sets. I hope Microsoft fixes this soon, because this limitation makes the tool almost useless : (

[cbaide]

I always enjoy watching Mike's videos, but most importantly, I always learn something new as well.

[johng]

Thanks in a million! Very well explained. This is the nth time that I am watching this again. Great content. Awesome. I couldn't find this explanation--simply put anywhere else. “Great teachers are hard to find”. Grade: A++ 💥

[utubeAgape]

Thanks Mike! I can see this being useful in a meeting or on a TEAMS call, while discussing a spreadsheet, sharing your screen and going for a quick visual with Analyze Data - I will check it out!

[shiffamohammed]

Thank you Mike, you and your excel data analysis teachings are real blessing to us. Great update as excel advances and everything moves on. Thanks again Mike.

[spilledgraphics]

For rapid-"punk analytics"-data analysis-tool seems good ! but gotta watch out for the results, data validation is key. Awesome video Mike ! #GoTeam 😁🤙

[johnborg]

I knew about it, but never used it. Thanks Mike, a great video as always. : ) : )

[jimfitch]

Love Analyze Data (saw it on Ribbon & explored it once or twice), but I have a high need to trust the underlying data & am still learning the plumbing to ETL & summarize/display data. After viewing your tutorial, I’ll probably use it more to generate suggestion(s) close to desired result, dig into the plumbing, then customize to desired result. Thanks for time-saving tip, Mike.

[MalinaC]

I had a long break in watching your videos, but I'm back nów! Thumbs UP!

[chrism]

Pretty cool Mike. Could be a nice time saver in many instances too!

[Bforzajuve]

Hi Mike. It is an amazing tool that can save a lot of time. I will definitely try it out.

Thank you for all these videos. Without your videos my skills would not be even close to the current level.

[SyedMuzammilMahasanShahi]

Thanks Mike for another EXCELlent video.

[GeertDelmulle]

Excelisfun Newsflash! And BAM: super quick, super slick!
Should check them out myself, not a habit, but it should be.
And of course: ALWAYS understand what you’re doing... even if you’re not doing it yourself.
Thanks for the video, Mike! :-)

[darrylmorgan]

Boom!Analyze Data Tool Is Pretty Slick...Thank You Mike :)

[vijayarjunwadkar]

Very nice video Mike! Got to know, how to access Analyze Data from the Pivot Table interface, which was new to me! Thank you! 😊👍

[wayneedmondson]

Hi Mike. Thanks for the look at Analyze Data. Looks pretty cool and quick when it gets it right like for the scatter / regression line chart. Maybe a good learning tool for some to get used to how to get started. As you said, generally don't want to give up the manual control of building from scratch. Nice option though! Thanks for demonstrating this feature :)) Thumbs up!!

[darlenegant]

This is going to help me in my class! Thank you

[ramkrishna]

Analyze data in Excel is going to be a game-changer in the near future. Tableau has started rolling out the same feature called 'Einstein Analytics' which is readily available to everyone. The major drawback with Excel is that we need to have an O365 account to access the new features!

[jcherra]

Always something new to learn. Thanks a lot. JC

[maheshvinchhi]

Amazing Tools Sirji.. Thanks For Sharing...


But this become amazing Just Only because YOU tought us every topic which is suggested in "AI"..
So we can understand the logic and how it comes otherwise we can't do minor change in it as per our requirement...

Again Thank You Sirji for Everything you tought us...🙏