Financial Analysis Using Excel VBA

This is the set of slides that is for a short course on Excel VBA focusing on financial analysis. It consists of three parts: Excel, VBA Basic, and VBA programming,

Youtube video is freely available as below. For the slides used in the video, you may download for free by choosing the zero price. If you want to buy me a coffee, name your own price. 

1) Excel Spreadsheet

   Introduction: https://youtu.be/-N-aqfuMuas

   Basics Operation: https://youtu.be/Qy-Bl_gWRKI

   Sum SumProduct Average: https://youtu.be/WmHTKO7OHpw

   Math and Stat Functions: https://youtu.be/btcb-j-wrXg

   Condition: https://youtu.be/ie4NDK_sROo

   Combine Conditions: https://youtu.be/o770VExsSiI

   Vlookup: https://youtu.be/LswL0tvxxBI

   Offset: https://youtu.be/b5U7x4iuwQs

   Filter and Subtotal: https://youtu.be/pFp2pJPkOJo

   Pivot Table: https://youtu.be/i3VmPzcYnMg

   Text Functions: https://youtu.be/HQW2l9x6ZO8

   Addin - Analysis Toolpak: https://youtu.be/Klr0RNE90g0

   Addin - Solver: https://youtu.be/NQ6KqRxqNPc

2) Excel VBA

   Introduction: https://youtu.be/oqr-LHptK4M

   Editor: https://youtu.be/1yuREZgjbTs

   Hello World Subroutine: https://youtu.be/-U_PWB2SljQ

   ABC Function: https://youtu.be/g4Bq8QnThxM

   EMA: https://youtu.be/ODH_pvw9GXI

   VBA Object: https://youtu.be/uJj2SvK2PlA

   Range: https://youtu.be/cvzV-VMOOUE

   Application: https://youtu.be/dz_zVafkoEQ

   Record Macro: https://youtu.be/yZsul8ZGr6k

3) Excel VBA Programming

   Introduction: https://youtu.be/3LPJHIgowZA

   Conditional If: https://youtu.be/XE97Zp6Lfsw

   PassFail: https://youtu.be/DXsGKWHlaO4

   Grading: https://youtu.be/HuI5yLVcQmI

   Select Case: https://youtu.be/J9PM_dtGJwA

   SMA: https://youtu.be/bNkwZ43jmnk

   SMA Rule: https://youtu.be/wAueYfvVz-4

   While Loop: https://youtu.be/GCg2ZIqYOYQ

   For loop: https://youtu.be/Zuqbz7891hA

   RSI: https://youtu.be/6f4x3vG3SwI

   Array Function: https://youtu.be/bZdvrb2YFhM

   Bollinger Bands: https://youtu.be/9axN5z44bNo