Google Sheet Training

📌 Module 1:  Introduction to Google Sheets

Google Sheets কী ও কোথায় ব্যবহার হয়

Google Drive থেকে নতুন Sheet তৈরি

Interface পরিচিতি (Menu, Toolbar, Formula bar, Sheet tabs)

Rows, Columns, Cells বোঝা

Data types: Text, Number, Date

Sheets Interface Overview

Cells, Rows & Columns

Menu & Toolbar Options

Language Settings

Version History Recovery

📌 Module 2: Basic Data Handling

Data entry ও edit করা

Copy, Paste, Drag Fill

Undo/Redo

Row/Column Insert, Delete

Sheet Rename, Duplicate

📌 Module 3: Formatting Basics

Font, Size, Color

Cell Background

Borders ব্যবহার

Number format (Currency, %, Date)

Text wrap & alignment

📌 Module 4: Basic Formulas

Formula কী

 = ব্যবহার

Basic Operators (+, –, *, /)

Basic Formulas

SUM

AVERAGE

MIN, MAX

COUNT, COUNTA, Countunique

📌 Module 5: Relative vs Absolute Cell Reference

A1 vs $A$1

📌 Module 6: Important Functions

IF

COUNTIF

SUMIF

CONCAT / TEXTJOIN

ROUND

📌 Module 7: Data Management

Sort

Filter

Filter Views

Remove duplicates

📌 Module 8: Data Validation

Dropdown list তৈরি

📌 Module 9: Lookup & Reference Functions

VLOOKUP

📌 Module 10: Pivot Table

Pivot table কী

Create Pivot

Rows, Columns, Values

Filter in Pivot

Summary reports

🧠 FINAL PROJECT IDEAS

Sales Report Dashboard

Charts & Visualization

📌 Module 1:  Introduction to Google Sheets

Google Sheets কী ও কোথায় ব্যবহার হয়

Google Drive থেকে নতুন Sheet তৈরি

Interface পরিচিতি (Menu, Toolbar, Formula bar, Sheet tabs)

Rows, Columns, Cells বোঝা

Data types: Text, Number, Date

Sheets Interface Overview

Cells, Rows & Columns

Menu & Toolbar Options

Language Settings

Version History Recovery

📌 Module 2: Basic Data Handling

Data entry ও edit করা

Copy, Paste, Drag Fill

Undo/Redo

Row/Column Insert, Delete

Sheet Rename, Duplicate

📌 Module 3: Formatting Basics

Font, Size, Color

Cell Background

Borders ব্যবহার

Number format (Currency, %, Date)

Text wrap & alignment

📌 Module 4: Basic Formulas

Formula কী

 = ব্যবহার

Basic Operators (+, –, *, /)

Basic Formulas

SUM

AVERAGE

MIN, MAX

COUNT, COUNTA, Countunique

📌 Module 5: Relative vs Absolute Cell Reference

A1 vs $A$1

📌 Module 6: Important Functions

IF

COUNTIF

SUMIF

CONCAT / TEXTJOIN

ROUND

📌 Module 7: Data Management

Sort

Filter

Filter Views

Remove duplicates

📌 Module 8: Data Validation

Dropdown list তৈরি

📌 Module 9: Lookup & Reference Functions

VLOOKUP

📌 Module 10: Pivot Table

Pivot table কী

Create Pivot

Rows, Columns, Values

Filter in Pivot

Summary reports

📌 Module 11: Advanced Logical & Array Functions

Nested IF

IFS

ARRAYFORMULA

FILTER function

UNIQUE

SORT function

📌 Module 12: Charts & Visualization

Bar, Column, Pie, Line chart

Data range selection

Chart customization

Dashboard concept

📌 Module 13: Working with Multiple Sheets

IMPORTRANGE

Linking sheets

Cross-sheet formulas

📌 Module 14: Collaboration Tools

Share & Permission

Comments

Suggestion mode

Version history

📌 Module 15: Advanced Data Tools

Query function

Split text

Text to columns

Remove extra spaces

📌 Module 16: Dynamic Array Tec

Index Match (Advanced)

Multiple Headers Match

Arrayformula Mastery

Indirect Function

Sequence & Random Data

📌 Module 17: Introduction to Automation

Macros

Record a macro

Basic Apps Script concept

🧠 FINAL PROJECT IDEAS

Sales Report Dashboard

Student Result Sheet

Expense Tracker

Inventory Management Sheet

📌 Module 1: Basic Formulas

Formula কী

 = ব্যবহার

Basic Operators (+, –, *, /)

Basic Formulas

SUM

AVERAGE

MIN, MAX

COUNT, COUNTA, Countunique

📌 Module 2: Relative vs Absolute Cell Reference

A1 vs $A$1

📌 Module 3: Important Functions

IF

COUNTIF

SUMIF

CONCAT / TEXTJOIN

ROUND

📌 Module 4: Data Management

Sort

Filter

Filter Views

Remove duplicates

📌 Module 5: Data Validation

Dropdown list তৈরি

📌 Module 6: Lookup & Reference Functions

VLOOKUP

📌 Module 7: Pivot Table

Pivot table কী

Create Pivot

Rows, Columns, Values

Filter in Pivot

Summary reports

📌 Module 8: Advanced Logical & Array Functions

Nested IF

IFS

ARRAYFORMULA

FILTER function

UNIQUE

SORT function

📌 Module 9: Charts & Visualization

Bar, Column, Pie, Line chart

Data range selection

Chart customization

Dashboard concept

📌 Module 10: Working with Multiple Sheets

IMPORTRANGE

Linking sheets

Cross-sheet formulas

📌 Module 11: Collaboration Tools

Share & Permission

Comments

Suggestion mode

Version history

📌 Module 12: Advanced Data Tools

Query function

Split text

Text to columns

Remove extra spaces

📌 Module 13: Dynamic Array Tech

Index Match (Advanced)

Multiple Headers Match

Arrayformula Mastery

Indirect Function

Sequence & Random Data

📌 Module 14: Introduction to Automation

Macros

Record a macro

Basic Apps Script concept

📌 Module 15: Departments Wise Report Create

✔ Accounts & Finance Department

✔ HR & Admin Department

✔ Sales & Marketing Department

✔ Supply Chain / Procurement

✔ Logistics / Deport / Store

✔ Production & Operations

✔ Banking & Corporate Office

✔ NGO & Development Sector

✔ Small Business Owners

✔ IT & Data Entry Professionals

✔ Government & Private Company

🧠 FINAL PROJECT IDEAS

Sales Report Dashboard

Student Result Sheet

Expense Tracker

Inventory Management Sheet