 |
|
Discover
"Named
Ranges" Named Ranges are a powerful tool within Excel that allow you to specify meaningful names for a cell or a range of cells within your Worksheet. The benefits to you are ....
We'll use this sample worksheet as an example. Lets say we have a table of Sales data for our organisation and we want to ensure we understand the calculations being used.  We have a cell 'F2' that contains the Commission Rate to be applied against all Sales made. Lets create a Named Range for the cell that contains the Commission Rate. Step 1 - We select the cell 'F2' and then select Insert -> Name -> Define. The following Pop-up will be displayed. Here we enter the name by which we will reference the cell, in this case 'CommissionRate'.  Step 2 - Now to use that Named Range, for each of the cells in Column C we need to include a formula to calculate the Commission on each Sale. The formula will use the Named Range, and for each row it will be (=C5*CommissionRate) Now when reviewing that calculation in future you will quickly understand how the amount shown is derived. To extend the use of Named Ranges further to a group of Cells, lets create a Named Range for all Sales Transactions so that they can be Sorted in different ways and Reformatted as required. Step 3 - Select the cells 'A5:F21' and then select Insert -> Name -> Define. This time in the Define Name Pop-up we specify the name 'SalesTransactions'. Now to select the Named Range we use the Name Box in the upper left corner of the Worksheet, you can do this by selecting the drop down list or by typing the name of the Range. After selecting the name, the Range will be selected and you can then perform the required sort or formatting changes.  As you can see the use of Named Ranges can be a very powerful tool in the development of efficient and well organised spreadsheets. To download the Named Range Sample worksheet and try these features for yourself Click Here. If you have any questions, would like help in using this approach or you have a more complicated requirement then Contact Us and we will assist. If you are not yet a subscriber to the XLAutomation newsletter then Click Here to subscribe and receive guidance and tools that will increase your efficiency in using Microsoft Excel, Word and Powerpoint. |
"Message Blaster" is here... We have listened to our clients needs and after much anticipation released our lastest exciting new product. Message Blaster provides "One Click" communication with your customers and contacts. Imagine a system that automatically sends SMS's and Emails, without manual intervention! Click Here to find out more about Message Blaster. To hear what our customers have to say about Message Blaster Click Here Tell us What YOU need... If you have a specific problem or area of Excel that you would like to see featured in next months Newsletter then let us know. Click Here to tell us what YOU need. Latest Offers "Free Consultation" Take advantage of our 1 hour free on-site consultation. We guarantee to provide advice that will improve the way you currently use your Microsoft® Office software. Click Here to book a session with one of our consultants. "Refer a Friend" Forward our Newsletter to your Friends and Colleagues and if they subscribe you will go in the draw for "10 hours Free Consulting" from the XLAutomation team. Make sure you ask your Friend to include you as their referrer when they Subscribe. Prize drawn 31 March, 2009 !! Click Here for more details. |
|
|