Intelligent World - Learn, Meet, Succeed!
Create a New Learning Goal and get Videos, Video Series etc for free
Catalog

Data Analytics Full Course with Excel

Understand how Microsoft Excel can be used for data analysis, taught by industry experts so you can learn everything from scratch.

Speaker :     Data Analytics Instructor

7 Hours 51 Minutes | 14 Videos | Attendees: 744

Determine why you should use Excel such as mathematical calculations of datasets, features like searching, sorting, and filtering, and presenting data in the forms of charts, tables, and data bars. 

Learn the basics of Microsoft Excel, Excel functions and formulas, data validation and conditional formatting, pivot tables and Excel Power Query, dashboards in Excel, data analysis and regression, Excel macros and VBA, and for performing statistical analysis such as descriptive statistics, regression analysis, and sampling.

$99.00

9 days 9 hours left for free!

Categories covered:

Analytics [Topic]

In partnership with:
Content

7h 51m total length

Introduction- Data Analytics with excel

00:34:43
Excel Functions and Formula (Part I)

00:29:59
Excel Functions and Formula (Part II)

00:26:42
Excel Functions and Formula (Part III)

00:27:47
Countifs, Sumifs and Averageifs functions

00:22:59
Conditional Formatting

00:27:38
Pivot Table in Excel

00:26:47
Excel Power Query

00:49:25
Data Validation

00:30:04
Excel Revenue Dashboard

00:29:41
Examples of Data Analysis

00:20:39
Regression in Excel

00:26:47
Excel Macro

00:39:55
Exam of Pivot Chart and Pivot Table

00:22:49
Data Analytics Instructor at Simplilearn
1771 Attendees
4 Video series & Videos
Data Analytics Instructor at Simplilearn