📈 TREND Function in Microsoft Excel

✅ What is TREND Function?

TREND function is used to predict future values based on existing data using linear regression.

👉 It is mainly used for forecasting sales, growth, or future trends.

=TREND(known_y's, [known_x's], [new_x's], [const])
Arguments:

1️⃣ known_y's → Dependent values (Example: Sales)
2️⃣ known_x's → Independent values (Example: Months/Years)
3️⃣ new_x's → Future value for prediction
4️⃣ const → TRUE (default) / FALSE

📊 Simple Example (Sales Forecast)
Year Sales
2022 10000
2023 15000
2024 20000

To predict Sales for 2025:

=TREND(B2:B4, A2:A4, A5)
If A5 = 2025
👉 Excel will forecast expected sales for 2025.

🎯 Practical Uses

✔ Sales forecasting
✔ Profit prediction
✔ Business growth analysis
✔ Budget planning
✔ Financial modeling

Видео 📈 TREND Function in Microsoft Excel канала Concept Clear Karlo