Basic Data Analysis

[balusm]

Hi Everyone

Please can you help me with how to approach a relatively basic data analysis in most efficient way.

Data looks like pretty much like that, with a lot more rows of data but no more columns, i.e., only age, avc provider, fund type columns, but with a couple of hunder more rows with other values.

What I want to achieve are outputs like average fund value for each fund, total fund value for each fund and, more imporantly something linke this:

(these output tables are not related to the data sample above)

I am sure there is a smart way to do it without spending too much time on it. Pivot tables? If so, can you give me some guide how? I have just started learning about them so it is very new to me.

I will appreaciate you help.

Many thanks

balusm

 

[balusm]

Hi

Any ideas?

Thanks

 

[circledchicken]

Hi,

Yes, PivotTables would be a good way to do this. Here are some resources that should help:

• Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis) - YouTube
• Excel Pivot Table -- Dynamic Data Source
• Overview of PivotTable and PivotChart reports - Excel - Office.com
• Using Pivot Tables and Pivot Charts in Microsoft Excel
• Excel Pivot Table -- Grouping Data