Advance Excel for stock market
Course Description
Microsoft Excel is perhaps the most important software programme being used today.It has become a neccessity in both business and professional life, irrespective of the role the hierachy, the business function or the industry.This course has been designed in such a way so as to enable the students to gain a complete understanding on the advanced excel concepts and apply such concepts to their relevant role and business.
- Students
- Teachers
- Investors
- Employees of BPOs/IT Companies
- Employees of Brokers/Sub-Brokers
- Housewives
- Anybody having interest in the Indian securities market
- Writing conditional expressions (using IF)
- Using logical functions (AND, OR, NOT)
- Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
- VlookUP with Exact Match, Approximate Match
- Nested VlookUP with Exact Match
- VlookUP with Tables, Dynamic Ranges
- Nested VlookUP with Exact Match
- Using VLookUP to consolidate Data from Multiple Sheets
- Specifying a valid range of values for a cell
- Specifying a list of valid values for a cell
- Specifying custom validations based on formula for a cell
- Designing the structure of a template
- Using templates for standardization of worksheets
- Sorting tables
- Using multiple-level sorting
- Using custom sorting
- Filtering data for selected view (AutoFilter)
- Using filter options
- Creating subtotals
- Multiple-level subtotals
- Creating Pivot tables
- Formatting and customizing Pivot tables
- Using options of Pivot tables
- Pivot charts
- Consolidating data from multiple sheets and files using Pivot tables
- Using external data sources
- Using data consolidation feature to consolidate data
- Show Value As ( % of Row, % of Column, Running Total, Compare with Specific field)
- Viewing Subtotal under Pivot
- Creating Slicers ( Version 2010 & Above)
- Date and time functions
- Text functions
- Database functions
- Power Functions (CountIf, CountIFS, SumIF, SumIfS)
- Using auto formatting option for worksheets
- Using conditional formatting option for rows, columns and cells
- Relative & Absolute Macros
- Editing Macro’s
- Goal Seek
- Data Tables
- Scenario Manager
- Using Charts
- Formatting Charts
- Using 3D Graphs
- Using Bar and Line Chart together
- Using Secondary Axis in Graphs
- Sharing Charts with PowerPoint / MS Word, Dynamically
- (Data Modified in Excel, Chart would automatically get updated)
- Sparklines, Inline Charts, data Charts
- Overview of all the new features
- The Final Assignment would test contains questions to be solved at the end of the Course
Course Info
- Duration: 18 hours (Each session for 2 hours)
- Prerequisites: No
- Batch Capacity: Max 5 Students
- Certificate: Yes
About Instructor
Mr Masum
With over 11 years of experience in Financial and stock market, Mr Masum Choudhury has trained many students in stock trading trough his various workshops. He trades actively and training is his passion. He has a very keen interest in Forex trading and working as a consultant for various export houses guiding them on exchange. He handled the portfolio worth $6 lakhs and managed it successfully. He actively trains in various corporate.
Mr Masum
Stock Market Investing
I was looking for a platform which gives me second source of income. When I get contacted by him he helped me to understand the basics of stocks market. As I was new, I am not aware about Demat A/c, what is stocks & investment.. but here I got to know each & everything in proper manner. As a mentor he helped me to open Demat a/c & giving the detailed knowledge about stock investing & their variants. so by his good support & guidance now I am able to choose the stocks for investment. All thanks goes to Mr. Masum sir and what he taught me about fundamental analysis.