|
|
|
|
|
|
Using named ranges in Excel can
increase your
productivity
|
| The standard procedure for accessing values in Excel
worksheet cells or ranges of cells is by using the cell address which
can sometimes be difficult but using named ranges in Excel or named
cells you can perform calculations more intituitively i. e. more like a
human than a computer. If we have salary data in cells B2 to B7 then we
can sum the data by typing the formula '=sum(B2:B7)'. If we had named
the range B2 to B7 as 'salaries' then we could add the values by typing
'=sum(salaries)' in any other cell in the active worksheet or another
worksheet in the workbook. That's convenient and useful! You can also
imagine that if we had a range of cells containing data on expenses and
another range having our income data and we had named thes ranges
'expenses' and 'income' respectively, then we could easily calculate
the profit by typing in another spreadsheet cell '=income-expenses'. Of
course, here we have assumed that our income is higher than our
expenses. |
A different method to implement the use of named ranges in
Excel for
calculations than shown in the training video :
- Select your data
- Click on 'Insert' in the menu bar
- Then select 'Name' and next 'define...'
- In the 'Define name' window give an appropriate name
as
demonstrated in the Excel training video
- Finally you can see, it's easier to perform your
calculations using a 'name' rather than using cell addresses or ranges
in Excel
|
|
|
|
|
|
|
|
|