Executive Program in Data Analytics
- Description
- Curriculum
- FAQ
- Reviews
Microsoft Excel is one of the most popular applications for data analytics. Equipped with built-in pivot tables, they are without a doubt the most sought-after analytic tool available.
MS Excel is an all-in-one data management software that allows you to easily import, explore, clean, analyze, and visualize your data.
Executive Program in Data Analytics using MS Excel is a comprehensive course that provides a good insight into the latest and advanced features available in Microsoft Excel. It explains in detail how to perform various data analysis functions using the features available in MS-Excel.
The course is designed keeping in mind two kinds of learners – those who have very little functional knowledge of Excel and those who use Excel regularly but at a peripheral level and wish to enhance their skills.
All along, Excel functionality is introduced using easy-to-understand examples which are demonstrated in a way that learners can become comfortable in understanding and applying them.
The course covers 75 plus formulas and functions of MS Excel. The power of data analysis will help in converting raw data into meaningful information for better and data-driven decision making
The course integrates Logical formulas, Statistical formulas, If functions, and Sum functions to name a few.
-
22How to create First Pivot TableVideo lesson
-
23Understanding Value Fields in Pivot TablesVideo lesson
-
24Learn to Refresh the Pivot TablesVideo lesson
-
25Changing Data Source in Pivot TablesVideo lesson
-
26Grouping the ItemsVideo lesson
-
27TimelineVideo lesson
-
28Playing with SlicerVideo lesson
-
29Learn how to do a Running TotalVideo lesson
-
30Doing Summation with Frequency 1Video lesson
-
31Doing Summation with Frequency 2Video lesson
-
32SumIf with Number Criteria 1Video lesson
-
33SumIf with Number Criteria 2Video lesson
-
34SumIf with Text Criteria 1Video lesson
-
35SumIf with Text Criteria 2Video lesson
-
36SumIf with Date CriteriaVideo lesson
-
37SumIf with OR CriteriaVideo lesson
-
38SumIf with Not Equal To CriteriaVideo lesson
-
39Learn SumIfsVideo lesson
-
40SumIfs or Sum with Multiple CriteriaVideo lesson
-
41Introduction to Count FormulaVideo lesson
-
42Count FormulaVideo lesson
-
43Counta FormulaVideo lesson
-
44Count Blank FormulaVideo lesson
-
45Count with Number Criteria 1Video lesson
-
46Count with Number Criteria 2Video lesson
-
47Count with Text Criteria 1Video lesson
-
48Count with Text Criteria 2Video lesson
-
49Count with OR LogicVideo lesson
-
50CountIf vs CountIfsVideo lesson
-
51CountIfsVideo lesson
-
52Generating Random Numbers 1Video lesson
-
53Generating Random Numbers 2Video lesson
-
54Generating Random Numbers 3Video lesson
-
55Rank the Team Member's Performance 1Video lesson
-
56Rank the Team Member's Performance 2Video lesson
-
57Generate Unique Random NumbersVideo lesson
-
58Convert Negative to Positive Numbers 1Video lesson
-
59Convert Negative to Positive Numbers 2Video lesson
-
60Weighted AverageVideo lesson
-
61AND Logical FormulaVideo lesson
-
62IF Logical FormulaVideo lesson
-
63Logical Formula Combo 1 IF ANDVideo lesson
-
64OR Logical FormulaVideo lesson
-
65XOR Logical FormulaVideo lesson
-
66Logical Formula Combo 2 IF ORVideo lesson
-
67Logical Formula Combo 3 AND ORVideo lesson
-
68Logical Formula NOTVideo lesson
-
69Logical Formula IFS / Nested IFVideo lesson
External Links May Contain Affiliate Links read more