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.
Yahoo! and Microsoft announced an agreement that will improve the Web search experience for users and advertisers, and deliver sustained innovation to the industry. In simple terms, Microsoft will now power Yahoo! search while Yahoo! will become the exclusive worldwide relationship sales force for both companies' premium search advertisers.
For Web users and advertisers, this deal will accelerate the pace and breadth of innovation by combining both companies' complementary strengths and search platforms into a market competitor with the scale to fuel sustained development in search and search advertising. Users will find what they care about faster and with more personal relevance. Microsoft's competitive search platforms will lead to more value for advertisers, better results for web publishers, and increased innovation and efficiency across the Internet.
Under this agreement, Yahoo! will focus on its core business of providing consumers with great experiences with the world's favorite online destinations and Web products providing a viable alternative to advertisers, this deal will combine Yahoo! and Microsoft search marketplaces so that advertisers no longer have to rely on one company that dominates more than 70 percent of all search. With the addition of Yahoo!'s search volume, Microsoft will achieve the size and scale required to unleash competition and innovation in the market, for consumers as well as advertisers. Microsoft Chief Executive Officer Steve Ballmer said the agreement will provide Microsoft's search engine, Bing, the scale necessary to more effectively compete, attracting more users and advertisers, which in turn will lead to more relevant ads and search results.
The term of the agreement is 10 years;
- Microsoft will acquire an exclusive 10 year license to Yahoo!'s core search technologies, and Microsoft will have the ability to integrate Yahoo! search technologies into its existing web search platforms;
- Microsoft's Bing will be the exclusive algorithmic search and paid search platform for Yahoo! sites. Yahoo! will continue to use its technology and data in other areas of its business such as enhancing display advertising technology.
- Yahoo! will become the exclusive worldwide relationship sales force for both companies' premium search advertisers. Self-serve advertising for both companies will be fulfilled by Microsoft's AdCenter platform, and prices for all search ads will continue to be set by AdCenter's automated auction process.
- Each company will maintain its own separate display advertising business and sales force.
- Yahoo! will innovate and "own" the user experience on Yahoo! properties, including the user experience for search, even though it will be powered by Microsoft technology.
- Microsoft will compensate Yahoo! through a revenue sharing agreement on traffic generated on Yahoo!'s network of both owned and operated (O&O) and affiliate sites.
- Microsoft will pay traffic acquisition costs (TAC) to Yahoo! at an initial rate of 88% of search revenue generated on Yahoo!'s O&O sites during the first 5 years of the agreement.
- Yahoo! will continue to syndicate its existing search affiliate partnerships.
- Microsoft will guarantee Yahoo!'s O&O revenue per search (RPS) in each country for the first 18 months following initial implementation in that country.
- At full implementation (expected to occur within 24 months following regulatory approval), Yahoo! estimates, based on current levels of revenue and current operating expenses, that this agreement will provide a benefit to annual GAAP operating income of approximately $500 million and capital expenditure savings of approximately $200 million. Yahoo! also estimates that this agreement will provide a benefit to annual operating cash flow of approximately $275 million.
