Adding Outside Data
When you have a spreadsheet or PivotTable saved, you might want to connect the data in it to data in another spreadsheet or database. You can do so by using the advanced features of Microsoft Excel, which support establishing a data connection to another data source from the new Excel worksheet. This chapter’s focus is on Microsoft Dynamics CRM, so the advanced features of Excel are not outlined.
For example, your department might have a budget model in Excel. You could connect it to your opportunities to assess whether you are on track to meet the budget numbers.
Get Sams Teach Yourself Microsoft® Dynamics CRM 2011 in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
