Dear Friends
Welcome to the "Learn a new course every week" series of PACEgurus. Every week we conduct one Live Online training in one of the areas (Finance, Investment, Risk Management, Actuaries, Business Analytics, Statistics) using EXCEL, SPSS, R, VBA and Tableau. All the courses are taken by VAMSIDHAR AMBATIPUDI
Pedagogy: Data sets would be taken and the relevant tools and techniques would be applied, interpreted and the corresponding concepts are explained. So the 20 hours you spend will be completely practical in nature.
Multivariate Analytics using SPSS (20 Hours)
Timings: 4-Jan-2016 to 10-Jan-2016
6:30pm IST – 9:30pm IST
Fee: INR 12,000/$249
Topics Covered
Multivariate
Distributions
|
Multiple
Regression
|
Principal
Component Analysis
|
Factor
Analysis
|
Cluster Analysis
|
Discriminant Analysis
|
Logistic
Regression
|
Correspondence Analysis
|
Canonical Correlation Analysis
|
Multi-Dimensional
Scaling
|
Conjoint Analysis
|
Multinomial Logistic regression
|
Financial Statement Analysis using EXCEL (20 Hours)
Timings: 11-Jan-2016 to 17-Jan-2016
6:30pm IST – 9:30pm IST
Fee: INR 12,000/$249
Topics Covered
Income
Statement
|
Balance Sheet
|
Cash Flow
Statement
|
Ratio
Analysis
|
Comparing Financial Statements
|
Financial Activities – Debt, Leases, Post –
retirement
|
Share-holders
Equity
|
Investment Activities – Inventories, Long Term Assets, Intangibles
|
Investment Activities – Inter-corporate Investments, Derivatives
|
Operating
Activities – Revenue Recognition, Interest, Taxes
|
Cash Flow Analysis
|
Du-Pont Analysis
|
Basic Statistics using R (20 Hours)
Timings: 18-Jan-2016 to 24-Jan-2016
6:30pm IST – 9:30pm IST
Fee: INR 12,000/$249
Topics Covered
Overview of R,
Reading data into R
|
Key
constructs in R
|
Data Frames,
Vectors, lists, matrices, factors
|
Central
Tendency, Dispersion, Skewness
|
Covariance and Correlation
|
One sample and two sample t-tests
|
Basic Non
parametric Tests
|
Linear Regression
|
One way ANOVA
|
Probability
Distributions – Normal, Binomial
|
Basic Charts – Bar, Line, Scatter, Histogram
|
|
Macro Programming using VBA (20 Hours)
Timings: 25-Jan-2016 to 31-Jan-2016
6:30pm IST – 9:30pm IST
Fee: INR 12,000/$249
Topics Covered
Macro
Recording and code reading
|
VB Editor,
Object oriented programming
|
Variables,
Data Types, Collections, Objects
|
Working with
Ranges
|
Loops – Do Until, Do While, For Next
|
Decisions – If then Else, Choose
|
Using EXCEL
Formulas
|
Working with Arrays
|
Working with Work Sheets
|
Working with
Workbooks
|
User forms and Controls
|
Working with Pivot Tables
|
Working with Charts
|
User defined functions
|
Addins
|