Data Analysis in Excel | Important Excel Skills for Data Analysts | Data Analytics Using Excel

?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
?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
Data Analysis in Excel | Important Excel Skills for Data Analysts | Data Analytics Using Excel
Hello and welcome to the Data Analytics tutorial powered by Great learning. Here is an Excel tutorial video on how to start using Excel for data visualization, with the following topics covered in it.

?Topics Covered: Important Excel Skills Required for Data Analysis
00:00:57 - Phases of Data Analytic projects
00:02:32 - Data Cleaning Functions
00:03:47 - Excel Functions
00:05:27 - COUNTIF Function
00:06:34 - LEFT/RIGHT Function
00:07:42 - CONCATENATE Function
00:08:09 - TRIM Function
00:17:45 - Conditional Formatting
00:34:07 - LOOKUP Functions (VLOOKUP & HLOOKUP)
00:42:04 - Pivot Tables
00:54:59 - Data Visualization Using Excel (Pie Chart, Bar Chart, Line Chart, Tree Chart, Map Chart)
00:57:43 - How to Visualize Data Using Excel

#dataanalytics #dataanalysis #exceltutorial

Other Free Excel Courses with Certifications:
- 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
- VLOOKUP 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 certificates 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, and quizzes. You can earn a certificate of completion at the end of the course for free. https://www.mygreatlearning.com/acade

⚡ 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 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