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.
The Social Networking Accelerator allows business professionals to monitor and analyze customers’ conversations on social networking sites, and as a result, provides real-time status updates about their products and services.
This accelerator delivers integration with Twitter; other networks will be introduced in future releases. A presentation of The Social Networking Accelerator can viewed here.
- Create and manage multiple Twitter accounts.
- Create instant tweets or schedule them for publishing later.
- Re-publish one tweet many times in scheduled intervals for global reach.
- Provide a hyperlink with your tweets, which automatically gets shortened
- Automatically track changes in followers and follows on all your Twitter accounts.
- Automatically track click-through on your tweets.
