5 Awesome Data Analysis Tricks on Excel 

Learn 5 awesome data analysis tools on Excel ranging from regression to correlation analysis.
🔥 Download FREE Excel Chart Templates from Hubspot: clickhubspot.com/3nn
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/64144eb7ee9a92253303889f
LEARN:
👉 Excel for Business & Finance Course: www.careerprinciples.com/courses/excel-for-business-finance
🔥Power BI for Business Analytics: www.careerprinciples.com/courses/power-bi-for-business-analytics
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/courses/finance-valuation-course
🚀 All our courses: www.careerprinciples.com/courses
In this video you'll learn five data analysis tools on Excel.
First, we cover forecasting in Excel using the forecast sheet feature. For this we use a hotel resort's revenue historical figures to forecast into the future. The tools are descriptive statistics, linear regression, multiple regression, correlation analysis, and forecasting.
Second, we cover correlation analysis using the data analysis feature on excel. Correlation analysis allows us to see if there's a correlation between different stocks we wan to invest in.
Third, we cover descriptive statistics, which helps us find essential statistics for our values such as the average, count, min, max, and more.
Fourth, we cover a simple linear regression to see the relationship between 2 variables. For this we use a scatter plot with the equation of a line and the r squared.
Lastly, we cover a multiple regression, where we get the adjusted r squared, the coefficients, the p values and more.
SOCIALS:
🎬 My Company RU-vid Channel: www.youtube.com/@careerprinciples
📸 Instagram - careerprinciples?hl=en
🤳 TikTok - www.tiktok.com/@career_principles
🧑‍💻 LinkedIn - www.linkedin.com/company/careerprinciples/
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00​ -​ Intro
0:14​ - Forecast Sheet
1:53​ - Correlation Analysis
4:56​ - Descriptive Statistics
6:07​ - Linear Regression
7:39​ - Multiple Regression
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.