Google Systems
How to Using Google Spreadsheets to Make Administration systems
ماذا سوف أتعلم؟
- 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
3 درس
00:07:48 ساعة
- Spreadsheet Basics 1 00:05:17
- Spreadsheet Basics 2 00:02:31
- Choose the best response for each one
Conditional Formatting
2 درس
00:02:43 ساعة
- Conditional Formatting 00:02:43
- Choose the best response for each one
Data validation
2 درس
00:01:57 ساعة
- Data validation 00:01:57
- Choose the best response for each one
Protection
2 درس
00:02:21 ساعة
- Protected option 00:02:21
- Choose the best response for each one
Share Techniques
2 درس
00:01:44 ساعة
- Share Techniques 00:01:44
- Choose the best response for each one
How to create google form
2 درس
00:05:51 ساعة
- Google form 00:05:51
- Choose the best response for each one
Math formulas
4 درس
00:18:10 ساعة
- 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
Logical function
3 درس
00:08:03 ساعة
- IF& IFS&IFERROR 00:05:03
- OR & AND Function 00:03:00
- Choose the best response for each one
Absolute reference
2 درس
00:01:25 ساعة
- Absolute reference 00:01:25
- Choose the best response for each one
Date
2 درس
00:08:04 ساعة
- Date formulas 00:08:04
- Choose the best response for each one
Text
2 درس
00:05:59 ساعة
- Text formulas 00:05:59
- Choose the best response for each one
Array & Importrange
3 درس
00:04:13 ساعة
- ARRAY & TRANSPOSE 00:02:07
- IMPORTRANGE 00:02:06
- Choose the best response for each one
FILTER
2 درس
00:04:15 ساعة
- FILTER & SORT & UNIQUE 00:04:15
- Choose the best response for each one
Lookup
3 درس
00:10:30 ساعة
- 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 .
+ عرض المزيد
دورات متعلقة
عن المحاضر
- 23 التقيم
- 1473 الطلاب
- 15 الدورات
رأي الطلاب
التقيم
-
Sun, 08-Dec-2019Et3lm Online -
Thu, 23-Jan-2020AHMED HASSAN
-
Fri, 25-Jun-2021محمد أبو حمزة
