The curriculum of the workshop is so designed to make delegates super proficient in Excel and they develop the skillsets which will put that in a good stead as a Finance Analyst in a consulting, equity research or an Investment Banking profile. For anybody to efficiently build financial and business models, one needs to take the excel bull by the horns by learning the basics content and then graduating to advanced level content. The basics of excel will ensure learning and applying fo relevant financial formulas, navigating in the model, scaling up speed and starting to creating, formulating and conceiving own formula in given situations. That is how we start

Once, the basic brushing is done with excel, now comes more complex formulas which help in coming out with meaty results from piles of voluminous data in a matter of seconds.The focus is to effectively and efficiently utilize Microsoft Excel for data analysis. These include and are not limited to

• Combination of multiple functions in a problem as Vlook +Match, Index+Match, VlookUp and If
• Offset Function.
• Sensitivity Analysis using different ways.
• Scenario Manager and how to use that in a model
• Iterative calculations. How to Negate it
• Using Excel for Statistical Analysis like Correlation, Regression, Variance.
• How to summarize data from different sheets and collating them into a single sheet using Indirect function
• Charting:

For most of us, charting means making a bar chart or a pie chart for anything and everything. All the meaty results are most effective when they are presented with the right set of charts. What chart to use for a particular data,that is something we teach through charting workshops. And what more, since you have become comfortable with excel, you learn dynamic chart making. These include

• Rules of creating a bar chart
• Making pictures as linked objects in excel (eg, how to make flags dynamic)
• Making apt chart from the data provided
• Creating dynamic charts and no need to change the chart every time its prepared
• Using Name Manager to make charts dynamic
• Showing multiple charts at the same time in same location using filter
• Now and Then Analysis chart
• Waterfall Charts, Thermometer Charts
• How the charts change using sensitivity analysis
• Interactivity using Form Controls
• Practical Application of Formulas and Charting through Creation of Dashboards
  • Delegates learn the gist of excel through creating of a dashboard by applying the excel formulas, making of charts and subsequently making a dashboard for them to present the piece of data in a professional, robust and meaningful manner. This will involves
  • Advanced excel formulas
  • Conditional formatting
  • Developer tabs
  • Charting including charting tricks using excel formulas

Power Point Training: That we are very comfortable making a power Point, is sort of an illusion which most of us have because once in a lifetime whether in school or college or in MBA degree or for any presentation, we have dirtied our hands with PPTs. There is a alarming gap in terms of the skills which in an illusive state you feel you have in a ppt making and actual the standards which are required in corporate professional world outside. Candidates learn the art of following

• How every slide should pass a 20 second test
• How one has to make meaty slides with fact based representation, proper sourcing of data, effective charts and aesthetic and visual appeal of a ppt
• How the analysed data has to be presented in a structured and phased manner
• How the flow of a presentation should tell a story

Any Big Project is started with knowing its economic feasibility. Financial Feasibility of Projects are based on capital budgeting techniques and help to solve the financial decisions problems faced by firms.

Trading Comps is a pricing technique. It is one of the most widely valuation techniques by investment bankers and finance professionals. Under this we would learn how to build a detailed trading comps right from the selection of peers to the analysis of final output. We would also understand how to compare and use these multiples as a valuation technique, what could the possible reason for differences in the multiples and how to tackle those differences etc.

Precedent transaction/ deal comps is a variant of trading comps. It is one of three major valuation techniques used by the investment bankers (other than trading comps and DCF valuation). The basic premises of this technique is deal value (i.e. what multiples were offered for other transactions in the past under similar purchasing conditions). Under this technique, we would learn how to calculate transaction multiples, how these multiples are different from one we calculated under trading comps, under what situation this valuation technique is appropriate to apply etc.

Under DCF valuation technique, we try to attach value to the business/asset based upon its fundamentals. This technique is entirely different from relative comps technique as in case of DCF valuation we attempt to find value of asset whereas in relative valuation we try to find price of the asset (driven by demand and supply) which may be substantially different from its fundamental value found under DCF valuation. Under this packet of valuation, we would try to find value of the asset based upon its fundamentals; cash flows, risk, growth, etc.

Merger model is prepared to find the impact of transaction (merger/acquisition) on the future earnings of the remaining shareholders in the new company after the transaction. Under this we try to find the short term and long term impact of transaction on the future earnings of shareholders (i.e. whether the future earnings of the shareholders would increase or decrease due to this acquisition). Under this we would learn:

The leveraged Buyout (LBO) refers to the acquisition of a company with a substantial amount of borrowed funds (bonds or loan) to pay for the costs of purchase.

An integral and important part of the curriculum is taking mock interview of the candidates and giving them an experience and exposure of the situations he/she might face in real interviews. Stress interviews as they are help candidates and the faculty judge and evaluate and give a clear picture of where the candidate stands and the further action plan required for the candidate to become a refined resource.

TWSS also helps candidates edit their CVs and make it more appealing and professional. A crisp resume goes a long way in creating the first impression in the mind of interviewer about the candidate.