How can I use Ideas for Excel?
Excel has a pretty high learning curve because anybody can master its basic features pretty fast. Things get a little bit tricky when you get to formulas, right? And you have to become a little Excel master to know them by heart. In the Ideas tool, you can use Natural Language Queries which is self-explanatory. You are able to ask complicated information like data questions with formulas, charts, or pivot tables in a very easy and common way. To put it even more lightly, it’s like the Google search in Office.
Using the Ideas in Excel
Microsoft developers explain the exact process in the release notes:
You can save time and narrow down your Ideas by selecting only the fields you want to see. When you choose fields and how to summarize them, Ideas analyze just that data – speeding up the process and presenting fewer, more targeted suggestions. In this example, you might only want to see the sum of sales by year. Or you can ask Ideas to display average sales by year. It’s very simple to do that: We hope that this little guide will help you understand how to use Ideas in Excel.
SPONSORED
Name *
Email *
Commenting as . Not you?
Save information for future comments
Comment
Δ
