Data Analytics Course | Data Analysis in Excel | Excel Data Analytics Tutorial | Intellipaat – YouTube

Posted By Aprit Dixit on 6 Jun 2021 in YouTube

? Intellipaat Data Analytics course: https://intellipaat.com/data-analytics-master-training-course/
In this Data analysis in excel video, you will learn what is Data Analytics in Excel, how to create a Dashboard, Pivot Tables, Lookup Functions, Introducing VBA, Macros, VBA, For loop in Excel, Variables, Data Types, and Constants, Data Analytics & Excel interview question.

#DataAnalyticsCourse #DataAnalysisInExcel #ExcelDataAnalyticsTutorial #DataAnalyticsUsingExcel #DataAnalytics #Excel #Intellipaat

00:00 – Data Analytics Course
01:37 – What is Data Analytics?
04:51 – Need of Data Analytics
07:17 – Who are Data Analysts?
09:15 – Data Analysts Common Tasks
12:23 – In A Gist
14:41 – Microsoft Excel Overview
18:31 – Demo
46:10 – Excel & Shortcuts Demo
01:03:50 – Basic Formulas Demo
02:02:00 – Pivot Tables
02:48:14 – Lookup Functions Demo
03:37:25 – Index Function Demo
04:55:43 – What is VBA?
04:57:11 – What is Marco?
04:58:27 – Visual Basic Editor (VBE) Demo
05:01:13 – Using Macro Recorder Demo
05:31:34 – Variables, Data types & Constants
06:30:48 – Decision Making Demo
07:23:15 – 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