Thank you both for the reassurance that I'm using the right tool - now I just need to learn how to use it!
I am sure the tutorial will prove useful.
Still finding the Excel interface rather clunky though!
For example... I want to name a cell "MyTotal", which I can do easily by entering the name, in the cell reference box top left. So far so good, but now I need to rename it. Rather than simply edit the name in the cell reference box, I have to...
1. Switch to the Formula tab on the ribbon.
2. Open the Name Manager.
3. Select the name I wish to edit, and click Edit (or double click)
4. Make the change - "MyTotal" to "MyTotalNoTax"
5. Click OK
6. Click Close
Why couldn't I simply edit the name in the cell reference box, where I entered it in the first place? After all I can edit formulas that way.
And even worse, if I do try to edit the name in the cell reference box it appears to work, but has in fact created a second reference to the same cell under the new name. I mow have formula referring to the old name, but only the new name is displayed when I select the cell.
Surely a simple pop-up could have asked me whether I wanted to rename or create a new name, rather than employing a six step multi-gui procedure for a very simple operation?