Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data function, Macro, pivotal tables
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Data function, Macro, pivotal tables
Resolved · High Priority · Version 2007
Reply Fri 20 Mar 2009, 16:23Delegate Sihyun said...
Sihyun has attended:
Excel Advanced course
Powerpoint Introduction course
Project Intro Intermediate course
Data function, Macro, pivotal tables
details of instructions of the above subjects
For upcoming training course dates see: Pricing & availability
RE: 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
Mon 30 Mar 2009: Automatically marked as resolved.
|