What else can Excel do?
How is your data layed out?
" wrote:
On 3 Jun, 10:38, scubadiver
wrote:
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?
" wrote:
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- Hide quoted text -
- 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
|