Advanced Excel of Data Analysis
Casharkan waxaad ku baranaysaa sida loo sameeyo Data Analaysis wana course dhamaystiran oo ah Excel.
Waxa la samayn doonaa laba project.
- Curriculum
- Reviews
-
1
Hordhac -
2
Lesson 1 Adjusting Data
-
3
Lesson 2 Creating Pivot Table
-
4
Lesson 3 Pivot Chart Part 1
-
5
Lesson 4 Pivot Chart Part 2
-
6
Lesson 5 Customizing Pivot Table
-
7
Lesson 6 Sorting Pivot Table
-
8
Lesson 7 Grouping Pivot Table
-
9
Lesson 8 Filtering Pivot Table
-
10
Lesson 9 Changing Calculations
-
11
Lesson 10 Adding Percentages
-
12
Lesson 11 Running Total In
-
13
Lesson 12 Refreshing Pivot Table
-
14
Lesson 13 Frequency
-
15
Lesson 14 Bie Chart
-
16
Lesson 15 Cross Tabulation
-
17
Lesson 16 Conditional Format
-
18
Lesson 17 Line Chart Part 1
-
19
Lesson 18 Line Chart Part 2
-
20
Lesson 19 Doughnut Chart
-
21
Lesson 20 Adding Slicers
-
22
Lesson 21 Text To Columns
-
23
lesson 22 Creating Dashboard Part 1
-
24
Lesson 23 Creating Dashboard Part 2
-
25
Lesson 24 Analaysing Dashboard Report
-
26
Lesson 25 Column with Text
-
27
Lesson 26 Power Query Editor
-
28
Lesson 27 Change Type Power Query Editor
-
29
Lesson 28 Insert CSV File
-
30
Lesson 29 Frequency of Pivot Table Analysis
-
31
Lesson 30 Frequency In Excel Functions Analysis
-
32
lesson 31 Extracting Excel File
-
33
Lesson 32 Relationship Creating
-
34
Lesson 33 Creating Pivot Table and Pivot Chart
-
35
Lesson 34 Add Measuring
-
36
Lesson 35 Merge And Queries
-
37
Lesson 36 Vlookup Relationship
-
38
Lesson 37 Data Modeling -Relationship
-
39
Lesson 38 Pivot Table Analysis
-
40
Lesson 39 Xlookup relationship
-
41
Lesson 40 Add Pivot Chart
-
42
Lesson 41 Creating Dashboard part1
-
43
Lesson 42 Creating Dashboard Part 2
-
44
Lesson 43 Creating Dashboard Part3
-
45
Lesson 44 Summarizing Final Dashboard
Please, login to leave a review
Course details
Duration
2 Months
Lectures
45
Video
10 Hours
Level
Advanced
Basic info
Casharkan waxaad ku baranaysaa sida loo sameeyo Data Analaysis wana course dhamaystiran oo ah Excel.
Waxa la samayn doonaa laba project.
Course requirements
Computer iyo Microsoft Office 2019 iyo wixii ka sareeya
Intended audience
Accountant, statistics iyo qof walba oo jecel inuu barto data analysis
Popular courses
