Microsoft excel and VBA Programming

643 STUDENTS ENROLLED

The objective is to introduce students with comprehensive aspects of Algorithmic Trading and execution. It is designed for both buy and sell-side industry. This course involves a top-down approach to Algorithmic Trading, in which we will equip students with the identification of target markets and trading styles for Algorithmic Trading, identified the factors driving the growth of electronic trading with an overview of Electronic and Algorithmic Trading, designing trading strategies and their algorithmic components.

Students also get opportunity to work on trading terminals, learn infrastructure requirements, techniques of risk management and portfolio improvement and business strategies to protect the combative provide in Algorithmic Trading.

Students/Corporate cover courses in finance, financial economics, financial econometrics, financial mathematics, stochastic calculus, numerical methods, monte carlo simulation, derivatives modelling, portfolio theory, portfolio optimization, performance analysis and financial risk analysis. You instruct to write financial applications and derivative modelling programs in VBA / C++, C# Sharp, Easy language making use of the theories and methods you have learned. You get hands-on learning session on the commercial Financial Software applications from Thomson Reuters. You also acquire to do assets financial modelling using the advanced features of Excel.

Course Curriculum

Introduction
Introduction to EXCEL 00:00:00
Formatting a Workbook 00:00:00
Working with Formulas and Functions 00:00:00
Working with Charts and Graphics 00:00:00
Working with Excel Tables, Pivot Tables, and Pivot Charts 00:00:00
Managing Multiple Worksheets and Workbooks 00:00:00
Using Advanced Functions, Conditional Formatting, and Filter 00:00:00
Developing an Excel Application 00:00:00
Developing a Financial Analysis 00:00:00
Performing What-If Analyses 00:00:00
Connecting to External Data 00:00:00
Expanding Excel with Visual Basic for Applications (Excel 1) 00:00:00
Expanding Excel with Visual Basic for Applications (Excel 2 VBA) 00:00:00
VBA programming
INTRODUCTION TO EXCEL VBA 00:00:00
EXCEL VBA OBJECTS 00:00:00
LOOPS 00:00:00
SELECT CASE END SELECT 00:00:00
USING DECISION STATEMENT IN VBA 00:00:00
Excel VBA quiz 00:10:00

Course Reviews

4.5

4.5
97 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
Clear
SUBSCRIPTION FOR 2 months
  •  1,990 9,990 per 60 days
  • 4 weeks, 2 days
  • Course Badge
  • Course Certificate

Courses

Current job opportunity

All rights reserved @ www.modrika.com 2017