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.
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 |