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

vba excel - pivot table

Forum home » Delegate support and help forum » Microsoft Excel Training and help » vba excel - Pivot table

vba excel - Pivot table

ResolvedVersion Standard

Chris has attended:
Excel Advanced course
Excel Intermediate course

Pivot table

how do i create a pivot table?

RE: pivot table

Hi Chris,
Thanks for using the forum.

A pivot table is created from a large amount of data which has been prepared as a list. To create a Pivot Table from this list you must first select a cell from within the list, go to the Menu command, Data and Select the ladder option Pivot Table and Pivot Chart Report. Follow the steps in the Wizard, when the Pivot Table blank appears, drag and drop your fields as required onto the four areas and your Pivot Table will appear.

Please note this information is covered in our Advanced Excel Course and takes approx 45 minutes to explain in full.

Regards

Tracy

 

Training courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

The dual nature of toolbar buttons

Many toolbar buttons are dual purpose, though the two purposes are often linked in some way. For example, Align Left aligns a cell's contents to the left of the cell. However, hold down Shift and press the Align Left button: Excel aligns the cell contents to the right.
You may respond: So what? Well, you can reduce the number of buttons on your toolbar to make your screen less cluttered and allow more room for, perhaps, some of your own commands. After all, what's the point of an Align Right button when Shift+Align Left does the same thing?

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.