DIR Return Create A Forum - Home
---------------------------------------------------------
Albox Computer Club
HTML https://acc.createaforum.com
---------------------------------------------------------
*****************************************************
DIR Return to: General Discussion
*****************************************************
#Post#: 194--------------------------------------------------
Spreadsheets used in today's topic 03 May
By: Intelinside Date: May 3, 2013, 2:54 pm
---------------------------------------------------------
Thought i would upload a copy of the spreadsheet i used in
today's talk (OK slightly modified to show some explanations)
but the sheet operates in the same way.
I have added a picture to show where i found the data i used and
an explanation of how one of the formulas was constructed and
calculated. See if you can figure out how some of the other are
constructed and i will answer any questions over the next week
or two.
The other download is a copy of the Mileage / Fuel / Cost
calculator. To reset it for your own use you can delete anything
in an uncoloured cell. To start the sheet working type the
opening mileage into cell B22, to enter a date type it as so
05-may or 18-jun and press enter it will be converted to the
correct format automatically.
This is a very good site for some basic spreadsheet training,
short and to the point videos explaining things in a very good
way.
HTML http://www.teach-ict.net/software/excel_2007/excel_2007.htm#data_types
#Post#: 198--------------------------------------------------
Re: Spreadsheets used in today's topic 03 May
By: margaretWilkinson Date: May 14, 2013, 4:42 pm
---------------------------------------------------------
Hi
I can not see the formula in the orange boxes only the data
#Post#: 200--------------------------------------------------
Re: Spreadsheets used in today's topic 03 May
By: Intelinside Date: May 15, 2013, 3:03 am
---------------------------------------------------------
When you click on a box with a formula in it the formula is
shown in the bar above the main spreadsheet, just above the
column letters A,B,C,D,E etc. I have attached a screen clip for
you, in the picture i have clicked on cell F15 and you will see
where the formula is then shown.
It is possible to show the formulas in the cells but it can make
the sheet almost unreadable.
#Post#: 204--------------------------------------------------
Re: Spreadsheets used in today's topic 03 May
By: margaretWilkinson Date: May 15, 2013, 8:35 am
---------------------------------------------------------
Many thanks for that Geoff. I should have gone to Specsavers
::)
*****************************************************