learn excel in london - pivot table

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

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

learn excel in london - Pivot table

resolvedResolved · Low Priority · Version 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:

Creating a range of monthly payments as text

You could use a formula to create a range of payment ie. payment amount for x% to y% rate with fixed terms and principle.

The text that would be "between Xamount and Yamount".

Here is how to do it.

1 Use the PMT function to get your monthly payments figure or whatever frequency of payments that you choose he start range.

See PMT under Excel Help

2. Nest these in the ROUND function to round decimals see ROUND under Excel Help


3. Concatenate this using "&" and concatenate " to " and concatenate "Between ".

4. Concatenate the above to PMT function for the end range

ie.

="Between "&ROUND((PMT1),decimal places)&" and "&ROUND((PMT2),decimal places)

View all Excel hints and tips


Server loaded in 0.08 secs.