Mon 26 Jan 2009, 17:08Delegate Dee said...
Dee has attended:
Excel Advanced course
Excel Intermediate course
Excel 2003 cell naming
I am having difficulty getting my head around naming a cell and how that is used later. Do I name the cell in the top bar at the left hand side?
Wed 28 Jan 2009, 15:43Trainer Carlos said...
RE: Excel 2003 cell naming
Hi Dee
Yes. In the Excel Formula bar there is a Name Box on the left side.
The quickest way of naming a Cell or a Range of Cells is to highlight the relevant cell(s) and then to click in the Name Box and enter the name (eg Name a cell holding the vat value as VAT).
Then when creating a formula that involves vat you could write
= C8 * VAT
Hope this helps
Carlos
