WP Tutorials

Excel Data Analytics Full Course | Essential Skills For Data Analysis In Excel | Simplilearn

Excel Data Analytics Full Course | Essential Skills For Data Analysis In Excel | Simplilearn

🔥Post Graduate Program in Data Analytics: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=DataAnalytics-OOWAk2aLEfk&utm_medium=DescriptionFirstFold&utm_source=youtube
🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): https://www.simplilearn.com/iitk-professional-certificate-course-data-analytics?utm_campaign=DataAnalytics-OOWAk2aLEfk&utm_medium=DescriptionFirstFold&utm_source=youtube
🔥Caltech Data Analytics Bootcamp(US Only): https://www.simplilearn.com/data-analytics-bootcamp?utm_campaign=DataAnalytics-OOWAk2aLEfk&utm_medium=DescriptionFirstFold&utm_source=youtube
🔥 Data Analytics Bootcamp(US Only):https://www.simplilearn.com/data-analytics-bootcamp?utm_campaign=DataAnalytics-OOWAk2aLEfk&utm_medium=DescriptionFirstFold&utm_source=youtube

This Excel Data Analytics Full Course video will help you understand the various crucial functions available in Excel, such as lookup, H lookup, sumif/s, counif/s, if error, and others. Finally, you will see how to use the Data Analysis Toolpak to perform various data analysis operations. So, let’s begin.

00:00:00 Basic of excel data analysis
00:04:20 Lookup & functions in excel data analysis
01:37:58 Conditional formating in excel data analysis
01:54:30 Data validation in excel data analysis
02:36:30 Sorting and filtering in excel data analysis
03:23:55 Data analysis using toolpak in excel data analysis

Dataset Link: https://drive.google.com/drive/folders/1U8CF0Xx3NivXdfrQvXJ_462tEb26oPuX

✅Subscribe to our Channel to learn more about the top Technologies: https://bit.ly/2VT4WtH

⏩ Check out the Business Analytics tutorial videos: https://bit.ly/3hQFfDP

#DataAnalyticsInExcel #DataAnalyticsInExcelFullCourse #DataAnalyticsWithExcel #DataAnalyticsUsingExcel #DataAnalyticsCourse #DataAnalyticsCourseForBeginners #ExcelForDataAnalysis #ExcelForBeginners #ExcelBasicsForBeginners #ExcelTutorial #ExcelTutorialForBeginners #BusinessAnalystCourse #BusinessAnalyst #BusinessAnalytics #Simplilearn

What is Microsoft Excel?
Excel is one of the best applications available for creating spreadsheets to crunch numbers and dashboard reports and storing and administering data. This software first appeared on the scene back in 1987, and since then it has grown to become one of the most popular pieces of software for home or business. Excel can be used for data entry to store data in the form of a table, such as recording your daily expenses or business expenditure. It can also be used for inventory management.

✅ Professional Certificate Program In Data Analytics:

This Data Analytics Program is ideal for all working professionals and prior programming knowledge is not required. It covers topics like data analysis, data visualization, regression techniques, and supervised learning in-depth via our applied learning model with live sessions by leading practitioners and industry projects.

✅ Key Features:

– Professional Program certificate and Alumni Association membership
– Exclusive hackathons and Ask me Anything sessions by IBM
– 8X higher live interaction in live online classes by industry experts
– Capstone from 3 domains and 14+ Data Analytics Projects with Industry datasets from Google PlayStore, Lyft, World Bank etc.
– Master Classes delivered by Purdue faculty and IBM experts
– Simplilearn’s JobAssist helps you get noticed by top hiring companies
– Resume preparation and LinkedIn profile building
– 1:1 mock interview
– Career accelerator webinars

✅ Skills Covered

– Data Analytics
– Statistical Analysis using Excel
– Data Analysis Python and R
– Data Visualization Tableau and Power BI
– Linear and logistic regression modules
– Clustering using kmeans
– Supervised Learning

Learn more at: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=DataAnalytics-OOWAk2aLEfk&utm_medium=Description&utm_source=youtube

🔥🔥 Interested in Attending Live Classes? Call Us: IN – 18002127688 / US – +18445327688


Comments (28)

  1. 🙏🙏🙏🙏

  2. Thank you so much. So helpful 🎉

  3. It was very effective and informative, thank you very much👍

  4. How can i download this Excel version. Which windows version?

  5. This video is very useful for data entry setup. Thanks for your support.

  6. The lookup dataset file is missing! Are you able to add it pls? Thank you

  7. Thanks for this great video. Just starting out and stumbled on your course. I'm really enjoying the lessons.

    However, the dataset you are using, especially the one named Welcome to excel isn't in the Google drive file. Meanwhile, couldn't find it in my own version of excel. I got different workbooks that aren't similar to yours in my version.

    Is there a way you can assist with the data set?

  8. Thankyou so much for this tutorial

  9. awesome

  10. Can't understand … accent too thick!!

  11. Those asking for dataset, here is the link as provided in the description box: https://drive.google.com/drive/folders/1U8CF0Xx3NivXdfrQvXJ_462tEb26oPuX

  12. How will we get the certificate after completing course??
    Plz let me know

  13. Gratitude from Another data analyst in Cameroon.

  14. Any short term course available for MBA finance students ? share it please.

  15. I learnt a lot from this generous course!
    Thanks a lot

  16. Thank you sir

  17. Very nice ajay bhaiya

  18. it is enough for data analyst ??

  19. Best Best Best🤩🤩🤩🤩

  20. Great lecture sir , Thank you so much simplilearn

  21. Thank You for this.

  22. Hi there,
    Thanks for the tutorial. Everything is very well explained. It seems data sheets for lookup section (2:35:003:23:00) is missing in the zipped file. Can you please share those files too or let me know if I am missing out on something.

  23. do i get a certificste when i complete this?

  24. @simplileranofficial can you please help the excel sheet

  25. Amazing tutorial!

  26. Can you please tell where will I find the lookup excel sheet?

  27. it takes 8 hours to complete this with practice
    thank you @simplilearn for such a wonderful session

Leave your thought here

Your email address will not be published. Required fields are marked *

Enable Notifications OK No thanks