Google systems specialist


Create a spreadsheet


Spreadsheet Basics

  • Row and columns

  • Cells

  • Ranges

  • Formulas

  • Exponents and parentheses

  • Percentages

  • Comparison operators

  • Data types: text and numbers

  • Data types: currency and date

  • Data types: logic


Conditional Formatting


Data validation


Protection


Share Techniques


How to create google form

  • Google form


Math formulas 

  • Sum-sumif-sumifs

  • Average- averageif- averageifs

  • Min-minif-minifs

  • Max- maxif-maxifs 

  • Count a - Count- Countif- Countifs 


Logical function 

  • If - ifs - iferror 

  • Or- and 


Absolute reference 

Date formulas

Text formulas


Array & Importrange

  • ARRAY & TRANSPOSE

  • IMPORTRANGE


Filter 

  • Filter- sort- unique 


Lookup

  • Lookup-vlookup-Hlookup

  • Index- match



$299


Order