Forum home » Delegate support and help forum » Microsoft Excel Training and help » Creating percentages

Creating percentages

ResolvedVersion 2010

Tue 12 May 2020, 16:49 Delegate Gavin said...

Gavin has attended:
Excel Intermediate course

Creating percentages

i am trying to create a sum with the result as a percentage, please could you help?

Tue 12 May 2020, 18:10 Edited on Tue 12 May 2020, 18:12 Trainer Jens said...

RE: creating percentages

Hi Gavin,

Thank you for the forum question.

I need more details please.

A percentage of what.

Do you have a column with values and want for each value to have a percentage of the column total?

Or do you have a total of expenses and want to calculate the expenses percentage of the income?

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Use Paint Brush to Format More than one Cell

To copy a format to many cells or ranges

1. Select the cell with the format that you want to copy

2. Double-click on the paint brush

When you move to the cell where you want to paste the format you will notice that a paint brush follows the cursor.

Paste the format to all the cells or ranges you need to format.

When finished go back to the paint brush on the tool bar and single click on it to deactivate the function.

View all Excel hints and tips

Creating percentages

Creating percentages

RE: creating percentages

Excel articles

Excel tip:

Use Paint Brush to Format More than one Cell