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.
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!
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.
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.
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.
Toy & Games Industry Dashboard in Google Sheets
A six-page Toy & Games Industry Dashboard in Google Sheets: 4 KPI cards, 15 slicers and 16 charts over 500 sample orders, 10 categories, 8 brands and 4 channels.
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.
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.
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.
Boiler Maintenance KPI Scorecard in Google Sheets
Boiler Maintenance KPI Scorecard in Google Sheets with 10 traffic-light KPI cards, a month picker, MTD/YTD and Target/PY views, and a KPI Trend page for monthly reviews.
Electronics Retail Dashboard in Google Sheets
A six-tab Electronics Retail Dashboard in Google Sheets: 16 KPI cards, 15 slicers and 18 pivot-driven charts over 500 sample orders, 8 categories, 10 brands and 4 channels.