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: 110

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 18 hours left for free!

Categories covered:

Analytics [Topic]

In partnership with:
Course Content

7h 51m total length

Introduction- Data Analytic 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
1 Attendees
4 Video series & Videos
Data Analytics Instructor at Simplilearn

The Intelligent World is an on-demand and live video content portal where executives and technology experts can come together to share and educate target audiences about the latest technology trends, developments, and processes shaping a digital-first business world.

twitter linkedin