🔥Free Data Analytics Course: https://www.simplilearn.com/learn-data-analytics-for-beginners-skillup?utm_campaign=DataAnalytics&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, iferror, 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.
Post Graduate Program in Business Analysis:
Start your business analysis career with our Post Graduate Program in Business Analysis, in partnership with Purdue University. This business analysis certification program helps you build extensive business expertise with real-world projects and prepares you for the business analyst role. This Post Graduate Program in Business Analysis will help you master business analysis techniques, Agile Scrum methodologies, SQL database, and visualization tools, including Excel, Power BI, and Tableau. You will learn about business analysis planning and monitoring, build interactive dashboards and understand the competencies of a Business Analyst.
Program Details:
Jumpstart your career as a Business Analysis Professional with this comprehensive curriculum covering the concepts of business analysis tools and techniques, statistics fundamentals, interaction with databases using SQL, and data visualization using excel, Power BI, and Tableau.
Key Features:
✅ Purdue Post Graduate Program Certification
✅ Purdue Alumni Association Membership
✅ Masterclasses from Purdue faculty
✅ Enrollment in Simplilearn’s JobAssist
✅ Get noticed by the top hiring companies
✅ Case Studies from Harvard Business Publishing Education
✅ Obtain 35 IIBA PDs/CDUs and 25 PMI PDUs
✅ 170+ hours of Applied Learning
✅ 11+ hands-on projects
✅ Capstone project in 3 domains
Learn more at: https://www.simplilearn.com/pgp-business-analysis-certification-training-course?utm_campaign=BusinessAnalytics&utm_medium=Description&utm_source=youtube
For more information about Simplilearn’s courses, visit:
– Facebook: https://www.facebook.com/Simplilearn
– Twitter: https://twitter.com/simplilearn
– LinkedIn: https://www.linkedin.com/company/simplilearn/
– Website: https://www.simplilearn.com
– Instagram: https://www.instagram.com/simplilearn_elearning
– Telegram Mobile: https://t.me/simplilearnupdates
– Telegram Desktop: https://web.telegram.org/#/im?p=@simplilearnupdates
Get the Android app: http://bit.ly/1WlVo4u
Get the iOS app: http://apple.co/1HIO5J0
28 Comments
🔥Explore Our FREE Courses With Completion Certificate: https://www.youtube.com/watch?v=-caxhMlw_04
22:34
Sir, It will be helpful, if you share the data set for practice
sir you have not gave us lookup file in zip
sir thank you very much. it is a very wonderful video to understand data analytics in Excel
0:40 topics
11:05 sum
12:21 new sum
14:36 split
17:31 delimiter split
Where I download this kind of data sets
Thank you for sharing the video. It would be great helpfull. Can you please share the link for the data sets used in this video. So that we can also practice. Thank you 🙏🙏🙏
Anyone has data sets used in the video can share the link. It very helpful. Thank you 🙏🙏🙏
Hi can you share me your mail Id so I can share you mine and can you please share practice file for this video?
Subscribed to your channel simply because content is amazing and easily understandable. Thank you for the great work that you are doing.
I love this course, it is exploratory. Thanks to you guys. However, the lookup file in 2:37:06 is missing in the drive. Any help?
Could you provide the additional excels used in data import?
Excellent explanation …..
Tq for uploading this video
Thank you so much for this simplified teaching. Can you send me the data for practice?
I unable to see the Excel. Tour how can i open it
Thanks for the tutorial sir. Please kindly help me with the data's your using for the tutorial. I'm just a beginner. Thanks
Kindly provide all the excel sheets which you are using in the video.
Wtf at every 2sec u were saying "basically" really got me irritated , why the fuck r u frequently repeating the word even in sum avg division etc
Please check out my excel app https://youtu.be/Vm7RTv9_pVk
Good day, thanks for this explicit lecture. can I get the data set used in the course of this lecture. thanks in anticipation.
I am very intrested in this analyst job..
Simplilearn! You guys are the best. Top notch, detailed explanation. A big Kudos to the lecturers. Please how can I get the datasets used in this tutorial? It would really help me practice what I was taught🙏🏽. Thanks
Can you please share the data set?
thankyou for this.
thanks sir
Thanks for the video.