Skip to content
Saturday, September 26, 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
  • More
    • MS Word
    • PowerPoint
    • Excel Tutorials (PK-AnExcelExpert)
    • About
    • Contact

Author: PK

Meet PK, the founder of NeotechNavigators.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your data analysis skills to the next level!
Google Sheets Templates

Exam Invigilation Duty Calendar in Google Sheets

September 24, 2026September 24, 2026PKComments Off on Exam Invigilation Duty Calendar in Google Sheets

Plan every exam invigilation duty in one shared Google Sheets file: a 12-month Annual View, a Monthly View with an “N more” cue, a date-range Daily View and one Events register, with 100 fictional sample duties.

Google Sheets Templates

Faculty Workload Calendar in Google Sheets

September 24, 2026September 24, 2026PKComments Off on Faculty Workload Calendar in Google Sheets

Plan faculty teaching, research, advising and service commitments with annual, monthly, daily and detailed calendar views in an editable Google Sheets template.

Google Sheets Templates

Dissertation Milestone Calendar in Google Sheets

September 24, 2026September 24, 2026PKComments Off on Dissertation Milestone Calendar in Google Sheets

Plan proposal, IRB, chapter review and defense dates with annual, monthly, daily and event-list views in an editable Google Sheets dissertation calendar.

Google Sheets Templates

Interior Fit-Out Project Management System Web App

September 24, 2026September 24, 2026PKComments Off on Interior Fit-Out Project Management System Web App

The Interior Fit-Out Project Management System is a Google Apps Script web app with 27 modules, 7 roles and 30 reports covering quotations and BOQ, work packages, snags, handover and DLP, procurement and milestone invoicing with retention. Try the live demo before you buy.

Google Sheets KPI Dashboard

Car Wash Business KPI Scorecard in Google Sheets

September 24, 2026September 24, 2026PKComments Off on Car Wash Business KPI Scorecard in Google Sheets

A walkthrough of the Car Wash Business KPI Scorecard in Google Sheets: 10 KPIs in 5 groups, a month picker with MTD/YTD and Target or PY comparison, traffic lights, a KPI Trend page, and the known limits of the current build.

Google Sheets KPI Dashboard

Auto Body Shop KPI Scorecard in Google Sheets

September 24, 2026September 24, 2026PKComments Off on Auto Body Shop KPI Scorecard in Google Sheets

A 10-KPI Google Sheets scorecard for auto body and collision repair shops: traffic-light cards, a month picker, MTD/YTD and Target/PY views, a KPI Trend page and the known issues with fixes.

Tire Shop KPI Scorecard in Google Sheets
Google Sheets KPI Dashboard

Tire Shop KPI Scorecard in Google Sheets

September 24, 2026September 24, 2026PKComments Off on Tire Shop KPI Scorecard in Google Sheets

Track 10 tire shop KPIs – sales, service, quality, customer and inventory – with monthly cards, MTD/YTD views, direction-aware traffic lights and trend charts in Google Sheets.

Google Sheets KPI Dashboard

Auto Repair Shop KPI Scorecard in Google Sheets

September 24, 2026September 24, 2026PKComments Off on Auto Repair Shop KPI Scorecard in Google Sheets

The Auto Repair Shop KPI Scorecard in Google Sheets tracks 10 shop KPIs on one page of traffic-light cards with a month picker, MTD/YTD and Target/PY views and a KPI Trend page.

Google Sheets Templates

Streaming Income Tracker (Twitch/YouTube Live) in Google Sheets

September 24, 2026September 24, 2026PKComments Off on Streaming Income Tracker (Twitch/YouTube Live) in Google Sheets

A one-page streaming income tracker in Google Sheets: one Total Streaming Income card, four live charts and a 16-column log that works out Total Income and $ / Hour for every Twitch, YouTube Live, Kick or TikTok Live session you run.

Google Sheets Templates

Self-Publishing (KDP) Royalty Tracker in Google Sheets

September 24, 2026September 24, 2026PKComments Off on Self-Publishing (KDP) Royalty Tracker in Google Sheets

A one-page KDP Royalty Tracker in Google Sheets: 16 columns with six automatic formulas, a Total Net Royalty card and four live charts over every book edition you publish.

Posts pagination

1 2 … 223 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 Dashboard Google Sheets calendar template Checklist Template Customer Satisfaction Dashboard Template data analysis Database Data Visualization Google Apps Script 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 Metrics 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