2003 to 2007 Structured References
Working with formulas and functions has not always been the most intuitive process. In Microsoft Office Excel 2003, multiplying gross revenue by the profit margin might mean typing something like =B7*E14. In Microsoft Office Excel 2007, structured referencing enables you to use the column headers in table data to build your formulas. Instead of cryptic cell locations, you can simply multiply =[Gross Revenue]*[Margin].
To use structured referencing, you first need to format your data as a table.
1. Click Format as Table in the Styles section of the Home tab.
2. Select the My table has headers check box.
3. After you have a table, click the cell where you want to insert the formula, and then type the left bracket ([).
4. Select the column that you want to use from the list that appears, press the TAB key, and then close it with the right bracket (]).
5. Repeat as you build out your formula.
What can I do on this site?
Connect: share advice, get answers to your problems
Discover: discover what you can do with your technology
Create: your own solutions and post them on the site
What is this website all about?
Unlocking IT Value!
All organisations should be looking to improve efficiency and be more cost effective. Information technology can be vital to help you achieve these two goals.
We aim to provide access to as much information about Microsoft Technologies and how you can help make the most of their implementation in your organisations.
We have taken what we believe are some of the most popular Microsoft products and created various solutions that combine various Microsoft technologies that can help you to improve efficiency and increase productivity more cost effectively.
By looking at your existing licences for your Microsoft products you may be able to save costs to create solutions using these licences and the products you have to enable you to get the best from your IT systems and make your investment in technology go further.
As part of this, we have opened up the website to allow others to submit their solutions and advice on getting the best value from your Microsoft Technologies. You can also submit comments and rate articles that have published, sharing your knowledge and experience to help other organisations, especially during these difficult and challenging times.
Why Microsoft technologies?
Microsoft technologies are familiar, easy to use and can be well- integrated into each other. For you this means less training time and more time increasing individual and team productivity.
How to use the Make the Most of website.
On the homepage you will see a number of options.
These options are:
- Product Categories
- Business Areas
- Log in box
- News Feed that can be minimised
- Top 10 Articles
You can click on the product logos displayed which will search the website and display any articles related to this product. If the product logo you want is not displayed on the homepage it may be displayed in 'text' under 'More products' top the bottom right of your screen. You can also search by using 'Business Areas' if you are looking for Microsoft Technologies which relate to the particular department it will apply to.
Click on an article that interests you.
On this page you may submit comments about the solution or in fact you could submit a solution yourself using our Submit an idea option.
Downloads may be available for some solutions giving more information on product and instruction.
Behind the scenes
'Make the most of' is owned and operated by Perfect Image IT Solutions Company. Our HQ is in Newcastle upon Tyne, England with clients throughout the UK.
We are a cutting edge IT Solutions Company renowned for looking after our clients and creating some of the most intelligent code, to make sure our clients get what they need.
We thought this website would help lots of organisations get free access to lots of tips, hints and suggestions for Microsoft technologies in one place.
