Excel is so ingrained in the daily process of the private capital markets, it would be nearly impossible to replace it as the workhorse for analysis and reporting. Many CRM systems offer the ability to export data seen on screen to Excel, but with 3 important caveats:

  1. The data is exported as a CSV file, which opens in Excel, but is really a form of text file.
  2. The data that is exported has no formatting, and needs manual updating, copy/pasting or transposing to get it in the right format.
  3. Once the data is exported, it’s a static snapshot in time and cannot be refreshed. Need to update a report with new data? See bullet 2 above.

These 3 caveats above force users to either waste a tremendous amount of time formatting and then updating reports manually, or in the case of some systems, buy extra add-on products at an additional ongoing license cost per user.

salesforce csv export

It’s almost 2018 and this is the best export to Excel  generic CRM platforms that you will pay 10’s of thousands of dollars per year for can muster.

DealCloud is different. Rather than make you export data from a web browser (which DealCloud also supports for the purists out there), DealCloud can leverage Excel as a platform extension.

Familiar with popular Excel Add-ins from S&P Cap IQ, FactSet, or iLEVEL? Your learning curve is likely very low. Not familiar with those, but you know how to write a VLOOKUP? Your learning curve is also very low. Not familiar with any of those but you know how to drag and drop? We’ve got you covered too.

excel ribbon
Access DealCloud data from within Excel using the DealCloud add-in.

There are no add on costs or additional license fees to use Excel as a reporting engine for DealCloud. Best of all, your data is easily embedded into existing report formats and can be refreshed for updates with 1 click.

Here’s how it works: you log into DealCloud through Excel, rather than than export data from a web browser to it. This allows you to access all the information in the DealCloud platform by using easy to learn look up formulas, or a wizard to extract exactly what you need.

excel login
Logging into DealCloud through Excel is one example of using Microsoft Office as a platform extension.

Once in your spreadsheet, format the data anyway you would like. Better yet, Excel will treat the DealCloud data like any other data point in your spreadsheet, which opens the door for pivot tables, SUMIFs, and any other analysis you want to run. The skys the limit. Because the data is being pulled from DealCloud, it can be refreshed as often as you need. Create a report template, save it, and hit refresh – on demand reporting in your preferred format.

excel refresh
Easily refresh Excel reports as often as you need with 1 click using DealCloud

The real world application of this is endless. Easily create internal reporting like your Monday Morning Meeting report, updates for clients or investors, or advanced analytics to support business development, deal sourcing or fund raising.

As with all DealCloud functionality, Excel as a platform extension is covered as part of DealCloud University.

 

 

 

One comment

Leave a Reply