0
0 reviews
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
-
1HordhacPreview 0h00m09s
-
2Lesson 1 Adjusting Data0h4m53s
-
3Lesson 2 Creating Pivot Table0h9m31s
-
4Lesson 3 Pivot Chart Part 10h12m01s
-
5Lesson 4 Pivot Chart Part 20h12m01s
-
6Lesson 5 Customizing Pivot Table0h11m40s
-
7Lesson 6 Sorting Pivot Table0h8m14s
-
8Lesson 7 Grouping Pivot Table0h7m00s
-
9Lesson 8 Filtering Pivot Table0h10m53s
-
10Lesson 9 Changing Calculations0h10m13s
-
11Lesson 10 Adding Percentages0h11m53s
-
12Lesson 11 Running Total In0h11m31s
-
13Lesson 12 Refreshing Pivot Table0h13m59s
-
14Lesson 13 Frequency0h9m18s
-
15Lesson 14 Bie Chart0h12m06s
-
16Lesson 15 Cross Tabulation0h6m53s
-
17Lesson 16 Conditional Format0h9m27s
-
18Lesson 17 Line Chart Part 10h9m13s
-
19Lesson 18 Line Chart Part 20h7m45s
-
20Lesson 19 Doughnut Chart0h9m00s
-
21Lesson 20 Adding Slicers0h23m25s
-
22Lesson 21 Text To Columns0h8m49s
-
23lesson 22 Creating Dashboard Part 10h22m28s
-
24Lesson 23 Creating Dashboard Part 20h36m53s
-
25Lesson 24 Analaysing Dashboard Report0h7m21s
-
26Lesson 25 Column with Text0h5m50s
-
27Lesson 26 Power Query Editor0h11m20s
-
28Lesson 27 Change Type Power Query Editor0h14m23s
-
29Lesson 28 Insert CSV File0h7m58s
-
30Lesson 29 Frequency of Pivot Table Analysis0h7m51s
-
31Lesson 30 Frequency In Excel Functions Analysis0h12m32s
-
32lesson 31 Extracting Excel File0h4m44s
-
33Lesson 32 Relationship Creating0h21m44s
-
34Lesson 33 Creating Pivot Table and Pivot Chart0h13m11s
-
35Lesson 34 Add Measuring0h18m42s
-
36Lesson 35 Merge And Queries0h12m29s
-
37Lesson 36 Vlookup Relationship0h16m23s
-
38Lesson 37 Data Modeling -Relationship0h18m12s
-
39Lesson 38 Pivot Table Analysis0h12m16s
-
40Lesson 39 Xlookup relationship0h12m22s
-
41Lesson 40 Add Pivot Chart0h35m40s
-
42Lesson 41 Creating Dashboard part10h21m29s
-
43Lesson 42 Creating Dashboard Part 20h21m16s
-
44Lesson 43 Creating Dashboard Part30h18m52s
-
45Lesson 44 Summarizing Final Dashboard0h12m45s
Please, login to leave a review
Share
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
Working hours
| Monday | 9:30 am - 6.00 pm |
| Tuesday | 9:30 am - 6.00 pm |
| Wednesday | 9:30 am - 6.00 pm |
| Thursday | 9:30 am - 6.00 pm |
| Friday | 9:30 am - 5.00 pm |
| Saturday | Closed |
| Sunday | Closed |