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.
SharePoint document libraries are clearly useful for maintaining the integrity and versioning of documents while at the same time making them available to a team of people in a central location. It is also possible however to make your document libraries available in Microsoft Outlook. The SharePoint content is synchronised and therefore available to users while they are offline.
This is a pretty easy task, open your SharePoint document library , click ‘Actions’ followed by ‘Connect to Outlook.’
You will be prompted to connect and once you accept this you will see Sharepoint folders added to your Outlook navigation pane. In the example below the folder name is ‘Intranet – Documents’ although this can be altered.
As Outlook performs its’ usual send and receive processes documents will be synced to the folder in Outlook. The user in Outlook can also take advantage of the preview option when viewing attached documents from Sharepoint.
Please log in if you would like to leave a comment on this article
