This has been on my PC for years and must be full of cobwebs by now! I would really like to start using it - but am confused about the mechanics of
Does anyone have a list of useful formulae that they would care to share? A sort of idiots guide of how to do ...
I have Excel but rarely use it. Most of my spreadsheet work is fairly simple used for keeping records of supplies bought, rental income and so
I use the spreadsheet that is included with Microsoft Works 8.5. It has a nice thing under tools called easy calc. You just tell it if you want to add, subtract or what ever and highlite the entries you want and it about does it for you. It is nice if you decide you want to quickly do an additional calculation at any time.
What do you need to do, I've had lots of practice in programming excel.
A simple formula can be placed in one cell which refers to the value in another cell. so you could have a 1 in cell A1 and a 10 in cell A2 in cell B6 you could have a formula =A1+A2 which would then display the number 11, if you choose to change the value in either A1 or A2 see what B6 gives you. That is basically what Excel is good at. You can also use it for a simple database and sort on various columns.
As has been suggested, follow help, it has some excellent tutorials, If you know that a program can do something, in many cases all you need to do is ask it the right questions. IIRC in the original install of excel there were some excellent sample spreadsheets that do display the power of the program. Otherwise, ask here, one of us should be able to point you in the right direction.