About Me:
I have Developed various passive courses in Data Analytics and have connections and linkages to an efficient network (of tutors) in USA and India for best results for our global learners.
What Differentiate US with Them?
Our training theme is centered around PROJECTS! for example, your portfolio or even themes you are doing at work. This is very different from the repetitive courses given by other tutors with a fixed syllabus. The outcome of such engagement is a product you can use.
I connect you to the right tutors in NYC – with the right content – supported by an offshore team.
My Qualifications –
I am an Electrical Engineering graduate, GAARP-FRM certified, PG Diploma in Financial Analysis and Risk Management, PG Diploma in IT, CFA L1, International – MBA, MS IT.
Courses that I learned during Grad (year 2011) include Financial Modeling using Excel, CFA L1 and L2, VBA for Financial Modeling, Excel for Equity modeling, Excel for Risk Management among other subjects.
In engineering I did my thesis on “Risk modeling on MATLAB for design”. I have gained Practical (first hand) experience, in what I teach, during Bank Job among others. I enjoy descent balance of academics and profession as I am a very easy going person.
My Experience –
I have experience of tutoring Analytics using SQL, Excel, VBA, Python, R and matlab for Financial, risk, trading, and other applications. MATLAB for Finance has been My Flagship course with my last organization.
Earlier in my career I have worked and also developed several passive recorded courses in analytics. I have developed courses on Excel optimization to make Excel programming more robust and make excel do the best for you.
Why Me?
1. Seven years of Tutoring experience with various organizations.
2. Have learned Analytics from practical experience in various banks and companies.
3. My online courses on Wiziq had several hundred registrants.
4. My extensive experience from banks and tutoring helps me to tutor programming in a very relaxed and easy going manner.
5. VBA Python R Excel SAS SQL using learning from both worlds.
6. Quant Finance, CFA Quant, FRM Qannt courses taught with the help of Excel.
7. I have taught at various top coding Boot camps.
8. Have an Off shore team based out of India to support your questions that I might not be able to answer.
Subject areas I have tutored in the past includes: Quantitative Methods for GRE / SAT / GMAT, CFA L1, FRM L1, matlab/R/SPSS for Quant, Excel-VBA Programming, Quantitiative and Analytics Excel programming & VBA programming.
I help excel users to do the below in Python:
1. Basics of Excel -Vlookups, Hlookups, Index Match, Dependents, Data tables (1 way and 2 ways), Pivots, Charting, Filters, SQL integration, VBA coding, Address and indirect, Offset, Array functions, etc.
2. Applications – Regression, Histograms, Monte carlo simulation, rank correlation, dashboards and more.
3. Automation using VBA – Loops (for, do while, case), Recorder, Arrays and Matrices, if else, indexing, etc.
Introductory Session
● Macros / VBA
● What are Macros?
● What is VBA?
● How to record macros?
● How to run macros?
● VBA Editor
● Modules
● Procedures
● Project Explorer
● Toolbars / Options
● Creating / Editing Code
● Create Procedures
● Subs
● Comments
● Invoking Macros
● Hot Keys
● Quick Access Toolbar
● Call Command
● Compiling Code
● Stepping through code
● Reset Run
● Variables
● Declarations
● Option Explicit
● Data Types
● Working with The Object Model
● Ranges: Rows, Columns, Cells
● Creating & Naming Objects
● Naming conventions
● Navigation / Selection Techniques
● Offsets
● Range Names
● Logic Statements
● IF Statements
● Looping Statements
● Do Loops
● Error Handlers
● Preventing fatal errors and crashes
Excel Functions
1. Freezing & Dragging
2. Lookups
3. Index Match
4. Data Tables
5. Address Indirect
6. String Functions
Statistical Functions in Excel
● Histograms, Frequency, Bar Charts
● Secondary Index on a chart
● Charts from Pivot table
● Normal Distribution
● Financial Functions Time value of Money, Loan amortization
VBA
● Decision Control: If/Then/Else and Select Case
● Recording Macros
● User Defined Functions and Workbook Events
● Call Excel Functions and Write New Functions
Data Cleaning
1) Backfill / forward fill / median
2) Missing numbers
3) Black or blank formula
4) Last/First value in a range
Regression and Logistic Regression
❏ Regression File
❏ Fitting the line manually
❏ Scaling for Logistic Regression
❏ Logistic Regression – Google Spreadsheets
Pivot Tables
★ Recreate
★ Refresh
★ Change rows and columns
Addins
➔ Adding add ins in excel file
➔ Removing an add in
➔ Simple events
Four Projects of The Course
1. Multiple Linear Regression
2. Logistic Regression
3. Monte Carlo Simulation (AR1)
4. Scraping data from Yahoo Finance
5. Data Cleaning and Wrangling
6. VBA Utility Functions – Plugin
Course Outcomes
➢ Macros vs Excel Formulas: Strengths and Weaknesses: When to avoid VBA and do it in
excel?
➢ Introduction to VBA and Recording Macros.
➢ Writing VBA Code – Introduction to Variables, Decision and Looping Controls.
➢ Graceful Error Handling using ON ERROR.
➢ Create User Defined Functions and Workbook Events.
➢ Object Variables, Array Variables, Indefinite Loops.
➢ Use the models in the class at your workplace.
Things that you will learn….
➔ How to Debug and Fix Macros, How to Handle Errors
➔ How to use Variables and Arrays
➔ How to Write Programs With the Visual Basic Editor
➔ Programming Control Structures
➔ Decision Control: If/Then/Else and Select Case
➔ Flow Control: For/Next, Do While, For Each
➔ How to Call Excel Functions and Write New Functions
➔ How to Call Excel Dialogs
Upon successful completion of this course, students will be able to:
➔ Run Multiple Regression, Logistic Regression and Monte Carlo Simulation in Excel.
➔ Develop a macro
➔ Format worksheets using macros
➔ Create an interactive worksheet
➔ Work with multiple worksheets
➔ Import from different files
Github Portfolio
1. Regression Model
2. Monte Carlo Model
3. Logistic Regression
Sample Job Roles
● Lead – Financial Planning & Analysis
● Analyst Financial Modeling
● Financial Analyst
● Financial Modeling & Forecasting
SO WHAT YOU ARE WAITING FOR???? CONTACT NOW!!!
Instructor:
Shivgan Joshi
Dr Vora 312) 285–6886
Linkedin (Instructor): https://www.linkedin.com/in/shivganjoshi/
Udemy: https://www.udemy.com/user/shivganjoshi2/
Dr. A Vora
Email us at: avora@mtu.edu
Or Call Us at : +1 31228 56886
- do NOT contact me with unsolicited services or offers