Class 01
Map your use cases on paper
- List the workflows and reports you actually need
- Prioritize what to build first in Sheets
- Agree scope for the 24-class program
For MSME owners
Learn Google Sheets, AppSheet, and Looker Studio — then build what your business needs.
Live 1:1 coaching with Shyam — tools + system thinking applied to your use cases (inventory, attendance, CRM, tasks, and more). Leave with working Sheets, apps, and dashboards — not a fixed module checklist.
Instructor: Shyam Kumar Banjare
Format
How the program works
Not a jobseeker career course. Built for owners who want clean data, staff-ready apps, and live management views — taught on Google Sheets, AppSheet, and Looker Studio. No Graphy checkout — enroll and pay here.
- 24 live 1:1 sessions with Shyam — not a recorded binge course
- 1.5 hours each (36 hours) · weekly 2 sessions at 8:30–10:00 AM IST
- Choose your cohort: Monday + Friday, or Tuesday + Saturday
- Pay ₹35,000 on this page (UPI / PhonePe) — owner confirms payment, then slots are booked
- Stack: Google Sheets + AppSheet + Looker Studio — applied to your business use cases
- After training: optionally run ops in Sheetomatic Workspace if you want software, not only Sheets
Curriculum
24 classes across Sheets, AppSheet, and Looker
Each class is 1.5 hours. Outcomes follow your use cases — inventory, attendance, CRM, tasks, and more — on Google Sheets, AppSheet, and Looker Studio.
Classes 1–8
Google Sheets foundations
Clean data models, formulas, and structures you can trust for daily ops and reporting.
Class 02
Sheet structure that scales
- Design master tables vs working tabs
- Use IDs, statuses, and owners cleanly
- Avoid broken IMPORTRANGE / formula sprawl
Class 03
Core formulas for MSME ops
- LOOKUP, FILTER, QUERY, and ARRAY patterns
- Date math and status logic
- Validation that staff can enter safely
Class 04
Ops tracker build (your use case)
- Build one live tracker from your data
- Add planned vs actual style columns if useful
- Hand off a sheet your team can update daily
Class 05
Multi-sheet architecture
- Split intake, master, and dashboard data
- Keep one source of truth
- Document how staff should enter data
Class 06
Automation light in Sheets
- Simple Apps Script or native automation hooks
- Reminders and status flags
- Protect ranges without blocking work
Class 07
Team-ready entry forms
- Design easy entry tabs for non-technical staff
- Dropdowns, checks, and required fields
- Reduce training time for new joiners
Class 08
Sheets review & harden
- Fix edge cases from real data
- Lock what must not break
- Decide what moves to AppSheet next
Classes 9–16
AppSheet mobile apps
Turn your Sheets into mobile apps your team will actually open.
Class 09
AppSheet from your Sheet
- Connect the right tables
- Choose views for phone vs desktop
- Ship a first working prototype
Class 10
Forms and actions
- Capture entries on mobile
- Buttons for common status updates
- Photos / files when proof is needed
Class 11
Security and roles
- Who can see or edit what
- Slice data by person or team
- Keep owner visibility without chaos
Class 12
Workflows and notifications
- Bots for status changes
- Email / push where useful
- Avoid alert spam
Class 13
Use-case app deep dive (part 1)
- Build the primary app for your business
- Refine UX with real staff feedback
- Fix slow views and clutter
Class 14
Use-case app deep dive (part 2)
- Add secondary flows (approvals, follow-ups)
- Offline / field realities
- Go-live checklist for the team
Class 15
AppSheet admin habits
- Version and backup discipline
- Change requests without breaking production
- Train one internal app owner
Class 16
AppSheet review & harden
- Performance and error pass
- Document how to add a column safely
- Decide Looker reporting needs
Classes 17–24
Looker Studio dashboards
Owner-ready dashboards from your Sheets — exceptions and KPIs without spreadsheet archaeology.
Class 17
Dashboard goals for owners
- Pick the 5–7 numbers that matter weekly
- Exceptions first, not every row
- Match charts to decisions
Class 18
Connect Looker to Sheets
- Stable data ranges for Looker
- Refresh and cache basics
- Avoid fragile pivot exports
Class 19
Build your first Looker report
- Scorecards, tables, and filters
- Date controls that work
- Share with the right people
Class 20
Multi-page owner pack
- Ops, sales, and inventory-style pages as needed
- Consistent branding and layout
- Mobile-friendly viewing
Class 21
Calculated fields & blends
- Rates, deficits, and comparisons
- Blend only when necessary
- Keep metrics explainable
Class 22
Use-case dashboards deep dive
- Finish dashboards for your real data
- Validate numbers against Sheets
- Owner walkthrough script
Class 23
Weekly review rhythm
- How to run a short review from Looker
- What staff prepare vs what auto-updates
- Close the loop back into Sheets / AppSheet
Class 24
Go-live & handoff
- Hypercare checklist for 7 days
- Train your internal Sheets / AppSheet / Looker owner
- Document next builds after the program
Enroll
₹35,000 · 36 hours live 1:1
Mon+Fri or Tue+Sat · 8:30 AM – 6:00 PM IST. Pay on this page · owner confirms · slots booked
Free previews
Sheets, AppSheet, and Looker Studio
Free Sheetomatic Videos that match the stack — Google Sheets discipline, AppSheet apps, and Looker Studio dashboards.
No-code apps from Google Sheets — forms, views, and staff UX.
Clean backends, owners, and stage tracking — system thinking in Sheets.
Raw data to smart dashboard — management boards owners can read.
Sheetomatic Videos
Learn from the channel
Browse the free library by topic. Paid 1:1 coaching turns these into your live business system.
FMSAI Enabled Flow Monitoring System (FMS) for MSMEs | AI FMS: Dashboard for PC & EA | BCI
WhatsAppAssign Tasks Automatically Using AI + WhatsApp | Employees Can Update Tasks Directly from WhatsApp
EM/MISBuild a Payment & Follow-up Dashboard in Google Sheets | Step-by-Step Automation Guide
FMSHow to Build FMS System in AppSheet | Stop Manual Work | Without Script & Formula
Tasks/EABuild Your Own Task Manager | Google Sheets + AppSheet (No Coding)
AppSheet/SheetsHow to Build Your Own CRM in AppSheet
IMSBuild Smart Inventory Management App | AppSheet with Google Sheets
WhatsAppSend Product Catalogs on WhatsApp using QR Codes
AppSheet/SheetsGoogle Sheets Full Course Tutorial (4+ Hours)
Checklists/PCField Executive Tracking App Using AppSheet
Checklists/PCAttendance & Leave Management System in AppSheet
IMSHow to Build a Purchase Order System in AppSheetNext step
Free video → pay & book slots → build your stack
Start with YouTube. Pay ₹35,000 on this page, pick Mon+Fri or Tue+Sat mornings, and ship Sheets + AppSheet + Looker for your business. Optionally run ops later in Sheetomatic Workspace.
Start on WhatsApp
Build a business that scales without you.
BCI Suite brings FMS, IMS, Full Kitting, Process Coordinator, Executive Assistant, and Review Rhythm into one operating system. One conversation to replace spreadsheet firefighting with owner clarity.