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: https://clickhubspot.com/3nn 🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/64144eb7ee9a92253303889f LEARN: 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🧑‍💻 The Data Analyst Program: https://www.careerprinciples.com/career-track/the-data-analyst-program 🚀 All our courses: https://www.careerprinciples.com/all-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 YouTube Channel: https://www.youtube.com/@careerprinciples 📸 Instagram - https://www.instagram.com/careerprinciples/?hl=en 🤳 TikTok - https://www.tiktok.com/@career_principles 🧑‍💻 LinkedIn - https://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