eLuSiVeMiTe
Member
- Messages
- 16,438
- Location
- ......
Never had issues with open office. Less bloat than M$ but was given keys to their full suite a few years ago so made use of it
- Thread starter Kayos
- Start date
500e
Always buy fire insurance a flood is a hard start
- Messages
- 9,315
- Location
- South West
Wife is a demon spread sheet person, the annuals for the helicopters have numerous times for components with Serial No's. all to be logged at set intervals to show how long in service hours life left, Hours left till next service & what is required at that time + AD's & SB's can be inserted with action taken.
SWMBO moved from Excel to OO without a problem
SWMBO moved from Excel to OO without a problem
Burdekin
Chief Bodger
- Messages
- 6,684
- Location
- Aberdeen
Can’t help you out with what is a good book but before I did uni I did an introduction course to Microsoft office and it was a good place to start and ask questions. You might not want to do a course but it’s one of those things that is easier to pick up by being shown it rather than reading a book so maybe someone you know can show you the ropes. Learning some basic formulas and the basics of the program is probably all you need for a start.
Kayos
Gone......
- Messages
- 9,605
- Location
- Yorkshire
I subscribe to some online training, I will see if they have anything to offer
graffian
Seer unto the end of his beard
- Messages
- 3,826
- Location
- gatwick
I use google spreadsheets when I need a spreadsheet. It's really handy if
you want someone else to be able to see it. I learned a bit with lotus 123
so I know the basics and if I put a question in to google I usually find the
answer, mostly related to excel.
you want someone else to be able to see it. I learned a bit with lotus 123
so I know the basics and if I put a question in to google I usually find the
answer, mostly related to excel.
Kayos
Gone......
- Messages
- 9,605
- Location
- Yorkshire
Pretty much spot on, is it possible to have totals on the columns as well?
I use open office as it is free, I have found it best to lay out on paper what I wish to acheive and then enter it into a spreadsheet. I always check the formula manually when I first set it up as some of the formula in the spreadsheet is not intutative and it is easy to replicate a mistake on subsequent sheets.
Yes it is.
Orange hilighted cells are the totals from the columns (below them). Blue hilighted cells total the payments received from the right.
This shows the formula for getting the vertical totals. (in this case in B2 to get the total of column B) I could also have used =SUM(B4:B13) to select the range of cells.
This shows the formula for cell C4 to get the total of payments received for that job.. Again could have used a range instead of a list of cells by using =SUM(E4:H4)
This one should be fairly self explanatory :
I think those formulae should work for either Excel or Open Office I think (and Google sheets since that's what I used to make this)
Edit to add, totals could be at the bottom, but this way is easier if you don't want to restrict the number of jobs you can have, or the number of payments you can have.
graffian
Seer unto the end of his beard
- Messages
- 3,826
- Location
- gatwick
You could write the sum formulas above as =sum(E4:H4)
That is a row but a column works the same way, so it would be =sum(B4:B13)
If you type the fomula in as your writing it the cells being summed will highlight so
you can see what your doing.
That is a row but a column works the same way, so it would be =sum(B4:B13)
If you type the fomula in as your writing it the cells being summed will highlight so
you can see what your doing.
Hood
I am obsessed.
- Messages
- 17,884
- Location
- Carnoustie, Scotland
Or you can easily use the auto sum function.
Click the box you want the sum to be in, click autosum then click and drag the mouse to all cells you want.
You can also click on a cell and then press Ctrl and click on other random cells and you will get the sum of them.
Quick vid showing what I mean and BTW I am a totally useless with spreadsheets so if I can do such things anyone can.
Click the box you want the sum to be in, click autosum then click and drag the mouse to all cells you want.
You can also click on a cell and then press Ctrl and click on other random cells and you will get the sum of them.
Quick vid showing what I mean and BTW I am a totally useless with spreadsheets so if I can do such things anyone can.
DAPPH
as dyslexik as I'm daft
- Messages
- 7,329
- Location
- Near to Cross Hands Llanelli SouthWales GB
How to do just about everything in eXcel is a book I've got hanging around somewhere , it's one of the few books I've found useful to get started .. I got eXcel for dummies later on when I was looking for something special but it was like getting my teeth pulled without anesthetic trying to find what I was after .
It's a walk thorough book showing how to put columns where how to make formulae to calculate etc etc. how to set dates, numbers how to insert & copy make work books . .page or line colours to highlight things .
I drew up an outline in pen then started building ..inserting new columns & new lines where needed . It also tells you how to carry titles over to pages put the first line on all pages so it is the same and how to set the page breaks etc. set line & page numbers etc. It's important sometimes to have a header , footer & page of so many pages as well as the first line of title to appear on every sheet you print off , just so you don't get lost/ confused when looking at say printed page 26 of 43 and there would have just been rows of numbers for you to guess what they relate to..
" How to Do Just About Anything in Excel (Readers Digest) Hardcover – 26 Sep 2008 " , on Amazon … It's cheap , yes it is an old book but it works for windows 10 . There may be one or two slight changes in titles of things but in the main …. " It's eXcel- ent ".
No ! , you can't have my copy .
It's a walk thorough book showing how to put columns where how to make formulae to calculate etc etc. how to set dates, numbers how to insert & copy make work books . .page or line colours to highlight things .
I drew up an outline in pen then started building ..inserting new columns & new lines where needed . It also tells you how to carry titles over to pages put the first line on all pages so it is the same and how to set the page breaks etc. set line & page numbers etc. It's important sometimes to have a header , footer & page of so many pages as well as the first line of title to appear on every sheet you print off , just so you don't get lost/ confused when looking at say printed page 26 of 43 and there would have just been rows of numbers for you to guess what they relate to..
" How to Do Just About Anything in Excel (Readers Digest) Hardcover – 26 Sep 2008 " , on Amazon … It's cheap , yes it is an old book but it works for windows 10 . There may be one or two slight changes in titles of things but in the main …. " It's eXcel- ent ".
No ! , you can't have my copy .
Hood
I am obsessed.
- Messages
- 17,884
- Location
- Carnoustie, Scotland
I think you can as I was looking at it for a friend but then I stumbled upon WPS Office and it was free and seems to basically be a clone of MS Office. It also has a PDF reader which works well, so much so I have not used Foxit since I installed and my old Version of MS Office (XP), although still installed has not been used.
mtt.tr
Member
- Messages
- 8,460
- Location
- Essex/Suffolk border
For most purposes Google docs, open office and excel work exactly the same. It's only when you get more complicated that the differences become apparent.
mtt.tr
Member
- Messages
- 8,460
- Location
- Essex/Suffolk border
rtbcomp
Moderator
- Messages
- 18,573
- Location
- Sheffield UK
That's another reason why I want to know, I tend to use macros quite a bit so I need 100% compatibility.
