VIKOM INSTITUTE & CONSULTANTS PRIVATE LIMITED

Validity : 15 Days

~~10000~~ 7500 Rs.2500/- OFF

Excel Business Modelling (LIVE)

Buy Now

In this course, we shall provide to you the followings contents thru live sessions

What is Business Modelling
1. Difference between spreadsheet and Financial Modelling
2. Purpose of the modelling
3. What type of skills you need to become the modeler
Building Model
1. Designing Issues
2. Steps to building the model
Reveal EXCEL
1. Name your ranges
2. Vlookup and Hlookup
3. Index Match
4. Conditional formatting
5. Goal Seeking
6. If statements
7. Creating Charts
8. Pivot tables
Understanding Finance
1. PMT, IRR, Rate function
2. Time value of the money
3. Break even analysis
4. Pay Back Period
5. Depreciation
6. WACC
Sorting Filtering
Auditing Tools & Require ADD IN

The session would go around 15-17 hours, We take live sessions only on Saturday and Sunday (For Dubai and Saudi Arabia its Friday). The session would held one hour on Saturday and One Hour on Sunday. Live Softwares - Google Hangout/Zoom/Skype
For further information regarding the course please email on info@vikominstitute.com or WhatsApp on +91-9213331108