Basic spreadsheet help
Discussion
There's likely a SUM formula in the cell calculating the total of the rows, something like =SUM(A1:A10). You'll have to update the second cell reference (ie A10 in that example) to include the rows you've added, the "10" is the row number part. So if you inserted two rows above the existing total row, the example formula used here would have to be =SUM(A1:A12).
Edited by fbc on Thursday 22 August 13:15
Glad it's sorted. Couple of other thoughts before you go too deep into this:
1) I've not used Libre Office but it may not be the most "friendly" free option. You might consider Apple Numbers or Google Sheets - they probably have better easy options. Also, there will be TONNES of YouTube etc. resources on them.
2) I'm always a bit worried about using templates if I don't 100% understand what they're doing. As others have said, garbage in, garbage out...
3) If you're a complete novice to spreadsheets - is this the best use of your time or should you be delegating it? Not sure what that looks like (will an A-level student do it for minimum wage?) but what's the opportunity cost of you learning spreadsheets? (do as I say not as I do BTW)
1) I've not used Libre Office but it may not be the most "friendly" free option. You might consider Apple Numbers or Google Sheets - they probably have better easy options. Also, there will be TONNES of YouTube etc. resources on them.
2) I'm always a bit worried about using templates if I don't 100% understand what they're doing. As others have said, garbage in, garbage out...
3) If you're a complete novice to spreadsheets - is this the best use of your time or should you be delegating it? Not sure what that looks like (will an A-level student do it for minimum wage?) but what's the opportunity cost of you learning spreadsheets? (do as I say not as I do BTW)
I would say learning a basic grasp of spreadsheets will be time well spent.
I also suggest writing your own as much as possible for simple stuff, then you know exactly what it does and how it works.
And put comments in there to remind you in a year's time.
Libre is mostly like excel, plenty of help available
I also suggest writing your own as much as possible for simple stuff, then you know exactly what it does and how it works.
And put comments in there to remind you in a year's time.
Libre is mostly like excel, plenty of help available
Gary29 said:
Glad you soted it, and no offence meant here, but I would be weary of doing business expenses on a spreadsheet as a complete beginner, hard to get my point across without sounding condescending, but just be careful is all I'm trying to say!
I disagree, in my technical job I frequently have to figure out oddly written software, and there are consequences if I get the final result wrong. But it is quite motivating in terms of learning to know that you have to try, and having your own money at stake in a small business is also motivating.
And if it works first time you haven't learnt anything. If your concern is about tax trouble then obviously get someone qualified to look over it when necessary.
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff