| || | Novice | || | Beginner | || | Intermediate | || | Advanced | || | Specialist | || | Expert | || |
List of Features
| Filter | Advanced Filter | Pivot Table | Group and Outline | Data Validation | Name Manager | ||||||
| Goal Seek | Freeze Panes | Split Screen | Conditional Formatting | Text to Columns |
Name Manager
Understanding Name Manager
Select a Column Range and Click Formula-> Name Manager
Name Manager contains Named Range and Named Constants
Named Range
This is a range of Cells. When you select these cells you can see the name populating in the Top left Name Box of excel sheet
Named Constants
This refers to a single cell . You can name a cell and use this name instead of references
Example: Instead of C4* A1 , You may name A1 as Conversion_Rate and say C4* Conversion rate for better understanding.


