Daily Tips and Tricks Special Delivery

Sign up for other newsletters | Unsubscribe | Update your profile Add Professional Charts You can quickly add impact to your slides by using the Microsoft Office PowerPoint 2007 charting tools. Use charts to better illustrate, compare, and communicate data to your audience. 1. Go to the Insert tab and click the Chart icon. 2. Select the type of chart that best suits your needs—for example, a line, bar, pie, area, or surface chart. 3. If you have Microsoft Office Excel 2007 installed, the program will open and enable you to change the data behind your chart. 4. Explore and use the options in the contextual tabs under Chart Tools to alter the design, format, and layout of your chart. 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. • Tips and Tricks Web site • Microsoft Office Online • Help Privacy note: Microsoft respects your privacy and that of your friends. Please do not use the Tell a Friend button to send mail to more than 10 people. Microsoft cannot collect any data about the people you send mail to unless they sign up for Tips and Tricks Special Delivery. To cancel your subscription to this newsletter, reply to this message with the word "unsubscribe" in the subject line. You can also unsubscribe at the Microsoft.com Profile Center. You can manage all your Microsoft.com communication preferences at this site. Legal information Microsoft Corporation One Microsoft Way Redmond, WA 98052 Sign up for other newsletters | Unsubscribe | Update your profile © 2009 Microsoft Corporation Terms of Use | Trademarks | Privacy Statement