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

learn excel in london - pivot table

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

learn excel in london - Pivot table

ResolvedVersion Standard

Chris has attended:
Excel Advanced course

Pivot table

Is there a quick way to adjust text fields, e.g. names of people who are displayed with spaces added. Having the spaces added does not allow the pivot table to run correctly.

RE: pivot table

Select the emplty field just above the row number 1 and before the column heading letter A and this selects all the rows and headings and adjust the fields

Excel tip:

Using Excel's MODE function

Use Excel's MODE function to display the most common value present in a particular range of cells.

The Mode function looks like this:

=MODE(cell range)

As an example, if 35 is the most commonly recurring number in a particular cell range, then the function will display 35.

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.