What else can Excel do?

[babypink2807]

Hi

I have a spreadsheet that has two sets of figures for 2007 and 2008
split by month and by Sales Person. I now have a formula that
calculates the percentage increase or derease by accout which is great
(using the total for the year). But as I am not by any stretch of the
imagination an Excel User I was hoping someone would be able to tell
me what other things Excel could do with this information? I would
love to impress my boss!

Can it forecast on 2yrs figures, or can it say this sales person has
contributed x% to the overall sales figures.

Hope someone can help me here otherwise it will be just my increase
and decrease figures

Thanks

 

[scubadiver]

Excel is your oyster!

Have a look at the maths functions and, if you haven't already had a look,
add-in the 'Analysis Toolpak' (tools -> add-ins). Also look at doing a few
graphs that can show information easily.

Depends how much of a stats/maths person you are. What is your job?

 

[babypink2807]

Excel is your oyster!

Have a look at the maths functions and, if you haven't already had a look,
add-in the 'Analysis Toolpak' (tools -> add-ins). Also look at doing a few
graphs that can show information easily.

Depends how much of a stats/maths person you are. What is your job?









- Show quoted

I am as thick as two short planks really, and there is that much data
in the spreadsheet I am having difficulty cerating a blooming
chart...! I am not a maths type person at all which is why Excel is
my failing, even though when it works its brilliant but I do have to
ask for help most of the time ;-D

 

[scubadiver]

How is your data layed out?

I am as thick as two short planks really, and there is that much data
in the spreadsheet I am having difficulty cerating a blooming
chart...! I am not a maths type person at all which is why Excel is
my failing, even though when it works its brilliant but I do have to
ask for help most of the time ;-D

 

[babypink2807]

How is your data layed out?






- Show quoted text -

Like this

YE Code Company Name January February March Total in GBP Total Comp
Rep
2007 ACOL01 A COLD DISTRIBUTORS LTD £0.00 £0.00 £0.00 £668.00
£0.00 TW
2008 ACOL01 A COLD DISTRIBUTORS LTD £0.00 £0.00 £0.00 £0.00
£0.00 TW
2007 ABBL01 ABBLYN CONTRACTS £0.00 £1,106.60 £0.00 £3,423.56
£1,106.60 PH
2008 ABBL01 ABBLYN CONTRACTS £0.00 £6,211.07 -£641.40 £6,857.85
£5,569.67 PH
2007 ADAP01 ADAPTABLE SHOP DISPLAY £0.00 £523.50 £128.90 £5,240.99
£652.40 TJ
2008 ADAP01 ADAPTABLE SHOP DISPLAY £0.00 -£0.03 £436.96 £5,162.71
£436.94 TJ

 

[scubadiver]

I am an access person so I would set it out like this:

Code Company Year Month Cost
ACOL01 A COLD DISTRIBUTORS LTD 2007 Jan £0.00
ACOL01 A COLD DISTRIBUTORS LTD 2007 Feb £0.00
ACOL01 A COLD DISTRIBUTORS LTD 2007 Mar £0.00
ACOL01 A COLD DISTRIBUTORS LTD 2008 Jan £0.00
ACOL01 A COLD DISTRIBUTORS LTD 2008 Feb £0.00
ACOL01 A COLD DISTRIBUTORS LTD 2008 Mar £0.00
ABBL01 ABBLYN CONTRACTS 2007 Jan £0.00
ABBL01 ABBLYN CONTRACTS 2007 Feb £1,106.60
ABBL01 ABBLYN CONTRACTS 2007 Mar £0.00
ABBL01 ABBLYN CONTRACTS 2008 Jan £0.00
ABBL01 ABBLYN CONTRACTS 2008 Feb £6,211.07
ABBL01 ABBLYN CONTRACTS 2008 Mar -£641.40
ADAP01 ADAPTABLE SHOP DISPLAY 2007 Jan £0.00
ADAP01 ADAPTABLE SHOP DISPLAY 2007 Feb £523.50
ADAP01 ADAPTABLE SHOP DISPLAY 2007 Mar £128.90
ADAP01 ADAPTABLE SHOP DISPLAY 2008 Jan £0.00
ADAP01 ADAPTABLE SHOP DISPLAY 2008 Feb -£0.03
ADAP01 ADAPTABLE SHOP DISPLAY 2008 Mar £436.96



Warning: before you go ahead and do fancy stuff, ask your boss what
information he would like to know and then you can add whatever extra columns
you need.

Highlight the information so you drag the cursor from A1 to E19

Go to data -> tools -> pivot table

Then you can create different pivot tables using the same source of data. So
after you have created one pivot table and you want to create another select
'other pivot table' as the data source.

To create a chart, highlight the pivot table and choose the 'chart' from the
toolbox.