98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data function, Macro, pivotal tables
Data function, Macro, pivotal tables
Resolved · High Priority · Version 2007
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
Mon 23 Mar 2009, 09:54Trainer Simon said...
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.
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. |
Excel tip:Checking formulas with multiple operatorsWhen dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right: |
