Beginner in Cryptocurrency.
TECHNICAL ANALYSIS/ STRATEGIES
Who will benefit from this course?
- Students
- Teachers
- Investors
- Employees of BPOs/ITCompanies
- Employees o Brokers/Sub-Brokers
- Housewives
- Anybody having
- interest in the Indian securities market
The course is designed to understand the basic concepts relating to different avenues of investment, the primary and the secondary market,
Absolute and relative cells
- Protecting and un-protecting worksheets and cells
Working with Functions
- Writing conditional expressions (using IF)
- Using logical functions (AND, OR, NOT)
- Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
- o 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
Data Validations
- 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
Working with Templates
- Designing the structure of a template
- Using templates for standardization of worksheets
Sorting and Filtering Data
- Sorting tables
- Using multiple-level sorting
- Using custom sorting
- Filtering data for selected view (AutoFilter)
- Using filter options
Formatting
- Using auto formatting option for worksheets
- Using conditional formatting option for rows, columns and cells
Macros
- Relative & Absolute Macros
- By- Masum Choudhury Editing Macro’s
Working with Reports
- Creating subtotals
- Multiple-level subtotals
- Creating Pivot tables
- Formatting and customizing Pivot tables
- Using options of Pivot tables
o 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)
More Functions
- Date and time functions
- Text functions
- Database functions
- Power Functions (CountIf, CountIFS, SumIF, SumIfS)
WhatIf Analysis
- Goal Seek
- Data Tables
- Scenario Manager
Charts
- 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)
New Features Of Excel
- Sparklines, Inline Charts, data Charts
- Overview of all the new features
Final Assignment
- o The Final Assignment would test contains questions to be solved at
the end of the Course
After successful purchase, this item would be added to your Library.
You can access the library in the following ways :
- From Computer, you can access your library after successful login
- For other devices, you can access your library using this web app through browser of your device.
Duration- 20 hours
Mode of Delivery: Live via Zoom or Offline at Institute
Cost : ₹ 8,000 ₹ 6,000 /-
Benefits of doing Advance course
- Learn Chart Patterns.
- Covers Most Aspects.
- Helpful In Long-Term Investment.
- Certification Course.
Quick Enquiry
Duration - 5 Hours for 2 days
Cost : ₹ 8,000 ₹ 6,000 /-
Practical and live market support will be given after the course is completed.
Benefits of an Forex Trader Course
1. Covers Most Aspects
Mintinternationals Academy covers most aspects of share market education in the Advance course. This course teaches you not to overlook any factor affecting your returns from the investment. From opening a demat account to make quick money to fundamental analysis to money management, we have got your back.
2. Factors Influencing the Stock Market
You also learn about the factors influencing the stock market, important applications and sites, technical analysis, the derivatives market, and more.
3. Predetermine Price Action Movement
It helps you predetermine the price action movement of the stock.
4. Personal Attention From Our Trainers
Moreover, personal attention from our trainers helps you eliminate your misconceptions and get on the right track.
5. Understand Tedious Stock Market Concepts
Our advanced course in stock market training brings new and tedious stock market concepts before you that you must not have heard of. It is how we try to offer the best stock trading courses in India. However, it is not a complete stock market course. Thus, our remaining courses teach you A to Z of the share market.
You may join our advance course if:
- You are not aware of all important terms related to the share market.
- You want to analyze the chart patterns or candlestick patterns, but you do not know how to do it.
- You want to explore various types of investments and choose the right one according to your requirements.
- You want to make quick money in stock market and have patience.
- You want to know various market indicators and avoid common mistakes.
- You want proper guidance over industry, economic, technical, and company analysis.
- You are passionate enough to offer time and the right cost for the course.
- You will either find an appropriate broker according to your requirements or become one.
- Numerous topics are covered in this course, which will help you be a stock market trainer or an investment banker.
- Work on a financial risk portfolio for two years and become a Financial Risk Manager (FRM).
- Purchase stocks from other investors or directly from the company.
- Be a stock market trader.
“Trusted by over 3,500 students since 2017. Lifetime support and a hands-on approach to stock trading.
Links
Class
Contact
Call Us
+91 88 50 900 539
Email Address
masum@mintinternationals.com
Reach Us
Office No : I-113, Latif Park, near S.k Stone Signal, Poonam Gardans, Chandan Shanti, Mira Road East, Mira Bhayandar, Maharashtra 401107
Mintinternationals©All rights reserved Copyrights 2025
