Channel | Publish Date | Thumbnail & View Count | Download Video |
---|---|---|---|
Publish Date not found | 0 Views |
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 get started.
00:00:00 Basics of Excel data analysis
00:04:20 Lookup and functions in Excel data analysis
01:37:58 Conditional formatting 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
Link to dataset: https://drive.google.com/drive/folders/1U8CF0Xx3NivXdfrQvXJ_462tEb26oPuX
Subscribe to our channel to learn more about the best technologies: https://bit.ly/2VT4WtH
⏩ Watch the Business Analytics instructional videos: https://bit.ly/3hQFfDP
#DataAnalyticsInExcel #DataAnalyticsInExcelFullCourse #DataAnalyticsWithExcel #DataAnalyticsUsingExcel #DataAnalyticsCourse #DataAnalyticsCourseForBeginners #ExcelForDataAnalysis #ExcelForBeginners #ExcelBasicsForBeginners #ExcelTutorial #ExcelTutorialForBeginners #BusinessAnalystCour see #BusinessAnalyst # BusinessAnalytics #Simplilearn
What is Microsoft Excel?
Excel is one of the best applications available for creating spreadsheets to process numbers and dashboard reports and to store and manage data. This software first appeared on the scene in 1987 and has since become one of the most popular software for use at home or at work. For data entry, you can use Excel to store data in tabular form, such as recording your daily expenses or business expenses. 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 no prior programming knowledge is required. It covers topics such as data analysis, data visualization, regression techniques and deep supervised learning through our applied learning model with live sessions from leading practitioners and industry projects.
Most important features:
– Professional Program Certificate and Alumni Association Membership
– IBM exclusive hackathons and Ask me Anything sessions
– 8x higher live interaction in live online classes by industry experts
– Capstone of 3 domains and 14+ data analysis projects with industrial datasets from Google PlayStore, Lyft, World Bank etc.
– Masterclasses taught by Purdue faculty and IBM experts
– Simplilearn's JobAssist can help you get noticed by the top recruitment companies
– Prepare CV and build LinkedIn profile
– 1:1 mock interview
– Career accelerator webinars
Skills covered
– Data analysis
– 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
For more information, visit: 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
Please take the opportunity to connect and share this video with your friends and family if you find it useful.