Excel's PIVOTBY puts the summary inside the formula
Technology for Teachers and Students' only new upload builds automatically updating summaries from sales data.
Technology for Teachers and Students
Story of Why this story? The channel's weekly summary: what went up this week, what is drawing views now, and where the channel stands among similar channels.
The Excel PIVOTBY Function - Formula Based Pivot Tables
Product categories, regional sales and a formula that does the summarizing: "The Excel PIVOTBY Function - Formula Based Pivot Tables" gives Technology for Teachers and Students a focused spreadsheet assignment. Rather than using the traditional pivot-table interface, the lesson creates summaries directly in cells and explains how they update when the underlying data changes.
The channel posted just this tutorial, which has drawn roughly 5,800 views. Its chapters move from the formula's structure to building a dynamic table, then cover automatic refreshing and field headers. Beneath it, one viewer in their eighties recalls using Lotus 1-2-3 at home and at work. That's a lovely bit of perspective for a lesson about Excel finding another way to organize a spreadsheet.
Away from the new arrival, "The Beginner's Guide to YouTube TV" is drawing the most daily views, followed by "The Beginner's Guide to Gemini Notebook - Custom AI Notebooks." Those lessons tackle streaming-TV setup and research using your own documents, a reminder that this classroom extends beyond Office.
Subscribers were unchanged over the week, and daily viewing is a little below its usual pace. Among nearby education channels, GeoGlobeTales had a particularly large viewing week, while Tech Moments was quieter. Technology for Teachers and Students added roughly 444,000 views, bringing its lifetime total past 200 million, with a catalog whose most-watched regular upload remains its 2017 beginner's Excel guide.
Published on Trari
Where next?
What viewers say
I have been using spreadsheet for many years both at home and when I was employed. I am in my eighties and remember Lotus 1 2 3. Excel has come a long way since those early days and I enjoy watching you short tutorials. Please keep up your spread of knowledge.
@edwardm9788See it on YouTubeInteresting function!
@joan-mariacbrooksSee it on YouTubeExtremely informative ❤
@Ka-ipon28See it on YouTube
Public comments from the video's page on YouTube
Is this your channel?For the channel's owners and team: a ready picture, text and badge for your audience
Share the story with your audience. Everything is ready:
For an Instagram story or a WhatsApp status
For a community post or your channel's description
For your website
You may use the picture, the badge, and link it to this story.
The videos drawing views on Technology for Teachers and Students right now
- Subscribers
- 1,960,000
- Channel views, last 7 days
- 444,446
- Videos published this week
- 1
- Video published
- October 12, 2026
- Video views so far
- 5,837
- Views on its first day
- 3,251
The numbers
Here is the channel's week in views and subscribers.
💡 Test your knowledge
Which Excel function adds values together?
SUM adds numbers, including values supplied through a range of cells.