Online Tutorial for Data Analysis and Automation
A step-by-step XLOOKUP tutorial for Google Sheets: left lookups, killing #N/A without IFERROR, returning four columns from one formula, slab lookups with match_mode -1, latest-record lookups with search_mode -1, and a bonus two-way lookup. Free practice file included.
A module-by-module walkthrough of the Advertising Agency Campaign Management System web app – 32 modules, 7 role logins and 31 reports running on Google Apps Script, with a live demo and an honest list of what it does not do.
Track every sponsorship in one Google Sheet: brand deal log, 5-stage pipeline, automatic balance due and payment status, deliverable progress, a Total Deal Value card and 4 live charts.
Keep every scholarship, grant and fellowship deadline in one shared Google Sheets calendar with Annual, Monthly and Daily views and 100 sample entries across 20 event types.
A 10-KPI traffic-light scorecard for appliance repair businesses in Google Sheets: repair execution, parts, dispatch, customer and financial KPIs, a KPI Trend page, setup steps and the known issues to fix first.
A month-picker KPI dashboard for snow plowing and ice management companies in Google Sheets: 14 KPIs in 5 groups, MTD and YTD traffic lights, a KPI Trend page and a KPI Analysis page.
A page-by-page guide to the Handyman Services KPI Scorecard in Google Sheets: 10 KPIs, month picker, traffic lights, KPI Trend charts, tested limits and quick fixes.
A six-page Google Sheets dashboard for pension scheme reporting: 500 fictional sample records, 16 KPI cards, 18 charts and 15 slicers covering assets, members, contributions, benefit payments, returns and fees – with a clear note on what it is not.
A Google Sheets calendar for scheduling school attendance dates such as roll calls, late logs and parent meetings: Annual, Monthly and Daily views, one Events sheet and 100 sample events for 2026, with its limits explained.
A month-picker KPI dashboard for pressure washing companies in Google Sheets: 13 KPIs in 6 groups, MTD and YTD traffic lights, a KPI Trend page and a KPI Analysis page.