Free Microsoft Excel Training Videos

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

More about working with named ranges in Excel
Using a named range in Excel

Named ranges in Excel