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.
New service combines Twitter feeds and celebrity blogs all in one place.
More Hollywood A-listers are taking control of their image online, instead of letting the paparazzi do it for them. Celebrities such as Oprah Winfrey and R&B singer Usher are some of the latest stars to join the Twitter circuit, while blogs by Kanye West and Gwyneth Paltrow are attracting more fans than a Taylor Swift concert.
But with so many stars and so little time, how do you keep up with your favorite celebrity? MSN Wonderwall makes it easier to follow all your favorite celebrity chatter by bringing it together in one place.
Wonderwall is a celebrity destination developed by MSN (http://www.msn.com) and independent media company BermanBraun, which allows consumers to experience and digest the latest on the lives of celebrities, like never before. Consumers get an opinionated, in-the-know and irreverent take on celebrity information within a highly innovative and dynamic design. Wonderwall includes the latest information and photos from leading celebrity and paparazzi agencies, original editorial content created by the Wonderwall editorial team, and video content from MSN content partners.
Celebrifeed, available today on http://wonderwall.msn.com, aggregates the latest celeb tweets and blog posts in real time, allowing fans to follow along as stars weigh in on their personal reality show picks, plug their favourite diets, compete against each other for followers and even end relationships!
Features of Celebrifeed include
|
Sorting by celebrity name or the chronology of the Tweet/blog entry |
|
|
Click-through feature to learn more about the celebrity |
|
|
One-click feature to access the Tweet or blog directly |
