analyze data

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Analyze Data

Analyze Data

resolvedResolved · Low Priority · Version 365

Alejandro has attended:
Excel Advanced course
Excel Intermediate course

Analyze Data

What is the purpose of the analyze data button?

RE: Analyze Data

Hi Alejandro,

Thank you for your question to the forum

The Analyse Data button is useful for generating Pivot Tables on the fly based on key observations from the source data ie. it recommends pre-made Pivot Tables to insert plus it also spots key outliers that don't fit a general pattern within the data

To utilise this feature, select a cell within a transactional dataset, click the Analyse Data button and insert any suggested Pivot Table

Hope this helps

Kind regards
Martin


 

Excel tip:

Separate the year from a date

To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1)

View all Excel hints and tips


Server loaded in 0.98 secs.