Find solution
Where to learn how to create my own websites?

Do Investment Bankers use special Excel/Powerpoint add-ins to create those nice graphs? And if so, is there any websites to learn how to make those nice graphs?

  • Answer:

    I'm sure it varies from analyst to analyst, but in my experience, Excel is used for the data manipulation and then that data is copied and pasted into PowerPoint graphs. After all of the data is in the graph, you then have to format according to the firm's template (font, color themes, number formats for the axes, etc). Formatting consistency is key. Some banks have macros installed in PowerPoint to help ensure all of the graphs are sized and positioned in freakishly exact order. The goal is to have slides that communicate a message with clean but effective graphs and few words. So yes, they might have some add-ins that can save time on formatting, but they're just there to help and are not necessary.

Peter Recson at Quora Visit the source

Was this solution helpful to you?

Other answers

Our investment banking clients tend to use the YCharts http://ycharts.com/store/professional_tour/section/excel_addin.  The plugin enables them to build custom templates and charts for comp analysis, valuation and key metrics.  They also use the standard charting on YCharts which is very flexible and provides historical data on over 4,500 metrics per company. 

Shawn Carpenter

I have recently come across the following (paid) course that explains how to link Excel to Powerpoint and how to produce high quality (management consultant style) slide decks https://www.udemy.com/powerpoint-excel-fusion-exec-strategies-250-slide-deck/

David Henderson

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.