Summary
Keywords
Full Transcript
🔵 Intellipaat Data Analytics course: https://intellipaat.com/data-science-business-analytics-iit-madras/ In this Data Analytics In Excel Full Course video, you will learn what is Data Analytics basics of excel, basic formulas & functions used in Excel, linear regression & statistics in excel, hands-on demo on VBA(Visual Basic Editor), Data Analytics interview questions. #DataAnalyticsInExcelFullCourse #DataAnalyticsCourseForBeginners #DataAnalyticsInExcelFullCourse #DataAnalyticsWithExcel #DataAnalyticsUsingExcel #DataAnalyticsCourse #DataAnalyticsCourseForBeginners #ExcelForDataAnalysis #ExcelForBeginners #ExcelBasicsForBeginners #ExcelTutorial #ExcelTutorialForBeginners #BusinessAnalystCourse #BusinessAnalyst #BusinessAnalytics 00:00 - Data Analytics in Excel 00:36 - What is Data Analytics? 03:51 - Need for Data Analytics 06:18 - Who are Data Analysts? 08:16 - Data Analysts: Common Tasks 11:23 - In A Gist 13:40 - Microsoft Excel Overview 17:47 - Getting Started with Microsoft Excel: Demo 36:42 - Formatting Excel & Shortcuts: Demo 45:27 - Basic Formulas 01:03:38 - Basic Formulas 02:02:42 - Pivot Tables 02:50:38 - Vlookup 03:40:06 - Index Function 04:19:13 - Lookup Function 06:15:44 - What is VBA? 06:21:44 - Using Macro Recorder 06:52:26 - Variables, Data types & Constants 07:39:15 - Decision Making 08:06:31 - Decision Making: Demo 08:45:49 - Data Analytics Interview Questions 🔵 Read the complete Data Science tutorial here: https://intellipaat.com/blog/tutorial/data-science-tutorial/ 🔵 To subscribe to the Intellipaat channel & get regular updates on videos: http://bit.ly/Intellipaat 🔵 Watch Data Science tutorials here:- https://bit.ly/30QlOmv 🔵 Read the insightful blog on what is Data Science: https://intellipaat.com/blog/what-is-data-science/ 🔵 Interested to know about Data Science certifications? Read this blog: https://intellipaat.com/blog/data-science-certification/ ---------------------------- Intellipaat Edge 1. 24*7 Lifetime Access & Support 2. Flexible Class Schedule 3. Job Assistance 4. Mentors with +14 yrs 5. Industry Oriented Courseware 6. Lifetime free Course Upgrade ------------------------------ For more information: Call Our Course Advisors IND : +91-7022374614 US : 1-800-216-8930 (Toll Free) Website: https://intellipaat.com/data-science-business-analytics-iit-madras/ Facebook: https://www.facebook.com/intellipaatonline Instagram: https://www.instagram.com/intellipaat LinkedIn: https://www.linkedin.com/company/intellipaat-software-solutions Twitter: https://twitter.com/Intellipaat
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
