Google Systems

How to Using Google Spreadsheets to Make Administration systems

Beginner
5(2 التقيم) 52 طلبة مسجلين
English بواسطة Et3lm اخر تحديث Tue, 26-May-2020
EGP699 EGP1999
ابدأ الدراسة الأن
يشمل:
  • 01:25:47 ساعة فيديو تحت الطلب
  • 37 درس
  • تصفح مدي الحياة
  • تصفح عبر الهاتف والكمبيوتر

الشهادة:
  • GOOGLE SYSTEMS SPECIALIST
ماذا سوف أتعلم؟
  • Learn Basic Options and Sharing Technics
  • Learn Google sheets formulas
  • Learn Array and Import concept
  • learn Logical Functions
  • Learn Date / Text / filter Functions

المنهج
37 درس 01:25:47 ساعة
How to create a spreadsheet
2 درس 00:02:44 ساعة
  • Create a spreadsheet 00:02:44
  • Choose the best response for each one
  • Spreadsheet Basics 1 00:05:17
  • Spreadsheet Basics 2 00:02:31
  • Choose the best response for each one
  • Conditional Formatting 00:02:43
  • Choose the best response for each one
  • Data validation 00:01:57
  • Choose the best response for each one
  • Protected option 00:02:21
  • Choose the best response for each one
  • Share Techniques 00:01:44
  • Choose the best response for each one
  • Google form 00:05:51
  • Choose the best response for each one
  • SUM & SUMIF & SUMIFS 00:03:09
  • AVERAGE & AVERAGEIF & AVERAGEIFS & MIN & MINIF & MINIFS & MAX & MAXIF & MAXIFS 00:11:02
  • COUNT & COUNTIF & COUNTIFS 00:03:59
  • Choose the best response for each one
  • IF& IFS&IFERROR 00:05:03
  • OR & AND Function 00:03:00
  • Choose the best response for each one
  • Absolute reference 00:01:25
  • Choose the best response for each one
  • Date formulas 00:08:04
  • Choose the best response for each one
  • Text formulas 00:05:59
  • Choose the best response for each one
  • ARRAY & TRANSPOSE 00:02:07
  • IMPORTRANGE 00:02:06
  • Choose the best response for each one
  • FILTER & SORT & UNIQUE 00:04:15
  • Choose the best response for each one
  • LOOKUP & VLOOKUP & HLOOKUP 00:07:32
  • INDEX & MATCH 00:02:58
  • Choose the best response for each one
المتطلبات
  • have a Google account
+ عرض المزيد
الوصف

  small business and large companies to build professional image and make big business processes very easy that make highly level from customers satisfaction with low cost and help them grow their profits .

+ عرض المزيد
دورات متعلقة
عن المحاضر
  • 21 التقيم
  • 1411 الطلاب
  • 15 الدورات
+ عرض المزيد
رأي الطلاب
5
متوسط التقيم
  • 0%
  • 0%
  • 0%
  • 0%
  • 100%
التقيم
  • Et3lm Online
    Sun, 08-Dec-2019
    Et3lm Online
  • AHMED HASSAN
    Thu, 23-Jan-2020
    AHMED HASSAN