A purchase order and vendor management system web app on Google Apps Script: requisitions, approvals by amount, receiving, three-way match, payments, budgets, 14 reports and 7 roles, with live demo login details.
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!
9 Google Sheets Tricks for Business Reports: Build a Weekly Sales Report That Updates Itself (Free)
Nine Google Sheets tricks for business reports: dropdown chips, ARRAYFORMULA, QUERY, SPARKLINE, FILTER, a slicer and a live title. Free practice file.
Invoice Template in Google Sheets: Auto Invoice Number, Customer Dropdown & Sales Tax (Free)
Free invoice template in Google Sheets: automatic invoice number, customer dropdown with XLOOKUP, item prices, sales tax on taxable lines only and a status box that turns green when paid.
Manufacturing OEE Dashboard in Google Sheets: Track Downtime, Scrap and OEE
A Google Sheets OEE dashboard that shows availability, performance, quality, downtime Pareto, MTBF, MTTR and scrap cost by plant, line and shift.
Reseller Profit Tracker in Google Sheets and Excel
A reseller profit tracker for Google Sheets and Excel that works out platform fees, net profit, ROI and days to sell on every eBay, Poshmark, Etsy, Mercari and Amazon item.
Rental Property Management System Web App
A rental property management system web app on Google Apps Script: owners, units, leases, the monthly rent run, late fees, deposits, maintenance, owner statements and 20 reports, with live demo login details.
Google Sheets ARRAYFORMULA: Stop Dragging Formulas Down (Free Sheet)
Use one Google Sheets ARRAYFORMULA to fill a whole Total column, new rows included, and stop dragging formulas down. Free practice sheet + 44-second video.
Marketing KPI Dashboard in Google Sheets: Build a ROAS Scorecard with Formulas (Free)
Free marketing KPI dashboard in Google Sheets: filters, six KPI cards, a ROAS scorecard with Scale, Watch or Cut badges, a trend chart and a QUERY top 5.
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.
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.