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 calendars can be set-up to link into Outlook calendars, allowing team members to keep in touch with project based or departmental appointments. Having all calendars visible from a single location like Outlook can makes keeping in touch easier.
You may already use SharePoint within your organization, perhaps as a portal for projects or departmental work involving a number of different individuals. This is fine and of course you have the benefit of document libraries, document versioning and approvals etc within a readily available central location.
You can also use calendar functions to schedule meetings etc for that project or department. Again this is fine but it may well be useful to connect these calendars to Microsoft Outlook so that participants can be kept up to date without having to visit your Sharepoint site.
This is quite a straightforward process as follows;
Our example shows a SharePoint calendar for the Marketing department with a recurring weekly meeting to plan a bike show.
When you have the calendar open in SharePoint you can simply click the ‘Actions’ menu followed by ‘Connect to Outlook’
Outlook will open and prompt a connection. When you accept this a calendar will be automatically created in the ‘Other Calendars’ area of Outlook.
You can use the ‘View’ option to select ‘view in overlay mode’ which will place your new calendar alongside your existing calendar in a tabbed style.
Once this connection has been made individuals can see the calendar from within the SharePoint site as before, but also it will be available to them from within their Outlook.
By working through a few brief steps then, you have further connected groups of people without the need to develop anything in a bespoke way. This simply uses Microsoft functionality that you may well already have a license for.
Please log in if you would like to leave a comment on this article
