Hi, this is Wayne again with a topic “The Excel Ideas Button”.
In this short excel video, i will show you the excel ideas button that you can use to quickly and easily generate beautiful visuals for your spreadsheets and excel ideas is available right now, i believe only in office 365 versions of excel that includes office 365 for windows, Mac and also online so here i have an excel workbook with a family income spreadsheet for a hypothetical family, and i have a 2020 spreadsheet with a lot of financial data and of course i could generate some visuals, some charts, etc. By selecting the data itself and going to insert and inserting charts of various kinds – and i can also use this tool here – the quick analysis button to investigate some visuals that i can add and if you want to learn more about both of those methods. Please see my other videos, but in this article i want to focus on excel ideas. If you want to use excel ideas, you don’t even have to select the data. All you do is open up a spreadsheet and then click on the home tab home ribbon at the right side. You should have ideas again. If you have office 365.
click the button you may need to be patient, so wait a little bit and it will bring up a list of ideas of visuals that you could add to your spreadsheet. It’S suggesting a pie chart about income sources. It’S also suggesting a pivot table that i might like income sources, an interesting, looking pivot, chart and notice that there are a total of six results.
So there are some results that are hidden. I could click show all results like. I just did and then browse down to see the remaining options, so i like this first pie, chart i’ll click insert chart and it adds it to the spreadsheet just off to the right and below the data.
In this case, if i zoom out a bit, you can see a little bit better where it put that pie chart. In my case, i also want the pivot table, so i’ll click insert pivot table in this case, because it is a pivot table, it didn’t add it to the spreadsheet itself, but rather it created a new spreadsheet in the workbook and it’s a pivot table about the Data in my family income spreadsheet, of course i could reorder the spreadsheets by clicking and dragging to place idea 1 next to the spreadsheet, where the idea came from now, of course, once you’ve added these ideas, whether they be charts, pivot tables, pivot, charts, etc, they are Editable, so i could click to adjust this pie chart, for example, and i could use the tools that are here to change the chart style to do some chart filters and i can click to add, chart elements and so much more. For example, selecting the chart there are some chart design options here at the top and format options. So these ideas they’re pre-made, predetermined using artificial intelligence, but i love that you can customize and make them more like what you exactly would want. Let’S now try excel ideas again, but with a much more complicated spreadsheet, i’m going to close the ideas panel and, as you can see, i’m now on the spreadsheet titled 2020.. This is a huge spreadsheet, with lots of data, so fortunately i don’t have to select the data to use excel ideas just be on the spreadsheet home tab, home, ribbon, click ideas and it generates a list of ideas you can see. The ideas generated in this case are quite different and the reason why is because the data is very different from that previous spreadsheet. In this case, i get a total of 36 idea results, so many many more to choose from some very interesting, powerful.
Looking charts this one talks about outliers this one found a correlation between two different pieces of information. This pivot chart highlights a pattern in the data, so this can be a great way to use artificial intelligence to identify trends, identify key information about your spreadsheet and also to add some beautiful, looking visuals that you can then customize once you’ve added them to the spreadsheet Or onto a new spreadsheet, in the same workbook, in this case, i’m just going to click insert chart what a beautiful addition to this spreadsheet thanks for watching. I hope you found this tutorial to be helpful. If you did please like follow and subscribe and when you do subscribe, click the bell so you’ll be notified.
Whenever i post another video, if you’d like to support my channel, become a supporter through my patreon account and you’ll see a link to that in the description below speaking of patreon, i want to give a quick shout out to my five dollar patreon supporters. Thank you. So much for your great support. .