Data Analytics using Excel | Excel Tutorial | Data Visualization using Excel | Great Learning

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:

⚡ 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 updates on courses and tips follow us on:

[SameshHub]

Going through the description, I love that this video covers from Data Cleaning up to Data Visualization, which a lot of other even longer videos don't cover. I'm starting right away.

[bp]

Super presentation. I am already studying pgp ds from great learning. However this presentation has covered things in an hour which were equivalent to my initial 2 months journey in data science.

[safvankhanmpathan]

Please provide this datasheet so I can perform every operations you taught

[lemuelrobert]

I think you are the most organized presenter I have ever met in YouTube.

[AsadShaheenAkram]

I just finished this course online. Awesome and very useful video.

[ranirashid]

He is a great instructor 👌🏻👌🏻
Thanks to Great Learning !

[sidikiissadiarra]

Great Tutorial. Can you please provide the dataset ?

[mini_rajnikant]

I just finished this course online.
Wanted to write a review
Search for your name and found
Thank you very much for the course. Its amazing. Useful information also not so overwhelming

[sharminsultana]

It would be very helpful if you provide us this datasheet for practice

[joealexander]

Clearly explained, excellent delivery.

[Saiganesh]

Really amazing. Infact I have done almost 12 courses on great learning. Next time please provide the excel data so that we can practice along with you.

[libertybachie]

Thank you so much for this course i have learnt a lot moreover there is one thing i have admired from great learning their tutors are very visible and transparent

I thank you once again

[FitaaxyareFitaaxyar]

Thank you, sir, your explanations and teaching methods are enjoyable and easy to understand, Thank you again from a learner in Somalia.

[natashameshram]

Thank you great learning. I loved this information and gain sufficient knowledge. Thanks. All the best to me and everyone.

[ritikapunjabi]

wonderfully explained. I could learn a lot. Thanks

[perfectionist]

Very nice and engaging content..
Love your hardwork of putting in a lot of effort to make such awesome content. ❤😊😊

[shanabid_]

Thank you so much, Sir, Learn a lot from this video. Love from Lahore.

[M-TechDevPro]

fantastic video, well structured, important topics and well explained. thank you. only the link you have provided in the description don't work

[yashbasu]

Amazing Video !
It would be very helpful if you provide us this datasheet for practice

[kaushikshiva]

thank you very much sir for boosting up to learn excel again.