Syste
m (Hardware/Software)
Requirements
Operating
Software | Windows XP or
Higher
| Processor | Minim
um P4 or Higher
| RAM | 1 GB or
Higher
| Browser | Any
| Recommended Internet
Speed | Minimum 1MBPS
| Supported Browser
Plug-ins | * Updated
Flash Player, * Update Java
| Other
Requirements | Speaker or
headphone | |
Prdocut DescriptionThis Program on VBA & Macros is well structured and strategically designed online training program for learning Microsoft Excel VBA & Macros. It is full of real world examples & useful theory. The aim of this program is to make a beginner start learning VBA & Macros from scratch.
When we have to make repetitive reports, dashboards or slides, when the work on excel sheet gets complex and repetitive, the most important solution would be to automate the worksheets and save a lot of time. By using Excel VBA, we can automate several areas of data analysis, reporting and modeling work. By using Excel VBA, we can cut down the time we spend repeating these steps and improve our productivity. The main goal of this course is to see how repetitive reports, dashboards or slides can be automated using the powerful tool called VBA & Macros.
This course on VBA & Macros is the 1st part of 2 parts in total. In this course you get access to some of our awesome VBA Macros videos which will help you to gain foundation knowledge over this most used spreadsheet software. This program includes introduction to VBA & macros, VBA Environment like project explorer, properties, Run break reset and design, debug etc, Macros with IF conditions, Data Filter, Charting using VBA and userform. You need to have basic excel knowledge to do well in this course
Note: Please note that VBA Macros course of eduCBA has two parts, Part 1 and Part 2. You may access Part 2 to here - VBA - Excel VBA and Macros (Part 2 of 2). We have also made a comprehensive course by including both parts in a single course. You may access Comprehensive Course link from here - VBA - Visual Basic and Macros Course (Part 1 & 2)
Instructor:Mr. Dheeraj V. (CFA, FRM, IIML, IITD)
Dheeraj, A financial wizard, His relentless pursuit of knowledge and financial acumen has made him one of the most sought after individual in the training circles. He was associated with J.P Morgan Chase Equity Research Group as an analyst and later moved to CLSA India (Asia's #1 Broking Firm) in the field of Equity Research and Investment Banking domain.
Course Curriculumection1:Introduction
Lecture1:Introduction
Section2:Portfolio Management Basic Concepts
Lecture2:Types of Investors and Characteristics
Lecture3:Steps in Portfolio Management
Lecture4:Mutual Funds
Lecture5:Example of a Bond Mutual Fund
Lecture6:Other forms of Pooled Investments
Section3:Portfolio Risk and Return
Lecture7:Portfolio Risk and Return
Lecture8:Money Weighted Return
Lecture9:Risk averse, seeking, tolerance, neutral
Lecture10:Portfolio Expected Return
Section4:concepts using Examples
Lecture11:concepts using Examples Part 1
Lecture12:concepts using Examples Part 2
Lecture13:concepts using Examples Part 3
Section5:Understanding CML
Lecture14:understanding CML Part 1
Lecture15:understanding CML Part 2
Section6:Leveraged Portfolio
Lecture16:leveraged portfolio Part-1
Lecture17:leveraged portfolio Part-2
Section7:Risk and Return
Lecture18:risk and return Part-1
Lecture19:risk and return Part-2
Section8:Beta
Lecture20:Beta
Section9:SML
Lecture21:SML Part 1
Lecture22:SML Part 2
Lecture23:SML Part 3
Section10:pricing of securities using SML
Lecture24:Pricing of securities using SML Part 1
Lecture25:Pricing of securities using SML Part 2
Lecture26:Pricing of securities using SML Part 3
Section11:Performance Measures
Lecture27:Performance Measures Part 1
Lecture28:Performance Measures Part 2
Lecture29:Performance Measures Part 3
Section12:Basics of portfolio planning and construction
Lecture30:IPS - part- 1
Lecture31:IPS - part- 2
Lecture32:IPS - part- 3
Lecture33:investment Constraints Part 1
Lecture34:investment Constraints Part 2
Lecture35:investment constraints Part 3
Lecture36:investment constraints Part 4
Lecture37:Example of IPS
Lecture38:Strategic asset Allocation Part 1
Lecture39:Strategic asset Allocation Part 2
Lecture40:Risk Budgeting
Section1:Introduction
Lecture1:Introduction
Section2:Financial Market
Lecture2:Financial Markets Role
Lecture3:Financial Markets Classification
Lecture4:Money Market and Capital Market
Section3:Capital Market
Lecture5:Capital Markets Classification
Lecture6:Equity Market, Debt Market, Derivative Market
Lecture7:Capital Market Instruements
Lecture8:Equity Shares Characteristics
Section4:Equity for Issuer and Investor
Lecture9:Advantsges of Equity for Issuer
Lecture10:Advantages of Equity for Investor
Lecture11:Disadvantages of Equity for Issuer
Lecture12:Disadvantages for Issuer continues
Section5:Preference Shares
Lecture13:Preference Shares
Lecture14:Preference Shares Characterstics
Lecture15:Preference Shares Advantages for Issuer and Investor
Lecture16:Disadvantages for Issuer and Investor
Lecture17:Preference Shares Types
Lecture18:Cumulative, Non-cumulative, Callable, Adjustable Rate Preference Shares
Benefits
eduCBA e-campus
Virtual campus powered by robust LMS which enables to study through internet with cutting edge features
Online Video Training Material
Presentation Slides
USP of the product
* 24 x 7 online access* Learn from tutorials curated by expert industry professionals and trainers* Certificate of Completion* Practical application oriented skillsHow to use? (Steps to use Study Material)
Step 1 - eduCBA sends the redemption coupon along with the registration link. Step 2 - Student will register with his register email id and coupon Step 3 - Student receive the course access and password on his/her email idStep 4 - Login using your email id and password and start learningTo get more information, you may want to watch the video below
Learn Everything, Anywhere, Anytime
India's Largest Online Education Marketplace