Excel Skills for Financial Modeling:
Financial Statements: Recognition, measurement, valuation, and disclosure
Navigating Excel with keyboard shortcuts
Data Sorting and Advanced Filtering
Freezing cells, rows, and columns for easier navigation
Enhancing data with conditional formatting for visual appeal
Building linkages for effective Financial Modeling
Basic Excel formulas: SUM, PRODUCT, DIVISION, MULTIPLICATION, PASTE SPECIAL, CONCATENATE
VLOOKUP and HLOOKUP for data retrieval
MATCH function for precise data location
Combining functions: VLOOKUP + MATCH, INDEX + MATCH, VLOOKUP + IF
Calculating CAGR
Using the TRANSPOSE function
IF function for conditional statements
Table and Pivot Table functionalities
Calculating IRR
Cell Referencing for dynamic models
Financial formulas, e.g., EMI calculator
Conditional formulas: SUMIF, COUNTIF, SUMIFS
SUMPRODUCT for array calculations
Advanced VLOOKUP applications