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

excel-xp-training - excel

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

excel-xp-training - Excel

ResolvedVersion Standard

Aziz has attended:
Excel Advanced course

Excel

How to do Privet table

RE: How to make a Pivot Table

Hi Aziz,

Thanks for your question.

There are a few steps to create a PIVOT TABLE:

    1. Click anywhere in the data table
    2. Select DATA menu > PivotTable & PivotChart Report
    3. Press NEXT and confirm the Data region
    4. Press NEXT again.
    5. Select the location of new Pivot Table
    6. Press FINISH


Regards,

Katie

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time




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.1 secs.