I have no ideas what to do with my Excel data!!

Oct 22, 2020 | Excel Hints and Tips

With the volume of data we now get bombarded with on a day to day basis it’s not always easy to decide what to do with it all. If you have no idea how to get started why not let Excel provide some ideas for you.

The ideas button is available in Microsoft Excel if you have a Microsoft 365 subscription only.

Available on the Home tab, all you do is click on the Ideas button and, hey presto, Excel comes up with a range of suggestions which will vary depending on the data you have.

Recommendations of ideas

These ideas that will be suggested could include the following.

  • Pivot tables where the data is summarized based on specific grouped data
  • Pivot charts where summarised data is created in a pivot table and a chart is then created from this
  • Charts which can provide useful results without pivoting depending on the data you have
  • Totals of numerical fields
  • Sorting the data
  • Top or bottom entries

 Image of ideas pane

Free flow text box for ideas

In addition to these there is also a box where you can ask a question about your data in natural language.  So you can literally ask anything you like.

Image of asking questions from the ideas pane

So there really is no longer any excuse for not getting the results you need out of the data you are storing.  You don’t even need to know how to create pivot tables or charts, know how to sort or calculate.  By choosing an option from the ideas pane it does it for you with the flexibility of typing in any question of your own if the suggestions don’t cover what you need.  Pretty brilliant, I think!



Want to learn more about Excel? Then email lara@laramellortraining.co.uk to discuss how I can help or have a look at the Excel Courses I run.