Data Science Full Course For Beginners | Python Data Science Tutorial | Data Science With Python - Business Math & Statistics Using Excel For Data Analysts and Data Scientists

Master Data Science: Your Comprehensive Guide to Python, SQL, Machine Learning & Deep Learning! Explore step-by-step tutorials and projects, from coding fundamentals to advanced algorithms, with codebasics. Unlock your data-driven career today!

4.0 (1)

20 learners

What you'll learn

Understand the fundamentals of data science and its applications
Acquire skills in Python programming and data analysis using libraries like Pandas and NumPy
Develop machine learning models and understand key algorithms such as Linear Regression, Decision Trees, and Neural Networks
Use deep learning frameworks like TensorFlow and Keras to build and deploy neural network models

This course includes

33.3 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

yt:cc=on excel tutorial for beginners data analyst excel data analyst tutorial excel tutorial excel codebasics playlist Statistics

Full Transcript

Learn this 20 % business math and statistics to manage 80 % of your tasks as data professionals. 📈 Discover the importance of business math and statistics, along with essential Excel skills. 📊 Excel basics: cells, sheets, workbooks, and essential formulas like SUM, SUMIF, and AVERAGE. Unlock powerful features such as conditional formatting and Excel tables. 💰 Using the movies dataset explore the practical use cases of the above formulas. 📊 Demystify Marvel Studios' profit and loss statement, Gain insights into revenue, budget, profit/loss, profit/loss percentage, and market share. Compare targets with actual results. 📈 Understand mean, median, and mode, and their practical applications in data-informed decisions. 📉 Dive deep into variance and standard deviation. Learn how these measures quantify data spread and calculate them using Excel for accurate analysis. 🔗 Discover the power of correlation. Measure relationships between variables using simple examples and Excel formulas for various scenarios. This content is from my Excel course: https://codebasics.io/courses/excel-mother-of-business-intelligence File link: https://codebasics.io/resources/business-math-statistics-using-excel ⭐️ Timestamps ⭐️ 00:00 Introduction 04:59 Excel Basics 21:05 Total, Average, % Revenue 34:48 Basics of Profit & Loss (P&L) Statement 55:01 Mean, Median, Mode 1:02:19 Variance and Standard Deviation 1:16:42 Correlation Do you want to learn technology from me? Check https://codebasics.io/?utm_source=description&utm_medium=yt&utm_campaign=description&utm_id=description for my affordable video courses. Need help building software or data analytics/AI solutions? My company https://www.atliq.com/ can help. Click on the Contact button on that website. 🎥 Codebasics Hindi channel: https://www.youtube.com/channel/UCTmFBhuhMibVoSfYom1uXEg #️⃣ Social Media #️⃣ 🔗 Discord: https://discord.gg/r42Kbuk 📸 Codebasics Instagram: https://www.instagram.com/codebasicshub/ 🔊 Codebasics Facebook: https://www.facebook.com/codebasicshub 📝 Codebasics LinkedIn: https://www.linkedin.com/company/codebasics/ 📱 Codebasics X handle: https://twitter.com/codebasicshub 📸 Dhaval's Instagram: https://www.instagram.com/dhavalsays/ 📝 Dhaval's LinkedIn: https://www.linkedin.com/in/dhavalsays/ 📱 Dhaval's X handle: https://x.com/dpcodebasics 🔗 Patreon: https://www.patreon.com/codebasics?fan_landing=true

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Welcome