Master-Excel

To record the process of learning Excel.

Catalog:

📁Microsoft Excel - Advanced Excel Formulas & Functions

• 📁Section2-Formula101

  • 📄 Formula101.md

    • 1.Formula Syntax
    • 2.Reference Types
    • 3.Common Error Types
    • 4.Auditing Tools
    • 5.Ctrl Shortcuts
    • 6.Function Shortcuts
    • 7.Alt Key Tips
    • 8.Data Validation

  • 📊Section2_Formulas101.xlsx

• 📁Section3-Conditional Statements & Logical Operators

  • 📄 Conditional Statements & Logical Operators.md

    • 1.IF Statement
    • 2.Nested IF Statement
    • 3.Conditional AND/OR Operators
    • 4.NOT & <>
    • 5.IFERROR
    • 6.IS Statement

  • 📊Section3_Logical_Operators.xlsx

• 📁Section4-Common Excel Statistical Functions

  • 📄 Common Excel Statistical Functions.md

    • 1.Basic Statistical Functions
    • 2.SMALL/LARGE & RANK/PERCENTRANK
    • 3.RAND() & RANDBETWEEN
    • 4.SUMPRODUCT
    • 5.COUNTIF/SUMIF/AVERAGEIF

  • 📊Section4_Statistical_Functions.xlsx

Resources:

🖥️Microsoft Excel - Advanced Excel Formulas & Functions