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.
-
Microsoft, Yahoo! Change Search Landscape
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.
-
Microsoft accepting apps for Windows Marketplace for Mobile
Microsoft has opened the gates for application developers to start submitting apps to their Windows Marketplace for Mobile Store.
Today represents another significant milestone for Windows Marketplace for Mobile, and more importantly, the first big opportunity for developers. We are now accepting application submissions from all 29 supported countries and have launched a Race to Market Challenge to kick things off. It's time to show us what you've got!
-
Microsoft unveil Twitter application for CRM
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.
-
Microsoft Dynamics CRM Announces New Solution Accelerators
CRM Accelerators have exceeded 50,000 downloads to drive customer value.
Microsoft today announced new CRM Accelerators for Microsoft Dynamics CRM that help organizations reduce costs and establish business insight across social networks, channel- centric organizations and web interaction channels.
As with all CRM Accelerators, they are available at no additional cost to current Microsoft Dynamics CRM customers and partners. These solutions can be deployed as packaged extensions to Microsoft Dynamics CRM, or used to help develop new solutions - allowing organizations to help improve the time to value in tailoring Microsoft Dynamics CRM to their business
-
Microsoft Hohm Helps Consumers Save Money and Energy
Microsoft announced Microsoft Hohm, a new online application that enables consumers to better understand their energy usage, get recommendations and start saving money. Microsoft Hohm uses advanced analytics to provide consumers with personalised energy-saving recommendations. Microsoft Hohm is an easy-to-use tool that helps consumers lower their energy bill and reduce their impact on the environment. The beta application can be accessed directly by visiting http://www.microsoft-hohm.com.
-
Microsoft and the EEA today announce 2009 ‘Eye on Earth’
With summer just around the corner Microsoft and the EEA today announce 2009 'Eye on Earth' - helping holidaymakers to find out everything about Europe's favourite beach at the touch of a fingertip.
-
UK Students Win Imagine Cup 2009 Software Design Challenge
Kings College to represent the U.K. at worldwide Imagine Cup finals in Cairo, Egypt.
Microsoft has announced the 2009 UK winners of its annual Imagine Cup Software Design Challenge, at an event held in conjunction with Microsoft Research Cambridge. The competition saw seven student teams, selected from over 3000 entrants from across the UK contend for a chance to represent the UK at the worldwide finals in Cairo, Egypt, in July.
-
Promotion to upgrade Vista users to Windows 7
Vista to Windows 7 coupons could be on their way with some PC vendors to offer free upgrades from Vista to Windows 7.
-
New Search Engine from Microsoft
Decision Engine goes beyond search to help customers deal with information overload.
-
MSN create new celeb feed service
New service combines Twitter feeds and celebrity blogs all in one place.
