Suddenly, we all have Ideas in what to do with our Data in an Excel Spreadsheet. We think hard, waste a lot of time and put in general, a lot of effort on how to represent visually our Data in our Spreadsheet perfectly. Well we don’t have to worry anymore, because Excel 365 has had the exact thought on how to help us understand our Data through high-level visual summaries, trends and patterns. All we need to do is to simply click on a cell in a data range, or select the whole data range, and with the use of the Ideas command, Excel will analyze our data and return interesting values about it. If you want to learn more just continue reading the post below
In the image below, I have opened a Spreadsheet that contains data, where it is possible to use the Ideas command. I have selected the area needed, which contains the data needed for the Ideas command.
The Home tab of the ribbon must be activated where at the far right is located the Ideas area, where we select the Ideas command as shown below. The Idea command looks for patterns in our data that it can use to create intelligent and personalized suggestions.
Once the Ideas command is selected, the Ideas task pane appears at the right of our Spreadsheet as shown in the image below. The Ideas task pane appears showing us the different Graphical representations that it has created according to the Data that we had selected.
Once we have located on the Graphical representations or Chart in other words that it has created for us, at the bottom left corner of each Chart is located the command Insert Chart. Once we select the command Insert Chart, the Chart will be inserted in our Spreadsheet immediately as shown in the image below.
The Ideas command works much better with well organized data, that doesn’t contain any blank Rows or Columns. It also works better if the Data that we have in our Spreadsheet is formatted as an Excel Table. We should also make sure that we have good Headers for our Columns, where they should be in a single Row with non-blank labels for each Column. We should also avoid double Rows of Headers and Merged Cells.
Below you can check out the video describing the Ideas command in Microsoft Excel 365.
Don’t Forget To Subscribe To My YouTube Channel.