Full Technical Index

Finance & Operations

Amortization Tables PMT Loan Calculations NPER / Loan Payoff NPV, IRR & ROI One-Way Data Tables Two-Way Data Tables VLOOKUP Essentials Pivot Table Intro Optimization w/ Solver Transportation Networks Portfolio Optimization Portfolio Variance Reinvesting Dividends Value at Risk (VaR) Option Valuation (MCS) Monte Carlo w/ @Risk Monte Carlo Stock Portfolio

Statistics

Confidence Intervals Correlation Analysis Correlation Matrix Descriptive Stats T-Test Functions TDIST Function Independent Samples T-Test Paired Samples T-Test Linear Regression Linear Regression Shortcuts Scatter Plot Interpretation

Forecasting

Moving Averages Weighted Moving Averages Exponential Smoothing Theil's U

Core & Tools

OOP Foundations Pipenv Environments Reading CSV Files Matplotlib Viz Streamlit Web Apps Number Guessing Game Animated Graphics (Turtle)

Data & Analysis

Data Analysis Workflow NumPy Basics NumPy Financial Pandas DataFrames Rolling Methods Correlation Analysis Linear Regression Monte Carlo Simulation Loan Analysis Project

Finance & Trading

Algo Trading Intro Mean Reversion Logic Alpha Vantage API EOD Historical Data API pandas-datareader / Yahoo Portfolio Variance Quantitative Stock Analysis Stock Price Analysis

MySQL

Basic Queries Create Schema / Database Joins (Inner/Outer) Subqueries ERD Diagrams CASE WHEN / IF Foreign Keys Statistics Functions Text Functions

R Language

Correlation & Matrix Data Analysis R in Jupyter Two-Tail Testing

SPSS

Control Charts Descriptive Statistics Linear Regression Paired Samples T-Test

Minitab

Paired Samples T-Test

Systems

CLI: Top 10 Commands