Excel Solutions - Defined Names
You can give a cell (or range of cells) a name.
For example, the following formula refers to two cells. [E1] is the price and [E2] is the VAT amount.
However, to make the formula easier to understand, we can give names to cells [E1] and [E2].
Simply click on cell [E1] and in the Name box, type in a new name (in this example it is ‘Price’).
Repeat for cell [E2] with the name of ‘VAT’
You can now use these names in your formulas.
Read about our Excel Development Projects
A leading Auctioneer came to xlteq to help streamline and automate their global headcount reporting in Excel. This included real-time clarification of total headcount coupled with detailed location status functionality.
A Danish financial services company asked our Excel Consultants for support with preparing their client investment portfolios. This task now takes less than a minute per customer and is delivered in a format selected by the client then presented as a visually effective Investment Portfolio Dashboard.