In this video, I will show you two really easy ways to calculate slope and intercept in Excel.
There are inbuilt SLOPE and INTERCEPT formula that instantly gives the result, and you can also get the equation (y = mx + b) by adding a trendline in a scatter chart.
00:00 Intro
00:10 Calculate SLOPE and INTERCEPT using formulas
01:46 Calculate SLOPE and INTERCEPT using Scatter Chart Trendline
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee –
✅ Free Excel Course (Basic to Advanced) –
✅ Free Dashboard Course –
✅ Free VBA course –
✅ Free Power Query Course –
✅ Best Excel Books:
Subscribe to get awesome Excel Tips every week:
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English