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 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.
"We believe technology will play a pivotal role in tackling the global energy issues we currently face," said Craig Mundie, chief research and strategy officer at Microsoft. "Microsoft Hohm demonstrates how a combination of advanced software and Internet-based services can help people track, understand and manage their personal energy usage."
Consumers today are motivated to save energy to reduce their spending and do their part in conserving the environment. According to a May 2009 utility consumer survey from Gartner Inc. (conducted with households in the U.S. and U.K.), 80 percent of consumers in the U.S. would participate in an energy program if it were offered by providers. Data also showed that cost reduction is the key driving force behind participating in an energy efficiency program.*
Microsoft Hohm provides savings recommendations, which can range from placing new caulking on windows to removing air leaks to installing a programmable thermostat. These recommendations are tailored based on specific circumstances in the consumer's home including house features, usage patterns and appliances. The savings will vary based on the information shared and the characteristics of consumers' households. If consumers don't provide their data, Microsoft Hohm will base its recommendations on local and national averages. Microsoft Hohm will leverage the energy usage data and feedback from its users to refine and improve the accuracy and relevancy of recommendations. In addition, consumers will be able to compare their energy usage with that of others in their area and connect with the Microsoft Hohm community to find referrals and exchange ideas.
Microsoft Hohm is built on the Windows Azure cloud operating system and leverages Bing search as well as the Microsoft Advertising platform, and is accessible from any computer using a modern browser.
Microsoft Hohm - Enabling Utilities to Provide Enhanced Customer Experiences and Helping Utilities Meet Regulatory Requirements
Today's advanced utilities are leading the charge to be environmentally responsible and sound energy providers. Microsoft Hohm helps utilities by equipping them with a cost-effective and scalable tool that allows them to supply their customers with comprehensive information regarding their energy consumption. For instance, consumers who are customers of a Microsoft Hohm utility partner company can opt to automatically upload their energy usage data into the application in the near future.
