This course equips learners with practical Microsoft Excel and stock market trading skills. Participants will master Excel functions, data analysis, Power Query, Pivot Tables, dashboards, and automation while learning technical analysis, chart patterns, trading strategies, and live market decision-making to support data-driven financial and investment decisions.
Course Details
Explore the comprehensive course modules
Introduction and General Utility Functions: Filters, Advance Filters, Sorting, Freeze Panes, Duplicates, Paste Special, Round off, Random, Conditional Formatting: highlight cell rules, data bars, colour scales, icon sets, colour coding. Text Functions: Left, Right, Trim, Upper, Lower, Proper, Concatenate, Text to Column, Text join. Logical & Mathematic Functions: Min, Max, Large, Small, Sum, Count and Average functions (including IF and IFs), Date, Time, Month, Year, Unique, Relative and Absolute References, Cell Linking and Cell Freezing, IF Statement, Nested if, and Logical Functions using AI tools.
What if Analysis: Goal Seek, Data Table and Scenario Analysis. Lookup (VLookup, Hlookup, Xlookup) and other applications using AI tool. Introduction to Macros and Recording of Macros. Data Validation and Data Protection Power Query: Import, Transform, Clean, and Combine data.
Charts and Graphs: Gantt Chart, Pie Chart, Line chart, Area Chart, Bar Graph, Stacked Bar chart, Heatmap, Treemap, Spider Chart, Combo Chart, Donut Chart etc. Pivot Tables: Creation of pivot tables, Data Analysis and summarization, Filters in Pivot Table, Grouping of Data, Sorting, Calculations, Aggregate Functions, Pivot Charts Power Pivot. Dashboards Building in Excel: Fundamentals, designing and interactivity through slicers.
Basic Terminology of Stock and Commodity Market Trading: Retail Investors, Institutional Investors (FII and DII), Demat Account, Bid Price, Ask Price, Strike Price, Lot Size, Put option, Call Options, Margin Trading Facility, Future Trading, Expiry, Premium, Volatility, Liquidity, Stock Split, Bonus Issue, IPO Investment, Mutual Funds, ETFcs, Commodity Trading, Currency Trading, Understanding Trading Terminals etc.
Technical Analysis: Support and Resistance Lines, Trend Line, Doji, Hammer, Morning Star, Evening Star, Head & Shoulders, Inverse Head & Shoulders, Channels, Sideways Market, Breakout, E+C13MA, RSI, Bollinger Bands, Pivot Points, reading Open Interest data, Reading charts and indicators: When to Buy and When to Sell
Live Trading- Entry and Exit Decisions: Pre-Market Analysis, Global Market Analysis, Emotional Discipline, Trading Mindset, Patience and Consistency, Selecting Stocks, Selecting Commodities (Weekly and Monthly Expiry), Profit Booking Rules, Stop Loss, Trend Reversal, Buying Call Options, Buying Put Options, Gold Trading, Silver Trading, Crude Oil Trading, Natural Gas Trading, Intraday Commodity Trading.
Learn from leading experts in stem cell research
Dr. Sushant Gupta is an Associate Professor of Finance at the Mittal School of Business, Lovely Professional University (LPU). He has 30+ Publications. With more than 12 years of teaching, research, and academic experience, Dr. Sushant specializes in Financial Markets, Derivatives, Investment Analysis and F&O Trading.
Dr. Harpreet Singh Bedi is a Professor at the Mittal School of Business, Lovely Professional University, with over 2 decades of teaching experience. He holds a Gold Medal in MBA and has received the Academic Honour Award in PGDBM, along with a distinction in M. Com. Dr. Bedi is a certified professional in Microsoft Excel (by Microsoft) and Financial Modelling (by NSE, India). He specializes in Data Analysis and Data Visualization – Tableau and Power BI. He regularly conducts Executive Development Programs (EDPs) and Faculty Development Programs (FDPs) for various organizations and educational institutions.
Report of NIRF Data Capturing System: Management Report of NIRF Data Capturing System: Pharmacy Report of NIRF Data Capturing System: Engineering Report of NIRF Data Capturing System: Overall Report of NIRF Data Capturing System: Law Report of NIRF Data Capturing System: Architecture Report of NIRF Data Capturing System: Innovation Report of NIRF Data Capturing System: Agriculture Report of SDG Institution Report of NIRF Data Capturing System: Management Report of NIRF Data Capturing System: Pharmacy Report of NIRF Data Capturing System: Engineering Report of NIRF Data Capturing System: Overall Report of NIRF Data Capturing System: Law Report of NIRF Data Capturing System: Architecture Report of NIRF Data Capturing System: Agriculture
