Course Description:-

INTRODUCTION:

A credit rating affects a firms a company’s access to capital and investment choices. D o you know how credit rating agencies like CRISIL, ICRA determine this credit rating? What all is analyzed in order to decide on a particular rating? If you would like to learn all about credit rating you could take up our course on Credit rating.

What you would be mainly doing is analyzing the financials of Time Warner and giving a credit rating. After which you would be preparing a recommendation report. For all of these you have been provided with extensive training material. This course is for those who want to practical application of credit rating concepts. Upon completion of the live project training you would be given a certificate as well.

Target Audience for Credit Rating

• Students in fields relating to finance BCOM, BMS, MMS, MBA, CA, CFA etc
• Candidates looking for internships
• Working professionals who want to shift their career in credit rating or upgrade their knowledge in this field
• Anyone who is keen in understanding practical application of credit rating

Course Highlights

Basic and Advanced Excel Training

Excel training is vital for any Analysts. We are aware of the industry norms and are hence providing you with an entire module on excel to whet your excel skills. Understand and learn various formatting skills in excel. Learn the use of various excel functions like bar chart, scenario graph, Spark lines, Watch window etc.

Report Writing Techniques

Credit rating reports are important in the Credit rating process. Through this module you will get to learn what an equity research report are? We will also make you comprehend the Do’s and don’ts of report writing. In addition to all these, this module also throws light on useful financial websites, peer analysis and many other of preparing a professional industry report.

Benefits of online course:

• High Quality Content
• Learn Anywhere Anytime & at Your Pace
• 24X7 Customer Support
• Complete Student Support Throughout The Program
• Course Completion Certificate 
• Lifetime course access

For any query feel free to call

Mob - 8587999769/9818826705

CURRICULUM

Section 1: Basic Excel

1. Getting Started Ribbons Quick Access Toolbar
2. Getting Started Surfing Excel HELP Function
3. Excel Case Study
4. Data Entry in Excel
5. Populating the Case Study in Excel
6. Calculations Addition Subtract Multiply Division
7. Formulas SUM MAX MIN AVERAGE
8. Formatting Number Formats
9. Formatting Table Formats
10. Updating a Calculation
11. Percentages and Absolute References
12. Conditional Formatting
13. IF Function
14. COUNTIF Function
15. SUMIF Function
16. Creating Charts and Graphs
17. Create Pie Charts
18. Sorts
19. Filter
20. Pivot Table
21. Freeze and Split
22. Presentation Table Formats
23. Presentation Indents and Formatting Charts
24. Printing the Worksheet
25. Printing Headers and Titles
26. Shortcuts Formatting and Navigation
27. Shortcuts Selection Data and Formula
28. Common Errors

Section 2: Advanced Excel

1. Office Button and Paste Function
2. Spark lines Custom Ribbons and Screenshots
3. Conditional Formatting and Equation Editor
4. Paste Special
5. Logical functions IF AND OR
6. Arithmetic functions MAX MIN ABS etc
7. COUNT COUNTIF COUNTA COUNTBLANK
8. Cell Information ISERROR ISBLANK etc
9. CHOOSE Function
10. VLOOKUP Function
11.  HLOOKUP Function
12. MATCH INDEX
13. Database functions DSUM DAVERAGE DCOUNT
14. OFFSET Function Part 1
15. OFFSET Function Part 2
16. FORECAST Function
17. One Dimensional Data Tables
18. Two dimensional Data Tables
19. Solver
20. Goal Seek
21. Array Function Introduction
22. Array Function Row and Columns
23. Array Function TRANSPOSE
24. Array Function FREQUENCY
25. PROPER UPPER LOWER LEFT RIGHT MID
26. FIND CLEAN REPT CONCATENATE
27. Pivot Tables
28. Pivot Table Filter Slicer
29. Pivot Charts
30. Naming a Cell and a Range
31. Naming Dynamic Ranges
32. Auditing Toolbar
33. Watch Window
34. Group Boxes and Options Button
35. Check Boxes
36. List Boxes and Combo Boxes
37. Scroll Bar and Spinners
38. Text to Columns
39. Grouping Tabs
40. SUBTOTAL Function
41. Hyperlinks
42. Data Validation
43. Random Numbers
44. Custom View
45. Protecting Worksheet and Workbook
46. Excel 2010 Spark lines
47. Range Charts Type 1 Part a
48. Range Charts Type 1 Part b
49. Range Charts Area Type 2 Part a
50. Range Charts Area Type 2 Part b
51. Funding Graph
52. Two Axis Graphs
53. Scenario Graphs Part 1
54. Scenario Graphs Part 2
55. Average Line
56. Bar to Pie chart
57. Combo Charts
58. Creating Histogram
59. Invert Negatives
60. Scrolling Chart part 1
61. Scrolling Chart part 2

Section 3: Report Writing Techniques

1. Introduction
2. What is Equity Research Report Part 1
3. What is Equity Research Report Part 2
4. Anatomy of Equity Research Report
5. Comparing Equity Research Report
6. Report Writing: Case Studies
7. Useful Financial Websites
8. Indian Media Sector Report Part 1
9. Indian Media Sector Report Part 2
10. Indian Media Sector Report Part 3
11. Peer Analysis part 1
12. Peer Analysis part 2
13. Peer Analysis part 3
14. Peer Analysis part 4
15. Peer Analysis part 5
16. Peer Analysis part 6
17. Peer Analysis part 7
18. Exhibit: Reliance Petroleum Research Report

Mail us at: [email protected] with below details to receive your certificate:

• Name
• Course Name
• Date of Completion
• Address