Google Systems

How to Using Google Spreadsheets to Make Administration systems

Beginner
5(3 Ratings) 56 Students enrolled
English Created by Et3lm Last updated Tue, 26-May-2020
EGP699 EGP1999
Start learning now
Includes:
  • 01:25:47 Hours On demand videos
  • 37 Lessons
  • Full lifetime access
  • Access on mobile and tv

Certificate:
  • GOOGLE SYSTEMS SPECIALIST
What will i learn?
  • Learn Basic Options and Sharing Technics
  • Learn Google sheets formulas
  • Learn Array and Import concept
  • learn Logical Functions
  • Learn Date / Text / filter Functions

Curriculum for this course
37 Lessons 01:25:47 Hours
How to create a spreadsheet
2 Lessons 00:02:44 Hours
  • 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
Requirements
  • have a Google account
+ View more
Description

  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 .

+ View more
Other related courses
About the instructor
  • 23 Reviews
  • 1453 Students
  • 15 Courses
+ View more
Student feedback
5
Average rating
  • 0%
  • 0%
  • 0%
  • 0%
  • 100%
Reviews
  • Et3lm Online
    Sun, 08-Dec-2019
    Et3lm Online
  • AHMED HASSAN
    Thu, 23-Jan-2020
    AHMED HASSAN
  • محمد أبو حمزة
    Fri, 25-Jun-2021
    محمد أبو حمزة