1. Merging Cells
- Breaks sorting and filtering
- Causes errors in formulas
- Use Center Across Selection instead
- Keeps data structure clean
2. Hardcoding Values in Formulas
- Makes spreadsheets static
- Hard to update later
- Use cell references (e.g., =A1รB1)
- Change one cell to update everything
3. Not Using Excel Tables (Ctrl + T)
- Manual ranges don't expand
- Formulas don't auto-fill
- Tables provide dynamic ranges
- Makes Pivot Tables easier to update
4. Manual Data Cleaning
- Slow and prone to human error
- Use Power Query for repetitive tasks
- Use Find & Replace or Flash Fill
- Automate the boring stuff
5. Ignoring Absolute References ($)
- Formulas break when dragged
- Use $A$1 to lock a cell
- Press F4 to toggle references
- Essential for tax rates or constants
6. Overusing VLOOKUP
- Slow on large datasets
- Breaks if you insert a column
- Learn XLOOKUP or INDEX/MATCH
- More flexible and powerful
7. Not Handling Errors
- Sheets look messy with #N/A or #DIV/0!
- Confuses the end-user
- Wrap formulas in IFERROR
- Example:
=IFERROR(A1/B1, 0)8. Merging Data Manually
- Copy-pasting from different sheets
- High risk of misalignment
- Use Power Query to merge/append
- Keep a "Single Source of Truth"
9. Poor Formatting & Alignment
- Using too many colors and borders
- Numbers aligned as text
- Keep it professional and clean
- Use Conditional Formatting to highlight trends
10. Not Using Pivot Tables
- Calculating summaries with manual math
- Taking hours to do what takes seconds
- Pivot Tables are the heart of analysis
- Drag and drop to get instant insights
Double Tap โฅ๏ธ For More