Index Correlations Report


Investment Bank


Analysts needed to review the correlation of various (financial) indices from data in a corporate database.
The process was time consuming with most of the time spent copying-and-pasting the required data to produce the analysis.


The solution was an Excel Add-In.
This displayed a screen which allowed analysts to select options to import.
Data was extracted from the database based on options selected by the analysts.
It was imported into Excel producing a PivotTable and detailed charts for analysis.
This allow analysts to quickly build ad-hoc PivotTables and Charts from database data with a few mouse-clicks.


Excel, VBA

* To respect client confidentiality, identifiers including client logos and names have been removed from all screenshots and descriptions. Displayed names and values are fictional.


Get this FREE Portfolio of VBA Projects

Get this beautiful portfolio of Excel VBA projects for ideas and inspiration.

Over 30 pages of smart solutions using Excel, Word, Outlook, MS Access and VBA.

Click the Download button to get instant access to this project summary as a PDF you can print or share.


Save time, money & stress

Get one-on-one access with an experienced Excel consultant who's ready to solve your business critical Excel, VBA, Formula or Macro problems.

Let me take care of everything for you and take advantage of 20+ years of Excel & VBA development experience.