Brand Waali Quality, Bazaar Waali Deal!
Impact@Snapdeal
Gift Cards
Help Center
Sell On Snapdeal
Download App
Cart
Sign In

Sorry! VBA - Visual Basic and Macros Course (Part 1 and 2) (e-Certificate Course)-Online Video Training Material, Technical Support, Verifiable Certificate is sold out.

Compare Products
Clear All
Let's Compare!

VBA - Visual Basic and Macros Course (Part 1 and 2) (e-Certificate Course)-Online Video Training Material, Technical Support, Verifiable Certificate

This product has been sold out
(4.4) 8 Ratings 3 Reviews Have a question?

We will let you know when in stock
notify me

Featured

Highlights

  • Delivery via E-mail
    Non-Cancellable
    No Physical Dispatch
  • Stream:MS Office
  • Certification:Yes
  • Language:English
  • Format:Online Study Material
  • SUPC: SDL603757304

Description


 Syste m (Hardware/Software) Requirements
Operating SoftwareWindows XP or Higher
ProcessorMinim um P4 or Higher
RAM1 GB or Higher
BrowserAny
Recommended Internet SpeedMinimum 1MBPS
Supported Browser Plug-ins* Updated Flash Player, * Update Java
Other RequirementsSpeaker or headphone
Prdocut Description
This 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 skills

    How 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 id
  • Step 4 - Login using your email id and password and start learning

    To get more information, you may want to watch the video below


    Learn Everything, Anywhere, Anytime
    India's Largest Online Education Marketplace
  • Terms & Conditions

    The images represent actual product though color of the image and product may slightly differ.