For those of you who still have trouble visualizing Excel Named Range features, it is basically a means to give an identity to a set of rows and columns (range) such that its definition and referencing gets simplified. For example, if Mar_Stat refers to the column covering the figures relevant to the month of March, rather than specifying a function of say, = SUM(D10 : D22) , you can simply write = SUM (Mar_Stat) to achieve the same result. This saves both time and effort in cases where there are hundreds of redundant functions to be applied daily.
http://goo.gl/bVnlyq
No comments:
Post a Comment