This curriculum is designed for small business owners, freelancers, and entrepreneurs who want to use Google Sheets to manage their business without advanced accounting software.
Module 1: Getting Started
- Introduction to Google Sheets
- Creating and organizing spreadsheets
- Rows, columns, sheets & formatting
- Sharing and collaboration
Module 2: Business Data Management
- Customer database
- Product & inventory list
- Supplier records
- Data validation (drop-down menus)
Module 3: Essential Formulas
- SUM, AVERAGE, MIN, MAX
- IF, IFS
- COUNT, COUNTA
- ROUND
- Basic error handling
Module 4: Sales & Finance
- Sales tracker
- Daily cash book
- Expense tracker
- Profit & loss statement
- Budget planning
Module 5: Inventory Management
- Stock in/out
- Automatic stock balance
- Low-stock alerts
- Barcode-friendly setup
Module 6: Charts & Dashboards
- Bar, line & pie charts
- KPI dashboard
- Monthly sales analysis
Module 7: Automation
- Conditional formatting
- Filter & sort
- Pivot tables
- Basic AI features in Google Sheets
Module 8: Real Business Projects
- Retail shop management
- Service business invoice tracker
- Online business order management
- Complete entrepreneur dashboard
What students will build
- Sales Management System
- Expense & Budget Tracker
- Inventory Management Sheet
- Profit & Loss Dashboard
- Customer CRM (basic)