Certification will be delivered as per Industry criterion for Equity Research training which would benefit fresher/Experienced to up-skill at Corporate.
Professional & expert Techno-Functional Analyst Trainers from Top B-college With 10+ Years of working experience will deliver the workshop sessions.
When 70% of training will be completed of learners then devoted placement team will start to process of scheduling your interviews.
Expand your proficiency with extreme aligned of Corporate with set of technical test series with practical session to glaze your potential.
Learners will grasp real time & practical training sessions with thorough case studies & workshops at SLA Noida
Will get 7 Days assistance for upcoming batch schedule/re-scheduling classes/arrange or ask to arrange a backup or doubt sessions
Course Duration: 70-75 HRS with Highly Skilled Corporate Trainers-Equity Research & Stock Market Analysis Training for 3 Modules-Weekdays/Weekend
SLA Consultants Noida – Equity Research & Stock Market Analysis Certification Training Delivery Method:
VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept InLookup Formula’s ,Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs,
Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Date,Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second,Now, Today, Time
And, Or, If, Iferror, Not, Nested If ,Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min
Data Collection Method With Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality
Single/Multidimensional Analysis, Like Three Dimensional (3D) Tables Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table,
Advanced Chart Technique, How To Make Dynamic Charts, Bar Charts, Pie Charts, Scatter Chart, Line Chart, Column Chart, Speedometer Chart, Gantt Chart, Two-Variable Data Table
Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data split.
Pivot Table and Charts, Import and Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display
Perform the Fundamental Analysis (Ratio Analysis) for historical years (vertical analysis, horizontal analysis and trend analysis and calculate ROEs using DuPont).
|Course Module||Course Duration|
|Module 1- 3||70 – 75 Hours|
|Course Schedule||Batch Timing|
|Monday to Friday||8:00 AM – 10:00 AM|
|Monday to Friday||10:00 AM – 12:00 PM|
|Monday to Friday||2:00 PM – 4:00 PM|
|Monday to Friday||4:00 PM – 6:00 PM|
|Saturday/Sunday||8:00 | 12:00 | 2:00 | 4:00|
|Sunday||8:00 AM – 10:00 AM|
|Sunday||10:00 AM – 12:00 PM|
|Sunday||2:00 PM – 4:00 PM|
|Sunday||4:00 PM – 6:00 PM|