Once it gets tricky with calculations in Excel, cell addresses and pure abstract coordinates are hardly meaningful. It’s clearer and much more comfortable to give important cells, or ranges of cells, a name. These relationships are often much clearer. In this Special Topic we show you how to manually create and delete range names and how to work with automatically generated range names in formulas and functions effectively.

Published on: 22.01.2013

To acces the videos for this Special Topic you must have subscribed to Excel !


Excel 2016

Using Range Names:  
In this video you will learn how to create and delete range names manually. Additionally we will show you how to make calculations using the manually and automatically created range names. (8 Min.)



Excel 2013

Using Range Names:  
In this video you will learn how to create and delete range names manually. Additionally we will show you how to make calculations using the manually and automatically created range names. (8 Min.)



Excel 2010

Using Range Names:  
In this video you will learn how to create and delete range names manually. Additionally we will show you how to make calculations using the manually and automatically created range names. (8 Min.)



Excel 2007

Using Range Names:  
In this video you will learn how to create and delete range names manually. Additionally we will show you how to make calculations using the manually and automatically created range names. (8 Min.)