The Online Learning Platforms Dashboard in Google Sheets is a six-tab reporting workbook for anyone running courses on a subscription e-learning platform. It ships loaded with 500 sample enrollment records across 23 columns, and every pivot, slicer and formula is already wired to 1,000 rows, so you paste your own export in and the whole book redraws. Four analysis pages carry 15 native slicers between them. Built by a Microsoft Certified Professional, sold once, no subscription. If it does not fit how you report, tell us within 30 days and we will refund it.
Key Features of the Online Learning Platforms Dashboard
- Six tabs, four of them analytical – Overview, Courses, Learners, Revenue, plus a Search lookup page and an Instructions page.
- 15 slicers in total – 3 on Overview (Month, Subject Category, Subscription Plan) and 4 on each of Courses, Learners and Revenue. Slicers are per page, so one team’s filter does not disturb another’s.
- 16 KPI cards – four per analysis page, from Subscription Revenue and Active Learners down to Refund Rate and Avg Revenue per Sub.
- Native pivot tables, no helper columns – each chart reads a pivot parked to the right of its page, so the file stays responsive as the enrollment log grows.
- Chart types that suit the question – a treemap for subject mix, a waterfall for revenue build, five gauges for completion by plan, a scatter for course price against completion, donuts, histograms and stepped areas.
- A right-hand sidebar on every analysis page – snapshot metrics, a 12-month revenue trend, a Top 5 table, a share breakdown and an At a Glance list.
- An Enrollment ID lookup – type any ID on the Search page and all 18 fields of that record are read back.
- Re-skinnable in one place – the shipped theme is Burgundy and Sand; edit the palette at the top of the bundled Apps Script and the whole workbook changes colour.
What’s Inside the Online Learning Platforms Dashboard
Overview answers “how is the platform doing this month”. Subscription Revenue reads $786,607 on the sample, against 2,903 active learners, 500 enrollments and 58.0% average completion. Active Learners vs Subscription Revenue by Month puts volume and money on one combo chart; a treemap breaks learners out by subject category; a scatter plots course price against completion rate. The sidebar carries a Performance Snapshot, Top 5 Courses by Revenue and an Enrollment Status Mix (Active 46.4%, Completed 31.2%, Cancelled 10.4%, Expired 8.2%).
Courses is the catalogue view: 24 courses offered, $118 average course price, 156 completed courses, 41,085 total watch hours. Enrollments by Subject Category, Enrollments by Course Level, Course Price Distribution, Monthly Enrollments and Revenue by Instructor sit alongside Top 5 Courses by Watch Hours and a Course Level Share panel.
Learners profiles the audience: 2,903 learners on 324 accounts, 43.4% of enrollments on mobile, 82.2 average watch hours. Learners by Age Band, Enrollments by Device Type, Avg Completion % by Plan (five gauges), Monthly Active Learners, Monthly Watch Hours and Learners by Region and Plan. Top 5 Regions by Learners runs Europe 758, Asia Pacific 722, North America 669, Africa 309, Latin America 262.
Revenue covers monetisation: $786,607 subscription revenue, $75,150 of it Premium, $1,573 average revenue per subscription, a 3.8% refund rate. A waterfall builds revenue by subject category, a column chart tracks monthly subscription revenue, a donut splits revenue by payment method (credit card 41.7%), and Plan Revenue vs Enrollments compares money against count. Top 5 Platforms by Revenue and a Plan Revenue Share panel finish the page.
Search and Instructions round it out – an ID lookup and a ten-point user guide.
Online Learning Platforms Dashboard vs. an Excel Build vs. a Paid BI Suite
| This Google Sheets dashboard | Building it yourself in Excel | A paid BI suite (per-seat licence) | |
|---|---|---|---|
| Cost | One payment, this listing | Free tooling, your own hours | Recurring per user, per month |
| Platform | Google Sheets, browser | Excel desktop | Desktop plus service |
| Setup time | Paste your export, minutes | Days of layout and formula work | Data model plus report build |
| Real-time team collaboration | Yes, native Sheets | Only via a shared drive | Yes, on the paid service |
| Mobile access | Sheets mobile app | Limited | Vendor app |
| Customizable fields | Edit columns and re-run the script | Fully, if you build it | Fully, with modelling skills |
| Share with link | Yes | No | Licensed viewers only |
| Year-1 cost at 5 users | The purchase price, once | Your build time | Five recurring seats |
| Enrollment-level record lookup | Built in, Search page | You would add it | Drillthrough page |
| Connects live to your LMS | No – you paste an export | No | With a connector and setup |
An LMS is a different category of product altogether: it hosts the courses, records the enrollments and issues the certificates. This workbook does none of that. It reports on the export your LMS or billing system already produces, which is why it sits beside those tools rather than against them.
Who This Template Is For – and Who It’s Not For
A good fit for a course business or e-learning platform team that already exports enrollments to CSV and wants a management-review pack without paying for BI seats. It suits operators, catalogue managers, finance leads and anyone who has to present course and subscription numbers monthly.
Not for you if you need live sync to an LMS – the file is static and has no connection to any learning platform. It is not an LMS, not an xAPI or LRS store, and not a student record system. It will not predict which learners will drop out or renew, and it makes no claim about learning outcomes or the validity of any experiment you run. If you routinely handle more than a few tens of thousands of enrollments, use a database instead: the shipped build covers 1,000 rows, and going beyond that means raising DATA_ROWS in the bundled Apps Script.
How to Use the Online Learning Platforms Dashboard
- Open the PDF in your download and click the “Make a copy” link to put the workbook in your own Google Drive.
- Open the Data sheet and read the 23 headers before you touch anything – they drive every pivot.
- Replace the 500 sample rows with your own enrollment export, keeping the headers exactly as they are.
- Substitute an internal learner code for the Learner Name column unless you have a reason to keep names in the file.
- Go back to Overview and click a slicer; charts, pivots and the sidebar Top 5 all move together.
- Use the Search page to pull any single enrollment back by ID when someone queries a number.
- Re-colour the workbook from the palette at the top of the Apps Script if you want it on brand.
Real-World Use Cases
Priya runs catalogue for a skills platform. She filters Courses to Data Science, sees which levels carry the enrollments, and uses Revenue by Instructor to decide who to commission next quarter.
Tomas is finance lead at a subscription course business. He lives on the Revenue page: the waterfall shows where the money is built, Plan Revenue Share tells him how concentrated Enterprise is, and the refund rate goes straight into his board pack.
Aisha handles learner support. When a learner disputes a charge, she types the enrollment ID into Search and reads the plan, price, status and payment method back in one screen.
Frequently Asked Questions
Does this connect to my LMS?
No. It is a static Google Sheets workbook. You paste an export from your platform or billing system into the Data sheet; nothing syncs on its own.
What exactly does the file contain about individual learners?
The Data sheet holds one row per enrollment, with a Learner Name column that is populated in the sample, plus Completion %, Watch Hours, Device Type, Region and Age Band. Once you paste real records in, those columns describe how identifiable individuals behaved. We recommend replacing names with an internal learner code and restricting who the sheet is shared with. The sample data is fictional.
Are there any compliance guarantees?
No. This is a spreadsheet template, not a compliance product, and we make no claim about any data-protection regime. How you handle learner records – especially if any of your learners are minors – is governed by your own policies and the law that applies to you.
How many rows can I load?
Pivots, slicers and formulas already cover 1,000 rows. Paste anywhere up to row 1001 and the dashboard updates on its own. Beyond that, raise DATA_ROWS in the bundled Apps Script and re-run main().
Can I change the colours?
Yes. The theme is Burgundy and Sand. Edit the palette at the top of the script and the entire workbook re-skins.
Do the KPI cards respond to the slicers?
No, and that is deliberate. The KPI cards and the At a Glance list use SUMIFS and COUNTIFS so they always show unfiltered totals. The charts, pivots and the Top 5 panel are the slicer-aware parts.
What am I downloading?
A PDF that carries the “Make a copy” link to the live Google Sheet, so the template lands in your own Drive under your own account.
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. Every template is hand-built and tested before release.
Explore Related Templates
- Online Learning Platforms Dashboard in Power BI – the same subject in a Power BI model.
- Online Learning Platforms Dashboard in Excel – the desktop workbook version.
- Online Learning Platforms KPI Dashboard in Excel – a different product: a month-picker KPI scorecard with traffic lights, not this analytical dashboard.
- EdTech Dashboard in Google Sheets – the wider ed-tech business view.
- School Admin Dashboard in Google Sheets – for campus administration rather than online courses.
- Browse all Google Sheets templates or every Dashboard template.
Buy the Online Learning Platforms Dashboard in Google Sheets, copy it into your Drive, paste your enrollment export and have your first slicer-driven review ready the same afternoon.
Watch the step-by-step video Demo:
Last updated: 1 September 2026.
