From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Get data analysis suggestions with the Analyze Data (formerly Ideas) tool

Get data analysis suggestions with the Analyze Data (formerly Ideas) tool - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Get data analysis suggestions with the Analyze Data (formerly Ideas) tool

“

- [Instructor] There's a new feature in Excel 2 called Analyze Data, but actually it's a renaming 3 of a previous feature called Ideas. 4 And you'll see this button on the home tab, 5 far right, analyze data. 6 It looks for patterns in your data, as it suggests here 7 that it can use to create intelligent, 8 personalized suggestions. 9 So imagine we're about to work with this data here. 10 It's in table format. That's not a prerequisite. 11 We've got some ideas, we've got some questions. 12 A few of them are listed over here in column L. 13 And depending upon our knowledge level of Excel, 14 maybe we know pivot tables a little bit. 15 Maybe we're familiar with some 16 of the more sophisticated formulas, 17 we can get to some of those answers maybe, 18 are we familiar with the average if function 19 or the average IFS function? 20 Maybe, maybe not, but we might get some ideas simply 21 by using this feature. 22…

Contents