Google Sheets Course: From Beginner to Expert

course thumbnail
PRICE

$133.41

$11.99

91.01% off
Description

Know About Your Trainer - This Google Sheets Recorded course is designed and led by Ms. Tanu Singhal, a highly skilled data professional with over 3 years of corporate experience as a Senior Data Analyst. In addition to her industry expertise, she has successfully trained more than 5,000 students as a freelance instructor, helping them master data tools and techniques used in real-world business environments.
Module 1: Getting Started – The Basics

  • • What is Google Sheets? (Difference from Excel)
  • • Understanding the interface
  • • Creating, renaming, saving sheets
  • • Rows, Columns, and Cells – how they work
  • • Entering data and basic formatting (bold, color, alignment)
  • • Freezing rows/columns
  • • Basic formulas: SUM, AVERAGE, COUNT, MAX, MIN

Module 2: Smarter Work – Functions & Formatting

  • • Text Functions: LEFT, RIGHT, SPLIT, LEN
  • • Date Functions: TODAY, NOW, DATEDIF
  • • Logical Functions: IF, AND, OR
  • • Lookup Functions: VLOOKUP, INDEX, MATCH
  • • Conditional Formatting (change colors based on conditions)
  • • Dropdown lists using Data Validation
  • • Adding Checkboxes

Module 3: Mastering the QUERY Function

  • • What is QUERY and why is it powerful?
  • • Simple SELECT and WHERE conditions
  • • Filtering data by text, number, and date
  • • Sorting data using ORDER BY
  • • Aggregating with SUM, COUNT, AVG
  • • Using GROUP BY in QUERY
  • • QUERY across different sheets using IMPORTRANGE

Module 4: Dashboards in Google Sheets

  • • What is a Dashboard? Why use it?
  • • Creating simple charts: Bar, Pie, Line
  • • Creating KPI cards using formulas
  • • Adding Slicers (Dropdown filters)
  • • Connecting QUERY results to charts
  • • Clean layout design for reports

Module 5: Sharing & Collaboration

  • • Share settings: View, Edit, Comment
  • • Protecting cells or ranges
  • • Adding comments & notes
  • • Version history & restoring changes
  • • Publishing Sheets as a website
  • • Sending sheets via email (PDF or Excel)

Module 6: Final Projects

  • • Sales Report Dashboard – With charts and filters
  • • Attendance Tracker – With checkboxes and summary
  • • Expense Tracker – With category-wise breakdown using QUERY
  • • Live Google Form Dashboard – Auto-updating data view

Loading...