Data Analytics Course | Data Analysis in Excel | Excel Data Analytics Tutorial | Intellipaat – 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

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-analytics-master-training-course/

Facebook: https://www.facebook.com/intellipaatonline

Telegram: https://t.me/s/Learn_with_Intellipaat

Instagram: https://www.instagram.com/intellipaat

LinkedIn: https://www.linkedin.com/company/intellipaat-software-solutions

Twitter: https://twitter.com/Intellipaat

source

Author: Aprit Dixit

Share This Post On