1. Introduction to Google Sheets

• What is Google Sheets?
• Google Sheets vs. Microsoft Excel
• Navigating the Google Sheets Interface
• Creating, Opening & Saving Spreadsheets
• Sharing & Collaborating in Google Sheets

2. Basic Spreadsheet Operations

• Entering & Formatting Data
• Cell Referencing (Relative, Absolute, Mixed)
• Data Validation & Drop-down Lists
• Conditional Formatting & Custom Rules
• Sorting & Filtering Data

3. Formulas & Functions (Basic to Advanced)

3.1 Basic Functions

• SUM, AVERAGE, MIN, MAX
• COUNT, COUNTA, COUNTIF, COUNTIFS

3.2 Logical & Lookup Functions

• IF, AND, OR, NOT
• VLOOKUP, HLOOKUP, XLOOKUP
• INDEX-MATCH & ARRAYFORMULA

3.3 Text Functions

• CONCATENATE, TEXTJOIN
• LEFT, RIGHT, MID
• LEN, TRIM, PROPER, UPPER, LOWER

3.4 Date & Time Functions

• TODAY, NOW
• YEAR, MONTH, DAY, HOUR, MINUTE, SECOND
• DATE, TIME, TEXT for Date Formatting

3.5 Financial & Statistical Functions

• ROUND, CEILING, FLOOR
• RANK, MEDIAN, MODE
• PV, FV, PMT for Financial Calculations

4. Data Analysis & Visualization

• Creating & Customizing Charts (Bar, Pie, Line, Scatter)
• Pivot Tables & Pivot Charts
• Data Consolidation & Summarization
• Using Slicers in Pivot Tables

5. Advanced Google Sheets Features

• Named Ranges & Data Tables
• Goal Seek & Solver for Data Analysis
• Importing Data from External Sources (CSV, Google Drive)
• Linking Data Across Multiple Sheets

6. Automation with Google Sheets

6.1 Google Apps Script (Basics)

• Introduction to Google Apps Script
• Writing Simple Macros & Scripts
• Automating Repetitive Tasks

6.2 Data Connections & Integrations

• ImportRange, ImportData, ImportXML, ImportHTML
• Connecting Google Sheets with Google Forms, Google Docs, and Google Calendar

7. Collaboration & Security in Google Sheets

• Real-time Editing & Commenting
• Version History & Restoring Data
• Protecting Sheets & Cell Ranges
• Managing Access & Permissions

8. Advanced Data Processing & Dashboards

• Creating Interactive Dashboards
• Using Google Data Studio for Visualization
• Embedding Sheets in Websites & Reports

9. Real-Time Projects & Case Studies

• Business Financial Analysis
• Sales & Inventory Management
• Employee Attendance & Payroll Sheets
• Budgeting & Expense Tracking