Skip to content
Tuesday, October 27, 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

Google Sheets

Google Sheets Templates

Subscription Box Management System Web App

October 27, 2026PKComments Off on Subscription Box Management System Web App

A Google Apps Script web app for subscription box companies: subscribers, plans, box curation, stock, shipping, renewals, dunning and churn, with a live demo for every role login.

Dashboard Google Sheets

School Dashboard in Google Sheets: Build an App-Style Dashboard with Formulas (Free)

October 27, 2026PKComments Off on School Dashboard in Google Sheets: Build an App-Style Dashboard with Formulas (Free)

Free school dashboard in Google Sheets: build a clickable menu, KPI cards, attendance heat map, SORTN top 3 and a month dropdown with formulas only.

Google Sheets

Google Sheets Checkbox: Cross Out Done Tasks and Show % Done (Free Sheet)

October 27, 2026PKComments Off on Google Sheets Checkbox: Cross Out Done Tasks and Show % Done (Free Sheet)

Add a Google Sheets checkbox to a task list, cross out finished rows with a custom formula rule, and show % done with one COUNTIF. Free practice sheet.

Dashboard Google Sheets

Financial Auditing Dashboard in Google Sheets

October 22, 2026PKComments Off on Financial Auditing Dashboard in Google Sheets

An audit dashboard in Google Sheets with 4 KPI cards, 15 slicers and 18 charts over 500 sample engagements from 6 offices, 8 partners and 8 industries.

Dashboard Google Sheets

Loan Tracker Google Sheets: Build a Loan & EMI Tracker with Overdue Alerts (Free)

October 22, 2026PKComments Off on Loan Tracker Google Sheets: Build a Loan & EMI Tracker with Overdue Alerts (Free)

Free loan tracker Google Sheets template: build a loan and EMI tracker with PMT, FV, EDATE, SPARKLINE repaid bars and Overdue / Due Soon / On Track badges.

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.

Dashboard Google Sheets

Budget Dashboard Google Sheets: Build a Monthly Budget vs Actual Tracker (Free)

October 20, 2026PKComments Off on Budget Dashboard Google Sheets: Build a Monthly Budget vs Actual Tracker (Free)

Free budget dashboard Google Sheets template: build a monthly budget vs actual tracker with XLOOKUP, SUMIFS and EOMONTH, ARRAYFORMULA, SPARKLINE progress bars and Over / Watch / OK badges.

Dashboard Google Sheets

Dairy Dashboard in Google Sheets: Sales, Plants and Quality

October 18, 2026PKComments Off on Dairy Dashboard in Google Sheets: Sales, Plants and Quality

A dairy dashboard in Google Sheets with 4 KPI cards, 15 slicers and 17 charts over 500 sample orders from 6 plants, 8 products and 12 customers.

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.

Posts pagination

1 2 … 206 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