الرئيسية
الدورات التدريبية
Microsoft Excel for first and second managerial level
AI Wave Shape

Microsoft Excel for first and second managerial level

اعمل بيزنس ميديكال

In this course we will deep diving in Excel tools , Will learn more new techniques in organizing , sorting and filtering data which will help a lot in working with huge data and also you will learn a lot about protect your excel sheet and workbooks .

عدد الساعات

0 ساعات

عدد المحاضرات

28 محاضرة

اللغة للدورة

اللغة العربية

اسم المحاضر

مينا مراد

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

•In this course we will deep diving in Excel tools , Will learn more new techniques in organizing , sorting and filtering data which will help a lot in working with huge data and also you will learn a lot about protect your excel sheet and workbooks

•You will also learn many important formulas which can help you get any calculation needed and will save a lot of time and effort

•And finally we will deeply focus in daily bases worksheets such as ( sales sheet , coverage, sheet, Visits planning and reporting , charts , etc )

•And eventually you will learn how to analyze your Product sales , team Performance , area performance and get control in every single item

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

Lecture One

مدة المحاضرة: 02:59:07 دقيقة
نظري و عملي
Lecture Icon 001 Getting started
Sound Icon
Clock Icon 21:14
Lecture Icon 002 Getting started (2)
Sound Icon
Clock Icon 13:46
Lecture Icon 003 Sorting
Sound Icon
Clock Icon 14:11
Lecture Icon 004 Sorting (2)
Sound Icon
Clock Icon 12:18
Lecture Icon 005 filtering
Sound Icon
Clock Icon 17:00
Lecture Icon 006 filtering (2)
Sound Icon
Clock Icon 13:54
Lecture Icon 007 Conditional Formatting Advanced
Sound Icon
Clock Icon 15:40
Lecture Icon 008 Conditional Formatting Advanced (2)
Sound Icon
Clock Icon 17:16
Lecture Icon 09 Work With Text
Sound Icon
Clock Icon 16:35
Lecture Icon 010 Every Possible Way To Protect Your Sheet
Sound Icon
Clock Icon 17:35
Lecture Icon 011 Printing Sheets Tricks
Sound Icon
Clock Icon 19:38

Lecture Two

مدة المحاضرة: 01:37:42 دقيقة
نظري و عملي
Lecture Icon 01 Sum product
Sound Icon
Clock Icon 7:45
Lecture Icon 02 If , Nested If
Sound Icon
Clock Icon 17:45
Lecture Icon 03 If and , if or
Sound Icon
Clock Icon 11:27
Lecture Icon 04 Sum if , Sum ifs , Count if , Count ifs , Average if , Average ifs
Sound Icon
Clock Icon 25:50
Lecture Icon 05 Vlook up , Hlook up , if error
Sound Icon
Clock Icon 11:43
Lecture Icon 06 index - match
Sound Icon
Clock Icon 9:40
Lecture Icon 07 Date function , Tracing
Sound Icon
Clock Icon 13:32

Lecture Three

مدة المحاضرة: 02:41:47 دقيقة
نظري و عملي
Lecture Icon 01 Create And Manage Doctor List
Sound Icon
Clock Icon 24:44
Lecture Icon 02 Visit Plan And Reports Sheets (Working Automatically )
Sound Icon
Clock Icon 22:48
Lecture Icon 003 Visit Plan And Reports Sheets (Working Automatically ) ( 2 )
Sound Icon
Clock Icon 12:55
Lecture Icon 04 Sales Sheets
Sound Icon
Clock Icon 17:54
Lecture Icon 05 Sales Tracking Chart
Sound Icon
Clock Icon 21:39
Lecture Icon 06 MarketShare
Sound Icon
Clock Icon 12:19
Lecture Icon 007 Sparklines 007
Sound Icon
Clock Icon 04:18
Lecture Icon 08 pivotTable
Sound Icon
Clock Icon 15:18
Lecture Icon 09 pivotTable (2) 009
Sound Icon
Clock Icon 10:58
Lecture Icon 010 pivotTable (3)
Sound Icon
Clock Icon 18:54

Final Exam

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

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

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