excel training courses - excel data

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - Excel Data

excel training courses - Excel Data

resolvedResolved · Low Priority · Version Standard

Daniel has attended:
Excel Intermediate course
Excel Advanced course

Excel Data

how do you do a pivot table?

RE: Excel Data

Hi Daniel,

1. Enter the data you require for the Pivot table generally in the format of a list.
2. Select any cell within that data range
3. Then click Data > Pivot Table and Chart Reports
4. Follow all the steps of the wizard
5. Drag the fields you want to see onto the pivot table from the field list.


Pivot tables can be a more efficient way to view data

Hope that helps if there is anything (more specific) let me know

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:

Conditional Formatting in Excel 2010

If you have lots of data in a spreadsheet, you may find that it is easier to read if you highlight some of the values. This is Conditional Formatting and here's how to use it:

1) Select the data you wish to apply the format to and click Conditional Formatting
2) A list of options will then appear, from this list, choose the format you wish to display e.g. find all cells with a value less than 0
3) Excel will then highlight all of these cells

To remove this: select the highlighted cells, click the drop down on the Conditional Formatting icon and select Clear Rules from selected cells.

View all Excel hints and tips


Server loaded in 0.09 secs.