Data function, Macro, pivotal tables

Hi Sihyun,

Thank you for your question.

Here is a brief overview of the topics mentioned:

1. The Data function - Create a critieria table by copying the headings from your data list, define the range of cells that makes up your data list and define the field you want summarised or averaged.

2. Pivot Tables - Open your data list and choose Insert Pivot Table. Select all the data list including the headings and choose where you want to place the table. Then choose your Page, Row, Column and data fields.

3. Macros - Navigate to the Developer tab and choose Record Macro. Name the macro and choose the location to save it in.

I hope this answers your question.

Regards

Simon