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

learn excel - pivot table

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

learn excel - Pivot table

ResolvedVersion Standard

Brenda has attended:
Excel Intermediate course
Excel Advanced course

Pivot table

How do I create a pivot table?

RE: Pivot table

Put your cursor into the data you want to go into your pivot table.
Select DATA> Pivot table. Then follow the wizard
Drag the relevant fields to the PIVOT TABLE. Adjust as necessary

Excel tip:

COUNT function vs COUNTA function

The COUNTA function works in the same way as the COUNT function, except that it will count cells that contain text (labels) and also cells that contain numbers (values). The COUNT function will only count cells that contain numbers. Blank cells are not counted by either the COUNT or the COUNTA function.

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.