Introduction to Google Spreadsheet
  • Introduction to the Course
  • Getting to Spreadsheet and Text Formatting
  • Advance Formatting
  • Cell Freeze, Filters and Data Format
  • Knowing about Google Spreadsheet
Function and Formula
  • Sum, Sumif and Sumifs
  • Average, Avergaeif and Averageifs
  • It is the Quiz Time: SUM & AVERAGE
  • Sharing and Making a Copy
  • Count, Counta
  • Concatenate, Left, Right and Len
  • Replace, Substitute, Find and Split
  • Let us Recap
  • Search, Join, Text and Value
  • Countblank, Sqrt, Floor, Rand and Randbetween
  • Floor, Ceiling, Subtotal, Count and Countifs
  • if
  • And, Or
  • Not, IsBlank
  • IsEmail, IfError
  • Vlookup
  • Quiz Time
  • Match and Index
  • Filter, Sort and Unique
  • Date
Dashboard 1
  • Restaurant Order Detail: Part 1
  • Restaurant Order Detail: Part 2
  • Restaurant Order Detail: Part 3
Dashboard 2
  • HR Tracker: Part 1
  • HR Tracker: Part 2
  • HR Tracker: Part 3
Dashboard 3
  • Sales Dashboard: Part 1
  • Sales Dashboard: Part 2
  • Sales Dashboard: Part 3
  • Sales Dashboard: Part 4
  • Sales Dashboard: Part 5