In the advanced level of Microsoft Excel Course we will heavily focus in dealing with Huge data , how to handle , sort , filter and organize it in advanced techniques We will also deep diving in the world of Data Analysis by using Pivot Table and Chart ..
عدد الساعات
0 ساعات
عدد المحاضرات
21 محاضرة
اللغة للدورة
اللغة العربية
اسم المحاضر
مينا مراد
•In the advanced level of Microsoft Excel Course we will heavily focus in dealing with Huge data , how to handle , sort , filter and organize it in advanced techniques
•We will also deep diving in the world of Data Analysis by using Pivot Table and Chart and will work with single and multi data source in addition to group of advanced analysis tools for creating many business scenarios and compare between them to pick the right one for my business
01 Technique to deal with big data
11:12
02 Technique to deal with big data (2)
11:02
03 Conditional Formatting (A to Z )
09:22
04 Data Filtering (Advanced Techniques)
09:55
01 Sum - Subtotal
03:34
02 If formula
24:06
03 sumif formula
20:20
04 sumif formula 2
07:03
05 index - match formula
14:02
06 أداة pivotTable
18:31
07 pivotTable tools
15:36
08 Pivot Table Advanced Tips and Tricks
17:33
09 Pivot Table Advanced Tips and Tricks ( 2)
21:05
10 Pivot Table With Many Different Resource
13:59
11 Pivot Table With Many Different Resource (2)
17:36
12 Consolidation
06:44
13 Advanced Technique in using charts
15:03
14 Advanced Technique in using charts (2)
14:09
01 Create Scenarios and Compare between different business scenarios
18:02
02 Create Scenarios and Compare between different business scenarios (2)
09:44
03 Goal Seek assistant tool
14:26
اكثر من 688 + دورة تدريبية متاحة لجميع طلابنا
تعلّم وتطوّر في الموارد البشرية، الإدارة، التسويق، وغيرها.
احجز عرضًا توضيحيًا الآن
.jpg)