1000+ Free Courses With Free Certificates: https://www.mygreatlearning.com/academy?ambassador_code=GLYT_DES_Top_SEP22&utm_source=GLYT&utm_campaign=GLYT_DES_Top_SEP22

Build a career in Data Science & Business Analytics: https://www.mygreatlearning.com/pg-program-data-science-and-business-analytics-course?ambassador_code=GLYT_DES_Middle_SEP22&utm_source=GLYT&utm_campaign=GLYT_DES_Middle_SEP53


Data analytics has been the most sort after domain in recent times. To stay ahead of the competition, it's really important to learn various tools in this domain. Microsoft excel, being the most widely used platform for decades, is a must to learn. The journey of data involves majorly three phases data cleaning, data analysis, and data visualization. This course provides you with an in-depth view of all the phases in detail from scratch so that you can begin your data analytics journey and get your dream job.

00:00:00 Introduction
00:01:30 Agenda
00:02:45 Phases of Data Analytics Project
00:05:45 Data Cleaning
00:10:58 Functions
00:29:02 Lookup Functions
00:37:36 Conditional Formatting
00:46:53 Data Validation
00:55:44 Pivot Tables
01:05:46 Data Visualisation using Excel
01:21:15 Summary

Check Our Free Courses with free certificate:
Data Analytics using Excel course: https://glacad.me/3pqmv4y
Excel for Beginners: https://www.mygreatlearning.com/academy/learn-for-free/courses/excel-for-beginners?ambassador_code=GLYT_DES_Middle_SEP22&utm_source=GLYT&utm_campaign=GLYT_DES_Middle_SEP100
LOOKUP in Excel: https://www.mygreatlearning.com/academy/learn-for-free/courses/vlookup-in-excel?ambassador_code=GLYT_DES_Middle_SEP22&utm_source=GLYT&utm_campaign=GLYT_DES_Middle_SEP101
Excel Regression Analysis: https://www.mygreatlearning.com/academy/learn-for-free/courses/regression-analysis-with-excel-hands-on?ambassador_code=GLYT_DES_Middle_SEP22&utm_source=GLYT&utm_campaign=GLYT_DES_Middle_SEP102
Excel Tips and Tricks: https://www.mygreatlearning.com/academy/learn-for-free/courses/excel-tips-and-tricks?ambassador_code=GLYT_DES_Middle_SEP22&utm_source=GLYT&utm_campaign=GLYT_DES_Middle_SEP103
Excel for Intermediate Level: https://www.mygreatlearning.com/academy/learn-for-free/courses/excel-for-intermediate-level?ambassador_code=GLYT_DES_Middle_SEP22&utm_source=GLYT&utm_campaign=GLYT_DES_Middle_SEP104

About Great Learning Academy:
Visit Great Learning Academy to get access to 1000+ free courses with free certificate on Data Science, Data Analytics, Digital Marketing, Artificial Intelligence, Big Data, Cloud, Management, Cybersecurity, Software Development, and many more. These are supplemented with free projects, assignments, datasets, quizzes. You can earn a certificate of completion at the end of the course for free.

About Great Learning:
With more than 5.4 Million+ learners in 170+ countries, Great Learning, a part of the BYJU'S group, is a leading global edtech company for professional and higher education offering industry-relevant programs in the blended, classroom, and purely online modes across technology, data and business domains. These programs are developed in collaboration with the top institutions like Stanford Executive Education, MIT Professional Education, The University of Texas at Austin, NUS, IIT Madras, IIT Bombay & more.

SOCIAL MEDIA LINKS:
For more interesting tutorials, don't forget to subscribe to our channel: https://glacad.me/YTsubscribe

For more updates on courses and tips follow us on:
Telegram: https://t.me/GreatLearningAcademy
Facebook: https://www.facebook.com/GreatLearningOfficial/
LinkedIn: https://www.linkedin.com/school/great-learning/mycompany/verification/
Follow our Blog: https://glacad.me/GL_Blog