Data Analytics In Excel Full Course | Data Analytics Course | Intellipaat

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

----------------------------
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 : [phone] US : 1-800-216-8930 (Toll Free)

[maddusantoshkumar]

Great video on data analytics with share the datasets to

[EntertainmentwitheducationBD]

Great video. Please share the datasets to practice.

[hanysamy]

@Intellipaat I so glad with this course is very useful could you please open the subtitles on this video.

[grhemant]

Great video very informative and well explained... would be helpful if you share the excel sheets for practice or add the link in the description of the video...
Thank you in advance and all the best for future videos.

[praveena]

Great video for Data analysis, can I get data sheet for practice

[ashathomas]

Superb video. Please share the dataset

[anmol-fwrh]

is everything in EXCEL for data analytics is covered in this course?

[EE__VishnuVerma]

Hey Intellipat! I am glad to be part of this course.
Please Share Excel sheets.

[waleedalhardallou]

Thanks for the helpful tutorial. Hope we can get the same exel file in order to practice. with thanks

[allanlopez]

hello can you teach data analytics on international basis? how much?

[ijeomaokparamaryann]

Can you please share Excel data. Thank you

[Jannatkhan-vznj]

Ap log kindly excel file bhi upload kardia karo for practice..ap log kehte ho description me link Hy but hota nai hy...pata nai jhot kyu bolte hain jab dena nai hota to

[rizwangroup]

Hey Intellipaat, Very Nice Video .can your please share excel sheets. Thank you

[maazahmad]

Hi, Intellipaat! I am highly appreciative of you if you share excel sheets
Thank you

[tapaswinibehura]

Which of these is true about data analysis function?
Ans - A.

[saurabhkulkarni]

Share the databases used in this course.

[rashmiranjan]

Please share the dataset file for practice

[bhavanareddynalla]

Hey Intellipaat, can your please share excel sheets. Thank you

[fazalbasha]

I have a doubt can i learn data analyst skills in this one video ???

[prashantchaubey]

Hello intellipent! Can u share the data with me.