AI Wave Shape
اعمل بيزنس ميديكال

Microsoft Excel-Advanced for top management

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 ..

Pharmaceutical Marketing
Pharmaceutical Industry

محتوي البرنامج

شهادة معتمدة

شهادة معتمدة

شهادة إتمام معتمدة تُمنح بعد إكمال الدورة بنجاح.

إمكانية الوصول

إمكانية الوصول

إمكانية الوصول الكامل للدورة عبر الهاتف أو التابلت

Quiz Icon

اختبارات قصيرة

اختبارات قصيرة لتقييم فهمك بعد كل وحدة دراسية

ملف مشروع

ملف مشروع

ملف مشروع عملي لتطبيق ما تعلّمته خطوة بخطوة.

وصف الدورة التدريبية

•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 

مينا مراد

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 ..

محاور الدورة التدريبية

•10 techniques to deal with big data

•Conditional Formatting (A to Z)

•Data Sorting (advanced techniques)

•Data Filtering (advanced techniques)

•Build data outlines and Groups

•Protection workbooks and worksheets

مراجع مساعدة

جميع محاضراتك بالدورة

Lecture One

مدة المحاضرة: 00:41:31
نظري و عملي
Lecture Icon 01 Technique to deal with big data
Sound Icon
Clock Icon 11:12
Lecture Icon 02 Technique to deal with big data (2)
Sound Icon
Clock Icon 11:02
Lecture Icon 03 Conditional Formatting (A to Z )
Sound Icon
Clock Icon 09:22
Lecture Icon 04 Data Filtering (Advanced Techniques)
Sound Icon
Clock Icon 09:55

Lecture Two

مدة المحاضرة: 03:29:21
نظري و عملي
Lecture Icon 01 Sum - Subtotal
Sound Icon
Clock Icon 03:34
Lecture Icon 02 If formula
Sound Icon
Clock Icon 24:06
Lecture Icon 03 sumif formula
Sound Icon
Clock Icon 20:20
Lecture Icon 04 sumif formula 2
Sound Icon
Clock Icon 07:03
Lecture Icon 05 index - match formula
Sound Icon
Clock Icon 14:02
Lecture Icon 06 أداة pivotTable
Sound Icon
Clock Icon 18:31
Lecture Icon 07 pivotTable tools
Sound Icon
Clock Icon 15:36
Lecture Icon 08 Pivot Table Advanced Tips and Tricks
Sound Icon
Clock Icon 17:33
Lecture Icon 09 Pivot Table Advanced Tips and Tricks ( 2)
Sound Icon
Clock Icon 21:05
Lecture Icon 10 Pivot Table With Many Different Resource
Sound Icon
Clock Icon 13:59
Lecture Icon 11 Pivot Table With Many Different Resource (2)
Sound Icon
Clock Icon 17:36
Lecture Icon 12 Consolidation
Sound Icon
Clock Icon 06:44
Lecture Icon 13 Advanced Technique in using charts
Sound Icon
Clock Icon 15:03
Lecture Icon 14 Advanced Technique in using charts (2)
Sound Icon
Clock Icon 14:09

Lecture Three

مدة المحاضرة: 00:42:12
نظري و عملي
Lecture Icon 01 Create Scenarios and Compare between different business scenarios
Sound Icon
Clock Icon 18:02
Lecture Icon 02 Create Scenarios and Compare between different business scenarios (2)
Sound Icon
Clock Icon 09:44
Lecture Icon 03 Goal Seek assistant tool
Sound Icon
Clock Icon 14:26

Final Exam

يمكنك الآن تنمية فريقك في اي مجال

تعلّم وتطوّر في الموارد البشرية، الإدارة، التسويق، وغيرها.

احجز عرضًا توضيحيًا الآن