About
Dear Professional,
SuSapta is conducting "Excel Modeling & Business Analytics" workshop starting 05th MAY 2012 for business analyst aspirants.
Salient features of the workshop:
-
Extensive 24 hours course with multiple trainers
-
Business Concepts and Case Study based approach
-
Sufficient time and individual desktops for hands-on practice
-
Modeling using advanced Excel
-
Customized and interactive workshop delivery
Need for Business Analytics:
Business Analytics is a widely growing need in the highly competitive business environment. Anaytics powers businesses to stay ahead of the competition with strategic direction and business insights. This has created an acute demand for business analysts across all the industries.
Course Structure:
Case Studies Forecasting Trend Analysis Seasonality factors Other influencing factors like advertising Variance Analysis Budget Vs Actual variance RCA ( Root Cause Analysis) Bridge Chart Business Modeling Revenue projections Cost analysis Breakeven & Pay-back analysis Project Evaluation Time value of money DCF (Discounted Cash Flow) Return Analysis
|
Conceptual Coverage Technical concepts DCF Optimization techniques Forecasting (Time series) Trouble shooting Break Even & Payback Time value of money Bloopers % Growth errors (-ve base) Sumproduct errors (zero values) Average errors (zero values) Standard Deviation errors
MS-Excel Tool Coverage Data table Goal Seek Advanced Formulas Solver Macros Pivot Table |
Key take aways from the course:
- Equipped with the power of analytical skills
- Dashboard creation expertise
- Data mining & interpretation skills
Date & Time:
05 May | 3:00pm - 7:00pm
06 May | 9:00am - 1:00pm
12 May | 9:30am - 5:30pm
19 Nov | 9:30am - 5:30pm
Course Fee:
INR 8,500 per participant
Please block your seat by paying a registration fee of INR 1,000. Remaining amount of INR 7,500 to be paid in cash/cheque/DD at the workshop venue. Please note that the seats are limited.