Daily Tips and Tricks Special Delivery

Sign up for other newsletters | Unsubscribe | Update your profile Copy Data from a Table in a Web Page to Excel If you see a data table on a Web page and you want to import it into Microsoft Office Excel: 1. Copy the URL (address) of the page. 2. In Excel, on the Data tab, in the Get External Data section, click From Web. 3. In the New Web Query dialog box, paste the URL into the Address box. 4. Select the table that contains the data you want to work with, and then click Import. 5. In the Import Data dialog box, indicate where you want the data to appear, and then click OK. Access SharePoint Documents Offline You can read your Microsoft SharePoint documents in Microsoft Office Outlook. Click Doc Library, click Actions, and then click Connect to Outlook. All the contents of your chosen document library will then be synchronized to a folder in Outlook. • 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