Excel For Data Analytics
May 29, 2025 at 01:11 PM
*Quick Excel Cheatsheet*! 📊
*Basic Formulas*
1. Add: `=A1+B1`
2. Subtract: `=A1-B1`
3. Multiply: `=A1*B1`
4. Divide: `=A1/B1`
5. Average: `=AVERAGE(A1:A10)`
6. Sum: `=SUM(A1:A10)`
*Logical Functions*
1. IF: `=IF(A1>10, "Yes", "No")`
2. AND: `=AND(A1>5, B1<10)`
3. OR: `=OR(A1=1, B1=2)`
4. EXACT (case-sensitive match): `=EXACT(A1, B1)`
*Lookup Functions*
1. VLOOKUP: `=VLOOKUP(A1, Table, 2, FALSE)`
2. HLOOKUP: `=HLOOKUP(A1, Table, 2, FALSE)`
3. XLOOKUP: `=XLOOKUP(A1, Range1, Range2)`
*Counting & Data Types*
1. Count numbers: `=COUNT(A1:A10)`
2. Count non-empty: `=COUNTA(A1:A10)`
3. Count blanks: `=COUNTBLANK(A1:A10)`
4. Is number: `=ISNUMBER(A1)`
5. Is text: `=ISTEXT(A1)`
*React ❤️ for more*
❤️
❤
👍
🥰
😮
💗
💜
💖
😂
😌
271