Course Content
Getting Started with Microsoft Excel
Getting Started with Microsoft Excel
0/2
Basic Workbook Operations
Basic Workbook Operations
0/2
Formulas and Functions
Formulas and Functions
0/3
Data Analysis Tools
Data Analysis Tools
0/3
Creating Charts and Graphs
Creating Charts and Graphs
0/2
Advanced Excel Features
Advanced Excel Features
0/3
Collaborating and Sharing Workbooks
Collaborating and Sharing Workbooks
0/3
Microsoft Excel Course
About Lesson

Using Named Ranges

  • Defining Named Ranges: Select a range of cells, click on the ‘Formulas’ tab, then ‘Define Name’. Enter a name for the range and click ‘OK’.
  • Using Named Ranges: Type the name of the range in a formula or use the ‘Name Manager’ in the Formulas tab to manage named ranges.