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

formating

ResolvedVersion 2007

Judy has attended:
Excel Introduction course

Formating

best way to projecting figures etc

RE: formating

Hello Judy,

Thank you for your post and welcome to the forum;

In answer to your question, there are a number of ways in which projections can be accomplished in Excel, probably one of the most useful is to use the Scenarios Manager, this will allow you to enter different options which will then compute different projections for you, to see the Scenario Manager you will go to the Menu command Tools>Scenarios and observe the options that you are presented with.

If you want a full run through of Scenarios it is covered in our Advanced Course.

I hope that has helped, best regards Pete

Excel tip:

Outlining - ungrouping rows or columns

Highlight want you want to ungroup and press ALT + SHIFT + right cursor arrow

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.