Reference:

https://exceljet.net/excel-functions/excel-sumifs-function

Contents

• Anchoring

• Common Functions:

  nested IFS, VLOOKUP, HLOOKUP, OFFSET, MATCH, INDEX, COUNTIFS, SUMIFS

• Financial Functions:

  PV, FV, RATE,NPV, IRR, SUMPRODUCT, FVSCHEDULE, CORREL

• Conditional Formatting

• Pivot Table

• Balance Sheet

• Interactive Dashboard(Data Visulization)

• Excel Solver

• Macros, VBA

• Linear Regression Analysis

  Univariate Analysis, Outlier Treatment, Missing Value Imputation, Identifying and treating missing values, Variable Transformation, Correlation Analysis.