Online Tutorial for Data Analysis and Automation
Ten roofing KPIs on one traffic-light page in Google Sheets – month picker, MTD and YTD targets, prior-year trends and every formula documented. A full walkthrough of the four sheets, where it fits against Excel and paid roofing software, and where it deliberately stops.
Track 10 HVAC KPIs – first-time fix rate, callback rate, ticket value and more – with MTD/YTD traffic lights and 12-month trends in Google Sheets.
Track 15 HVAC contractor KPIs in Google Sheets with MTD and YTD achievement, prior-year comparison and traffic-light status. One month dropdown drives the scorecard, the KPI Trend page and the group analysis – formula-driven, nothing to install.
The Leadership Development KPI Dashboard in Google Sheets tracks 14 leadership KPIs across four groups and ten tabs, with a month picker that drives MTD and YTD traffic lights, a single-KPI trend page and a group roll-up analysis page. Formula-driven, no add-ons, one-time payment.
One Google Sheets tab that tracks every medicine, dose and refill, with days supply left, refill alerts and four live charts calculated for you. A personal organising log, not medical advice.
A one-page Yoga & Stretching Practice Tracker in Google Sheets: total practice minutes, four live charts and a 16-column session log that grades every session against your planned minutes. A personal practice log, not medical advice.
The Heavy Machinery Dashboard in Google Sheets tracks 16 KPI cards and 18 charts across 6 pages, driven by 15 native slicers over a 500-order book that auto-expands to 1,000 rows. Built on real pivot tables, it covers plant output, dealer orders, backlog and warranty service in one browser file.
A pivot-and-slicer Electronics & Semiconductors Dashboard in Google Sheets with 6 pages, 16 KPI cards, 18 charts and 15 slicers covering wafer starts, yield, device mix and fab margin – built on 500 sample production lots.
A hands-on look at the Physiotherapy Session Calendar in Google Sheets: six tabs, three linked views, 100 sample sessions across 21 session types and 30 treatment locations – and a clear account of what this scheduling spreadsheet deliberately does not do.
A ready-to-use Dental Clinic Appointment Calendar in Google Sheets with annual, monthly, daily and events views, 100 sample appointments and 12 treatment rooms – scheduling only, no patient records.