Power Excel Training Program for Traders (Live Class)

 Power Excel Training for Traders - Mar'25

Course Fees - 1,999 /=

Whatsapp - 8610143936

Language - Hindi

Starting Date - 15th Mar'25 (Sat)

Total Duration - 12 Hours

Course Dates - Sat and Sun (2 - 3 pm)

Power Excel Training Course Contents

Topics Covered

• Intermediate & Advanced Functions
• Interrmediate & Advanced Formulas
• Power Query - Cleaning & Transforming Data
• Power Pivot - Handling huge complex data
• DAX Formulas - Formulas to handle complex data
• Powe BI - Visualisation of data
• Power BI - Web Scrapping
• How to use Google Sheets for Traders
• Getting live data in Excel (Fyers Account holders)
• Designing Option Strategy
• Trading View Pinescript (Basic)
• How to use Chat GPT for analysis

Use for the Traders (indicative list)

• Handling huge FNO Data - even 10 crores of rows in excel
• Calculating PE Ratio for all combinations
• Screening of stocks based on Gann Mid Point Theory
• Getting Option Chain for any historical date
• Calculating VWAP for any instrument for any date / strike
• Cleaning complex data like FII Open Interest report
• Getting Trading Signals based on tick data

Pre designed Excel & Power BI Dashboards

• Fyers Excel Dashboard
• FNO Analysis - Power BI Dashboard
• Option Chain in Excel
• Cash Market Stock Screener - Power BI Dashboard
• Trading View Pine Scripts (Customised)