One of the most common tasks that people perform, while adding data to a spreadsheet, is to analyze it. But did you know that Microsoft Excel has a built-in function specifically for this? It's called Analyzing Data and it can help you see trends, patterns, rankings and more.
Renamed Analyze Data from a previous feature called Ideas. It is enabled for Microsoft subscribers 365 in Windows, Mac and the web.
Open Analyze data in Excel
Assuming you have some data ready that you would like to analyze, you can open the tool quite easily. Select a spreadsheet, diríjase a la pestaña Inicio y haga clic en “Analizar datos” hacia el lado derecho de la cinta.
This will open up a nifty task pane on the right side with images, options and other alternatives to analyze your data.
Analyze data options
Now, you are one step ahead of valuable data analysis in Excel. These are the alternatives you have to use the tool.
Ask a question
Starting from the top of the Analyze Data task pane, you can start with a natural language question and you will see a couple of ideas just below the question box that they can contribute.
Depending on the type of data you are using, you can enter things like, “Cuántas camisas se vendieron en enero”, “¿Cuáles son las ventas totales de zapatos y pantalones?” O “Total de chaquetas excepto diciembre”.
Along with the ideas above, you can also see suggestions by clicking on the question box. This provides a drop-down list of recommended questions. You will also see recent questions you have asked for quick re-examination if you wish..
The answers to your questions or the results of the suggestions you choose are displayed directly below.
Select your fields of interest
Below the question area of the task panel there is a link to Which fields are you most interested in?? If you want to limit the data you are analyzing, you can do it by clicking here.
Later you will see the fields for your data and their summarized values. Use the checkboxes on the left side to choose the fields you want to analyze. The values on the right are auto-populated into categories for No Value, Sum and Average. If you need to adjust one, can do it.
Click on “To update” Confirmed email address.
You can later review the data analysis results for the fields you selected.
View the scan results
The rest of the Analyze Data task pane is packed with various types of visual items based on your specific data.. You might see things like a bar chart where certain fields are highlighted, a table comparing two items, a pie chart with totals or a column chart showing the frequency of an item.
You will only see some images, but if you scroll to the bottom of the sidebar, you should see how many additional results there are. Click on “Mostrar todos los resultados X” para ver las imágenes restantes.
While giving you quick and easy ways to analyze your data, these results also give you tools. In the lower left of one, you can click to insert a pivot table, a dynamic chart or a graph.
RELATED: How to use pivot tables to analyze Excel data
This will display that item directly in a copy of your spreadsheet in a new tab. These sheets will be called Suggestion 1, Suggestion 2, etc.
So, this not only saves you from having to manually create these items yourself, it also does not disturb your current sheet or the data it contains.
Making changes to your data or sheet
If you make changes to your spreadsheet with Analyze data open, the task pane will not update automatically. Simplemente cierre el panel de tareas usando la X en la parte de arriba derecha y posteriormente haga clic en “Analizar datos” en la cinta de la pestaña Inicio para volver a abrirlo.
Note: After closing and reopening the Analyze Data task pane, recent questions you have asked will not be displayed in the drop down list.
Get a boost from Microsoft by analyzing your data in Excel. This feature doesn't just show you quick patterns and summaries, it also helps you create tools to use in your spreadsheet.
RELATED: How to use the “quick scan” Excel to visualize data
setTimeout(function(){
!function(f,b,e,v,n,t,s)
{if(f.fbq)return;n=f.fbq=function(){n.callMethod?
n.callMethod.apply(n,arguments):n.queue.push(arguments)};
if(!f._fbq)f._fbq = n;n.push=n;n.loaded=!0;n.version=’2.0′;
n.queue=[];t=b.createElement(e);t.async=!0;
t.src=v;s=b.getElementsByTagName(e)[0];
s.parentNode.insertBefore(t,s) } (window, document,’script’,
‘https://connect.facebook.net/en_US/fbevents.js’);
fbq(‘init’, ‘335401813750447’);
fbq(‘track’, ‘PageView’);
},3000);
