Advanced Excel for Data Analysis
Master the advanced Excel skills needed to transform raw data into meaningful insights and professional reports. This practical course covers data preparation, PivotTables, PivotCharts, dashboards, Power Query, data modeling, relationships, advanced lookup functions (VLOOKUP and XLOOKUP), conditional formatting, and a variety of data visualization techniques. You will also learn how to analyze large datasets, automate data cleaning, create interactive dashboards, and generate actionable business reports. By the end of the course, you will be able to confidently use Excel as a powerful data analysis and business intelligence tool for informed decision-making.
Advanced Excel for Data Analysis
-
1
Casharka 1Aad - Course Introduction -
2
Casharka 2Aad- Adjusting Data
-
3
Casharka 3Aad - Creating Pivot Table
-
4
Casharka 4Aad- Pivot Chart Part 1
-
5
Casharka 5Aad Pivot Chart Part 2
-
6
Casharka 6Aad - Customizing Pivot Table
-
7
Casharka 7Aad -Sorting Pivot Table
-
8
Casharka 8Aad- Grouping Pivot Table
-
9
Casharka 9Aad - Filtering Pivot Table
-
10
Casharka 10Aad - Changing Calculations
-
11
Casharka 11Aad- Adding Percentages
-
12
Casharka 12Aad - Running Total In
-
13
Casharka 13Aad - Refreshing Pivot Table
-
14
Casharka 14Aad - Frequency
-
15
Casharka 15Aad- Bie Chart
-
16
Casharka 16Aad - Cross Tabulation
-
17
Casharka 17Aad - Conditional Format
-
18
Casharka 18Aad Line Chart Part 1
-
19
Casharka 19Aad -Line Chart Part 2
-
20
Casharka 20Aad - Doughnut Chart
-
21
Casharka 21Aad - Adding Slicers
-
22
Casharka 22Aad- Text To Columns
-
23
Casharka 23Aad - Creating Dashboard Part 1
-
24
Casharka 24Aad - Creating Dashboard Part 2
-
25
Casharka 25Aad - Analysing Dashboard Report
-
26
Casharka 26Aad - Power Query Editor
-
27
Casharka 27Aad - Change Type Power Query Editor
-
28
Casharka 28Aad - Inserting Csv File
-
29
Casharka 29Aad - Frequency Pivot Table Analysis
-
30
Casharka 30Aad- Frequency In Excel Functions Analysis Part 1
-
31
Casharka 31Aad- Extracting Excel File
-
32
Casharka 32Aad - Creating Relationship
-
33
Casharka 33Aad - Adding Measures
-
34
Casharka 34Aad- Merge And Queries
-
35
Casharka 35Aad - Vlookup -Relationship
-
36
Casharka 36Aad - Data Modeling -Relationship Recap
-
37
Casharka 37Aad - Xlookup
-
38
Casharka 38Aad - Pivot Table Analysis
-
39
Casharka 39Aad- Pivot Chart
-
40
Casharka 40Aad - Creating Dashboard Part 1
-
41
Casharka 41Aad -Creating Dashboard Part 2
-
42
Casharka 42Aad - Creating Dashboard Part 3
-
43
Casharka 43Aad- Summurizing Final Dashboard
-
44
Files of the Course
Be the first to add a review.
Please, login to leave a review
