Re: Spreadsheet sheet help needed please :-)

*oh*no*i*just*wet*my*espadrilles* · ‎05-07-2014

Hi

Could someone direct me to where I can get help building a basic spreadsheet please?

I have no knowledge of how to construct one, and just tried for the last 2 hours, but made a right mess of things and have to give up!

I need to have just five columns in the spreadsheet:

* Date

* Daily sales amounts in £'s

* A breakdown of the same sales amount for cash takings only

* A breakdown of the same sales amounts for credit card takings only

* Commission earned

I'll need to be able to structure this so that it covers each month. I googled and there are some free spreadsheets out there, but I can't seem to find one that is suitable (or simple!)

Many thanks in advance!

(p.s I have 'Microsoft Excel Starter' and 'Open Office Calc' on my laptop)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Do you like my snub nosed monkey?

Don't think rude thoughts; it's the cute thing on the left...

aernethril · ‎05-07-2014

Well, you should be able to put the headings at the top of the columns

If you right click on each column header, and choose Format Cells, the pop-up window should let you choose that the first one shows the date, then choose Currency for the next four columns.

Try this as a way of getting started

http://ocsnext.ebay.co.uk/ocs/sr?&query=2721

********************************************************************************
My body is an old warehouse full of declining storage, my mind is a dusty old reference library, strictly for members and archaeologists only

*oh*no*i*just*wet*my*espadrilles* · ‎05-07-2014

Sorry, but I just watched the video and it's all over my head I know nothing about spreadsheets at all, and I think that video is for those with knowledge I don't have.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Do you like my snub nosed monkey?

Don't think rude thoughts; it's the cute thing on the left...

*oh*no*i*just*wet*my*espadrilles* · ‎05-07-2014

I seem to be getting somewhere now, and have added some figures.

How do I change the top A-Z boxes to titles that I want please? Also, how do I get each of the currency columns to add up totals for me?

Thanks!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Do you like my snub nosed monkey?

Don't think rude thoughts; it's the cute thing on the left...

aernethril · ‎05-07-2014

You cannot change the top a-z nor the side row numbers.

You just put your titles in whichever row (eg 1 or 2 etc) along the top.

To automatically add a column, click in the next empty cell at the bottom and then if it's excel, scroll along to where you see a strange E and/or it says Autosum

Click on that.

It will then automatically highlight the above cells in that column.

Click enter

********************************************************************************
My body is an old warehouse full of declining storage, my mind is a dusty old reference library, strictly for members and archaeologists only

aernethril · ‎05-07-2014

The eBay video really is for beginners and will help you download all your selling info without you having to enter stuff manually.

Try something like this on youtube

http://www.youtube.com/watch?v=eI_7oc-E3h0

********************************************************************************
My body is an old warehouse full of declining storage, my mind is a dusty old reference library, strictly for members and archaeologists only

*oh*no*i*just*wet*my*espadrilles* · ‎05-07-2014

@aernethril wrote:
The eBay video really is for beginners and will help you download all your selling info without you having to enter stuff manually.

Try something like this on youtube

http://www.youtube.com/watch?v=eI_7oc-E3h0

I need the spreadsheet for non ebay related sales, but I'm starting to get to grips a bit now thanks 🙂

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Do you like my snub nosed monkey?

Don't think rude thoughts; it's the cute thing on the left...

aernethril · ‎06-07-2014

Oh - sorry about that.

Then try that youtube video.

It's actually easier to show like that than to try to describe because there are so many different functions.

********************************************************************************
My body is an old warehouse full of declining storage, my mind is a dusty old reference library, strictly for members and archaeologists only