Using the Name Manager

DESCRIPTION: Excel is all about simplification. As you advance, you’ll learn that you can squeeze in more and more complex equations in a single cell. To assist with simplification of values, you can store values or even entire table values into variables you create. From there, you can call upon them from anywhere on your spreadsheet. In addition, because these values are stored, changing them in the name manager will automatically update all results. In this course I’ll teach you how to store variables, store tables, change existing data sources and finally how to utilize stored values in a formula.

TARGET AUDIENCE: This course is designed more for analysts, finance officers or accountants who are heavy into their formulations.

DOWNLOADABLE FILES: 

 

DIFFICULTY: Intermediate

COURSE OUTCOMES:

  • Storing variables
  • Using stored values in formulas
  • Changing existing data sources
  • Using variables in array formulas

MORE SHORT COURSES