Analyze Data in Excel

This video explains how to use the Analyze Data tool in Microsoft Excel. Analyze data. The tutor starts off by selecting a small data set and then clicks the Analyze data button on the ribbon. The tool returns several options including Pivot tables and charts. In the second part of the video the tutor selects a larger data set and runs the analyze data tool again. This time several Pivot table and Pivot chart options appear as suggestions. The tutor mentions that if the suggestions are no good the user can type a question to see if the suggestion returned is useful. This is a Microsoft Excel tutorial covering, Analyze data, Pivot tables, Pivot charts and charts.

Leave a Reply

You must be logged in to post a comment.


“I studied with Steve when we completed our CiPD CTP together. During the course I found Steve to be very personable and also very professional.  Steve was first on my list of suppliers. Steve was very competitively priced and very accommodating.”

Simon Snowdon
European Training Manager at HP Enterprise Services

“Steve’s background in IT training clearly provided him with great organisational and managerial skills which he put to good use at Second Chance Enterprises. His ability to see the long term strategy as well as manage the day to day management is one of his biggest strengths.”

Chriss Graham
Project Coordinator at Daisy Group

“Steve delivered a number of Microsoft Office Training Sessions to a range of employees across Newcastle College. The service provided by Steve is second to none. I have no hesitations in recommending him to other employers.”

Christine Jackman
Learning Manager(North) - Winner of Training Programme of the Year NECCA

“The course was really thorough and Steve was very knowledgeable and explained things very well. I’ve not used Microsoft Project before but now I feel very confident that I’ll be able to use it for what I need to do in my job”.

Craig Forster
Estimator, John F Hunt Regeneration Ltd