Skip to content
Friday, October 23, 2026
  • About
  • Contact Us

Neotech Navigators

Online Tutorial for Data Analysis and Automation

  • Home
  • Google Sheets
    • Templates (NextGenTemplates)
    • Dashboards
    • KPI Dashboards
  • HTML Dashboards
  • Power BI
  • SQL Tutorial
    • All SQL chapters
  • Python Tutorial
  • Template Store
  • Courses
  • Academy
    • Excel + AI Mastery: 100 Formulas
    • Excel Pivot Tables & Dashboards
  • More
    • MS Word
    • PowerPoint
    • Excel Tutorials (PK-AnExcelExpert)
    • About
    • Contact

Templates

Google-Sheets-Templates

Google Sheets Templates

Loan & EMI Management System Web App: Run Your Whole Loan Book in Google Sheets

October 20, 2026PKComments Off on Loan & EMI Management System Web App: Run Your Whole Loan Book in Google Sheets

A loan and EMI management system web app on Google Apps Script: borrowers, KYC, EMI schedules, payments, late fees, aging and collections, with a live 6-role demo.

Google Sheets Templates

Restaurant Reservation Template in Google Sheets: Build a Table Reservation Tracker (Free)

October 17, 2026PKComments Off on Restaurant Reservation Template in Google Sheets: Build a Table Reservation Tracker (Free)

Free restaurant reservation template in Google Sheets: build a table reservation tracker with dropdowns, one XLOOKUP for section and seats, an IF seat check, a COUNTIFS double-booking check and summary cards.

Google Sheets Templates

Food Bank Management System Web App

October 16, 2026PKComments Off on Food Bank Management System Web App

A food bank management system web app on Google Apps Script: donations, lots by best-by date, partner agency orders with FEFO picking, households, volunteers, 28 reports and 7 roles, with live demo login details.

Google Sheets Templates

How to Build a Bakery Order Tracker in Google Sheets (Free Template)

October 15, 2026PKComments Off on How to Build a Bakery Order Tracker in Google Sheets (Free Template)

Build a bakery order tracker in Google Sheets step by step: item and status dropdowns, XLOOKUP prices, ARRAYFORMULA totals and balances, overdue pickup alerts, a SUMIFS bake list and summary cards. Free cake order template.

Google Sheets Templates

Training Matrix Template in Google Sheets: Employee Training Tracker

October 11, 2026PKComments Off on Training Matrix Template in Google Sheets: Employee Training Tracker

A training matrix template in Google Sheets: log every training once, get automatic expiry dates, days left and Valid / Due Soon / Expired status, plus an employee x course matrix that builds itself.

Google Sheets Templates

How to Build an Inventory Tracker in Google Sheets (Free Template)

October 9, 2026PKComments Off on How to Build an Inventory Tracker in Google Sheets (Free Template)

Build an inventory tracker in Google Sheets step by step: a stock log with dropdowns, XLOOKUP item names, Stock In and Stock Out with SUMIFS, current stock and value, reorder alerts with colors and KPI cards. Free practice file.

Google Sheets Templates

Warehouse Inventory Management System Web App

October 5, 2026October 10, 2026PKComments Off on Warehouse Inventory Management System Web App

A warehouse inventory management system web app on Google Apps Script: stock by bin, batch and expiry, FEFO pick and dispatch, cycle counts, barcode labels, 25 reports and 7 roles, with live demo login details.

Google Sheets Templates

How to Make a To Do List in Google Sheets with Checkboxes (Free Template)

October 2, 2026October 10, 2026PKComments Off on How to Make a To Do List in Google Sheets with Checkboxes (Free Template)

Build a Google Sheets to do list template step by step: checkboxes, Category and Priority dropdowns, automatic Overdue and Due Soon status, Days Left, KPI cards and a progress bar. Free template included.

Google Sheets Templates

SaaS MRR & Churn Tracker in Google Sheets

September 28, 2026October 10, 2026PKComments Off on SaaS MRR & Churn Tracker in Google Sheets

A one-page SaaS MRR and Churn Tracker in Google Sheets: live Total Active MRR, Active Customers and Churn Rate cards, four charts, and a 16-column account log with automatic LTV, ARPU per seat, Health Score and Risk.

Google Sheets Templates

Domain & Website Portfolio Tracker in Google Sheets

September 28, 2026October 10, 2026PKComments Off on Domain & Website Portfolio Tracker in Google Sheets

The Domain and Website Portfolio Tracker in Google Sheets keeps every domain cost, revenue, visitor count, renewal date and ROI on one shareable page.

Posts pagination

1 2 … 65 Next

Categories

  • AI
  • Dashboard
  • Formulas
  • Google Sheets
  • Google Sheets Templates
  • HTML Dashboard
  • KPI Dashboard
  • MS Word
  • Power BI
  • PowerPoint
  • Python
  • SQL
  • Templates
  • Windows

Popular Tutorials

  • Sales KPI Dashboard in Google Sheets
  • Dynamic Calendar with Holidays & Events
  • Multi-Location Inventory Management in Google Sheets
  • Attendance Sheet Template in Google Sheets
  • What is Power BI? A Beginner’s Guide
  • Cleaning Data with Power Query in Power BI
  • Complete Guide to SQL JOINs
  • How to Use Copilot in Windows 11

Free SQL Course

SQL from Scratch — a free, 31-chapter course from SELECT to window functions, with runnable examples and a final quiz.

Start the SQL course →

Browse all SQL chapters · All courses

Popular Tags

business KPI scorecard calendar template Checklist Template Customer Satisfaction Dashboard Template data analysis Database Data Visualization Google Apps Script Google Apps Script Management System Google Apps Script Web App Google Sheets Google Sheets calendar Google Sheets Dashboard Google Sheets Dashboard Template Google Sheets KPI Google Sheets KPI Dashboard google sheets kpi scorecard Google Sheets KPI template Google Sheets template Google Sheets Tracker Google Sheets tracker template Google Sheets Tutorial Healthcare HR Analytics HR Dashboard HTML Dashboard HTML Dashboard Template KPI Dashboard KPI Dashboard Google Sheets KPI Scorecard KPI tracking Learn SQL Performance Tracking personal finance Productivity Project management Spreadsheet Tips SQL Basics SQL for Beginners SQL Tutorial task management task tracker task tracking Web App Template
| Editorial by MysteryThemes.
  • Blog
  • Contact Us
  • About