excel course tate modern - projections

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel course tate modern - Projections

excel course tate modern - Projections

resolvedResolved · Low Priority · Version Standard

Projections

I have a list of products with a sales projection for each product, I want to adjust the projections by a fixed percentage, either upwards or downwards for the entire list?

RE: Projections

Answer to post: This could be achieved by following these steps:
1. Enter the factor you want used to increase or decrease the numbers in your list in a cell. (eg: If you wanted to decrease the numbers in your list by 20% enter 80%, to increase your projections enter 120% to raise the value by 20%).
2. With your increase/decrease factor as the active cell, click the Toolbar Copy button (or choose Edit, Copy - CTRL+C)
3. Highlight the numbers in your list that you wish to manipulate, and choose Edit, Paste Special.
4. In the Paste section select Values; in the Operation section, select Multiply, Click OK.
The numbers in your list will be increased or decreased by the amount you specified.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


Server loaded in 0.09 secs.