Coaching & Tutoring Dashboard in Google Sheets

The Coaching & Tutoring Dashboard in Google Sheets turns a single session log into 6 linked pages, 18 charts and 15 slicers, tracking 8 headline metrics across 8 tutors, 8 subjects and 6 districts. The pivots are already wired to 1,000 rows, so setup is one paste into the Data tab and every KPI card, chart and panel recalculates on its own.

🌍 Join 8,400+ teams in 40+ countries using NextGenTemplates to replace paid SaaS tools with one-time-purchase Excel, Google Sheets, Power BI and HTML templates.

✅ Instant download · One-time payment · No subscription · No per-user fees · Lifetime access

🔑 Key Features of the Coaching & Tutoring Dashboard in Google Sheets

📌 Four KPI cards that travel with you. Total Revenue, Sessions Delivered, Tutoring Hours and Avg Rating sit in the dark navigation rail and stay on screen on every one of the 6 pages, each with its own inline sparkline or progress bar, so the headline numbers never scroll away while you read a chart.

📌 An At a Glance panel with four more metrics. Below the KPI cards the rail carries Avg session value, Students taught, Active tutors and Attendance rate — the four numbers an academy owner is asked for most often, calculated straight from the same session log.

📌 15 slicers across four analysis pages. Overview filters by Month, Tutor, Subject and Session Type; Tutors by Month, Tutor, Student Level and Status; Subjects by Subject, Programme and Month; Students by Student Level, Region, Session Type and Month. Slicers are page-scoped, so each page keeps its own view.

📌 18 charts built on live pivot tables. Line, area, column, stacked column, bar, donut and a gauge dial for Session Attendance Rate. Every chart reads a pivot that starts at column Z on its own page — nothing is pasted or hard-coded.

📌 A Top 5 panel and a status mix bar on every analysis page. Overview and Tutors rank the Top 5 Tutors by Revenue, Subjects ranks the Top 5 Subjects, Students ranks the Top 5 Regions — each beside a Session Status Mix breakdown of Completed, Scheduled, In Progress, Rescheduled and Cancelled sessions.

📌 A Session ID lookup page. Type any Session ID and 16 fields fill in instantly through INDEX/MATCH wrapped in IFERROR, so a missing ID reads “Not found” instead of #N/A.

📦 What’s Inside the Coaching & Tutoring Dashboard in Google Sheets

Six pages plus the Data tab. The Data tab holds 16 columns — Session ID, Date, Tutor, Subject, Session Type, Student Level, Region, Program, Status, Students, Hours, Attendance, Revenue, Rating, Month and Count — and the pivots read A1:P1001, giving you room for 1,000 sessions before anything needs extending.

Page 1: Overview

Whole-academy performance across every tutor, subject and district. Charts are Revenue by Month, Session Attendance Rate (a gauge dial reading 86.3 on the sample data), Revenue by Tutor, Revenue Share by Session Type and Students Enrolled by Month, closing with Top 5 Tutors by Revenue and the Session Status Mix.

Page 2: Tutors

Workload, earnings and satisfaction for every member of the coaching team. Sessions by Tutor and Hours by Month and Session Type show how the load is spread; Revenue by Tutor and Avg Rating by Month show what it earns and how learners rate it.

Page 3: Subjects

What each subject earns and which programmes learners actually buy. Revenue by Subject ranks all eight subjects, Sessions by Programme splits Monthly Plan, Pay As You Go, Scholarship and Term Package, and Average Session Value by Month tracks pricing drift.

Page 4: Students

Who is being taught, how well they attend and how they rate the coaching. Six charts here: Students by Level, Student Share by Session Type, Students by Region, Avg Attendance by Month, Sessions by Level and Status, and Avg Rating by Level, with Top 5 Regions by Revenue underneath.

Page 5: Search

A single-cell Session ID lookup that pulls the full record straight from the Data tab — date, tutor, subject, session type, student level, region, programme, status, students, hours, attendance, revenue, rating and month. Add rows to the Data tab and they are searchable immediately.

Page 6: Instructions

Four numbered sections covering how to load your own data, how the slicers behave, how the navigation rail works and how to recolour the whole workbook to your academy’s brand. Read it once and the file is yours.

📊 Coaching & Tutoring Dashboard in Google Sheets vs. Microsoft Excel Dashboard vs. Paid Tutoring SaaS — Where This Fits

For academies that want tutor, subject and district analytics without paying per-seat scheduling-software fees, the Coaching & Tutoring Dashboard in Google Sheets sits in the sweet spot.

👥 Who This Template Is For — and Who It’s Not For

✅ This template is built for:

• Owners of tutoring centres and coaching institutes with roughly 3-30 tutors who already keep a session log somewhere
• Academic directors who report revenue, attendance and tutor ratings to a board or franchise head each month
• Private tutors and small test-prep outfits who want a Drive link instead of a monthly scheduling subscription
• Multi-branch academies comparing performance across districts or regions

❌ This template is NOT for:

• Anyone who needs live scheduling, calendar sync, parent portals or automated invoicing — this is an analytics workbook, not a booking system
• Academies that need to store more than 1,000 sessions without extending the pivot ranges themselves
• Teams needing SSO, audit logs or role-based permissions beyond what Google Drive sharing provides
• Anyone wanting a payment gateway or student-facing app

⚙️ How to Use the Coaching & Tutoring Dashboard in Google Sheets

1. Open the PDF in your download and click the Google Sheets link to make your own copy in Drive.
2. Open the Data tab and replace the sample rows from row 2 down, keeping all 16 column headers exactly as they are.
3. Never leave Session ID blank — the pivots use it to ignore empty rows and the Search page uses it to look up a session.
4. Click any slicer in the white strip under a page title to filter that page’s charts, Top 5 panel and status bars.
5. Use the dark rail on the left to jump between Overview, Tutors, Subjects, Students, Search and Instructions.
6. Recolour the rail, the KPI cards and the chart palette to match your academy brand.

💼 Real-World Use Cases

Meera runs a 12-tutor SAT and maths centre in two districts. She pastes last month’s sessions into the Data tab on the first of every month, opens the Subjects page to see which programme mix is actually paying, and screenshots the Top 5 Tutors panel for her partner — without paying $120 a month for tutoring-management software she only uses for reports.

Daniel is an academic director at a language and test-prep academy. He filters the Students page by Region and Student Level to find where attendance is slipping, then filters the Tutors page by Status to see how many sessions were rescheduled rather than delivered before he signs off tutor payouts.

Priya tutors chemistry and biology on her own. She uses the Search page to pull up a single session when a parent queries an invoice, and the Avg Rating by Month chart to show returning families that her feedback scores have held steady across the year.

❓ Frequently Asked Questions

What metrics does the Coaching & Tutoring Dashboard in Google Sheets track?

The Coaching & Tutoring Dashboard in Google Sheets tracks 8 headline metrics — Total Revenue, Sessions Delivered, Tutoring Hours, Avg Rating, Avg session value, Students taught, Active tutors and Attendance rate — plus revenue and session breakdowns by tutor, subject, programme, student level, region and session type.

How long does setup take?

Under 10 minutes. Click the Google Sheets link in the PDF to copy the file to your Drive, paste your own sessions into the Data tab keeping the 16 column headers, and every KPI card, chart, slicer and panel in the Coaching & Tutoring Dashboard in Google Sheets recalculates on its own.

How many sessions can it hold?

The pivots in the Coaching & Tutoring Dashboard in Google Sheets read A1:P1001, so 1,000 sessions fit with no changes. Beyond that you extend the pivot source ranges yourself — the formulas and charts follow automatically once the range is widened.

How does this compare to TutorCruncher or Teachworks?

Those are hosted scheduling and billing platforms charging $50-200 a month. The Coaching & Tutoring Dashboard in Google Sheets is a $16.99 one-time analytics workbook: it will not book lessons or invoice parents, but it gives you tutor, subject, district and attendance reporting you fully own and can edit.

Do I need Excel or any add-on to use it?

No. The Coaching & Tutoring Dashboard in Google Sheets runs entirely in Google Sheets in a browser, with no add-ons, scripts or macros. A free Google account is all you need, and Google’s own pivot table documentation covers anything you want to extend.

Can my team use it at the same time?

Yes. Because the Coaching & Tutoring Dashboard in Google Sheets lives in Google Drive, you share one link and colleagues edit together in real time. Note that slicer selections are shared, so a filter one person sets is visible to everyone in the file at that moment.

Is the sample data real?

No. Every figure shipped in the Coaching & Tutoring Dashboard in Google Sheets — the tutors, subjects, districts, revenue and ratings — is demonstration data generated for the template, and it is there only to show the charts populated. Replace it with your own records before drawing any conclusion.

👤 About the Author

Built by PK — Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels (@PK-AnExcelExpert, @NextGenTemplates, @NeoTechNavigators). Every template is hand-built and tested before release.

🔗 Explore Related Templates

Also available as: the same academy analytics are published for two other tools — Coaching & Tutoring Dashboard in Excel for teams working offline in a workbook, and Coaching & Tutoring Dashboard in Power BI for anyone publishing to a Power BI workspace.

If you would rather score the business against targets than explore it, the Coaching & Tutoring KPI Dashboard in Excel is the month-picker scorecard version with traffic lights. For a wider view of the sector, the Tutoring Business Dashboard in Google Sheets and the Student Academic Insights Dashboard in Google Sheets sit alongside this one, and both are listed with the rest of our Google Sheets Dashboards.

To capture sessions before they reach this dashboard, pair it with the Class Schedule Data Entry System in Excel or the E-learning Course Calendar in Google Sheets.

📖 Click here to read the Detailed Blog Post

🎥 Visit our YouTube channel for step-by-step video tutorials

👉 YouTube.com/@NextGenTemplates

Watch the step-by-step video Demo:

📅 Last updated: September 2026