Learn in-demand skills practically from experienced industry professionals and move a step closer to accomplish your dream career.
MS Office is used by over 1 Billion professionals worldwide. Leapfrog 99% MS Office users worldwide by learning the most useful and advanced functions including ChatGPT and AI in-built in MS Office and unlock better jobs, internships and profiles.
Module 1 – Basic and Advanced Functions of MS Excel
Module 2 – Data Analysis with Pivot Tables and other Advanced Tools
Module 3 – Convert your Analysis into a Storyboard with Charts and Powerpoint
Module 4 – ChatGPT to unlock unreal productivity levels strategies
BATCH COMMENCEMENT DATE – 29th May ’23
BATCH END DATE – 30th June ’23
Live Doubt Solving on Saturdays from 5pm to 6pm
Learn the building blocks of stock markets and get familiar with the tools and skills used by professional traders, analysts and investors to unlock a promising career in finance
Module 1 – Market Micro structure and Jargons
Module 2 – Tools to Trade Professionally – Technical Analysis
Module 3 – Tools to Invest Professionally – Fundamental Analysis
Module 4 – Building basic trading and investment strategies
BATCH COMMENCEMENT DATE – 29th May ’23
BATCH END DATE – 30th June ’23
Live Doubt Solving on Thursdays from 6pm to 7pm
Become proficient in building financial models and learn to apply multiples based valuation technique for real life business scenarios
Module 1 – Historical Financial Statements
Module 2 – Projecting & Presenting Future Models
Module 3 – Analyzing data and Rationalizing Assumptions
Module 4 – Valuation Techniques
BATCH COMMENCEMENT DATE – 29th May ’23
BATCH END DATE – 30th June ’23
Live Doubt Solving on Tuesdays from 9pm to 10pm
All courses will be 4 weeks, 30 hours including pre-recorded content, live sessions and assignments. Certificates will be issued on the basis of MCQ based test results at the end of the course.
Yes, the live doubt solvings are at different timings so that students are able to enroll for both the courses too. Also the approximate time commitment per week per course is 7-10 hours. This allows the students to have enough time to learn and practice both the courses.
You can contact team Leapup at info@jzedutech.com
Both the courses are completely online enabling students to access them from any location.
The Live doubt solving lectures will be conducted on Zoom.
Yes, the fees are inclusive of GST.
Students will have 3 months access to the course. They have to complete the course within 3 months and appear for the test to receive the completion certificate. (Ideal completion time suggested by us in 1 month).
[ 15 Hours Self Paced Video | 5 Hours Live Session | 10 Hours Practice Assignments ]
To make students proficient in MS office and make them job ready by leveraging advanced MS Office tools as well as ChatGPT and AI.
1. Excel Basics
• Cell and References
• Formatting of cells
• Conditional Formatting
• Data Types
2. Basic and Advanced Excel Functions
• Mathematical Functions
• Data Tables
• Lookup / Index / Match
• Text Functions
• Statistical Functions
• Date and Time Functions
• If and Nested If Functions
• Financial Functions
• Get Data Functions
3. Data Analysis and Charts
• Data Analysis Tools
• What-If Analysis
• Pivot Tables
• Slicers and Filters
• Basic Charts
• Composite Charts
• Advanced Charts
• Formatting a Chart
4. Powerpoint Basics
• Slide Formats
• Formatting Text and Images
• Transitions and Effects
• Importing Data and Charts
• Presentation Tools
5. Storyboard
• Creating an effective slide
• Creating a narrative with data
• Story vs Numbers
• Completing your story board
6. ChatGPT and AI with MS Office
• Installing ChatGPT Bot in MS Office
• Examples of various use-cases
• Creating complex excel functions
• Creating effective content
Trading & Investing
[ 15 Hours Self Paced Video | 5 Hours Live Session | 10 Hours Practice Assignments ]
To provide students with an overview of all aspects of sotck markets, trading and investments and inculcate basic skills and knowledge to forge a successful career.
1. Time Value of Money & Compounding
• Insights about Compounding
• Rule of 72
• Time Value of Money
• Inflation
2. Equity Market Basics
• Market Microstructure
• Operating a Trading Account
• Overview of Asset Classes / Investment Vehicles
• Pros and Cons of each asset class
3. Introduction to Technical Analysis
• Meaning
• Basic Assumptions
• Pros & Cons
• Chart Construction
• Support & Resistance
• Trends & Trendlines
• 3 Basic Indicators
4. Introduction to Fundamental Analysis
• Meaning
• Basic Assumptions
• Pros & Cons
• Business Model Analysis
• Sector Analysis
• Headwinds & Tailwinds
• Concept of Moats
• Market Multiples
5. Trading vs Investing
• Psychology
• Skills
• Success Stories
6. Components of a trading system
• Entry Rules
• Exit Rules
• Stop Losses
• Trailing Stops
• Risk Management
7. Execution of a trading system
• Limit and Market Orders
• Bracket Orders
• MIS / Intraday / NRML / Delivery
• GTT Orders
• Algo based execution
8. Behavioural Finance
• Top 10 mistakes made by beginners
• Trading and Investing Biases
• Top scams of Indian stock markets and what we can learn from them
[ 10 Hours Self Paced Video | 5 Hours Live Session | 15 Hours Practice Assignments ]
To make students proficient in building financial models and apply multiples based valuation technique for real life business scenarios.
1. Historical Financial Statements
• Create customized Model Templates
• Input Historical P&L Statement
• Input Historical Balance Sheet
• Input Historical Cash Flow
• Calculate Financial Ratios
• Input Important Schedules
• Input key operational data
• Calculating Unit Economics
2. Future Projections – 1
• Projecting Fixed Asset Schedule
• Projecting Debt Schedule
• Projecting Equity Schedule
• Deciding Key Drivers for Forecasting
• Forecasting P&L Statement
3. Future Projections – 2
• Forecasting Balance Sheet
• Forecasting Cash Flow
• Debugging the model
4. Model Presentation
• Formatting like a professional
• Creating the right charts and graphs for analysis
5. Analysis and Assumptions
• Analysing past trends in financial statements
• Analysing future strategy
• Analysing Headwinds and Tailwinds
• Tweaking key assumptions
• Principle of Conservatism
6. Valuation
• Principles of Valuation
• Multiples based Valuation (Market Approach)
• Choosing the right valuation metric
• Re-rating & De-rating Concepts
• Sensitivity Analysis
7. Case Studies & Assignments
• Complete Financial Model of Listed Indian Manufacturing Company including a Market Based Valuation