Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 20. Utilizing the Power of Microsof... > Using Excel to Edit and Clean Up Rec...

Using Excel to Edit and Clean Up Records

CRM 2011 adds a new feature when working with Excel. You may export to Excel, modify, and then reimport into CRM. This is commonly referred to as data enhancement. By using Excel’s native formulas, you can improve or correct CRM data in Excel and then import the corrected data on top of the incorrect data, enhancing the quality of the information displayed in CRM. To access this function, follow these steps:

1. Navigate to the Advance Find or other view of data you would like to enhance.

2. Click Export to Excel.

3. Choose Static Worksheet.

4. Check the box Make Data Available for Re-importing by Including Required Column Headings.

5. Save the export to a local file.

6. Open the file.

7. Make modifications to the Excel spreadsheet data.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint