Excel Tutorial Video “Creating Categorized Subtotal Report”
This screencast produced with Camtasia demonstrates how to organize and summarize data in Excel using the Subtotal feature. By using a sample file called SalesData.xlsx, the video walks through each step of turning a basic sales table into a clear, categorized summary report.
Creating a Categorized Subtotal Report in Excel
Viewers will see how to:
- Sort data by category so related products are grouped together
- Apply the Subtotal command to calculate total Quantity and Sales Amount for each group
- Automatically generate subtotal and grand total rows for a well-structured report
- Collapse or expand outline levels to focus on details or just the summary view
- Remove or adjust subtotals to refine the report format as needed
This tutorial is perfect for learners who want to strengthen their Excel data-analysis skills. It provides a practical example of creating categorized reports that make business data easier to interpret and present.
Throughout the video, you’ll see clear screen recordings enhanced with Camtasia’s zoom and highlight effects, making it easy to follow every step. From sorting data to generating a final summarized table, this screencast offers a complete, beginner-friendly guide to mastering Excel’s Subtotal feature.
Click the video above to watch the full Camtasia screencast and follow along step by step to build your own categorized subtotal report in Excel.
Pictory Tutorial Video “Creating Video By Using Pictory”
Reflection on the Educational Value of Pictory for Video Development
Through the process of developing this screencast using Pictory which is an AI-powered video creation tool, I am able to gain insight into how artificial intelligence enhances both the efficiency and creativity involved in producing educational videos. Pictory’s ability to transform written text into polished videos demonstrates the growing potential of AI to support teaching and learning in both traditional and online environments.
From an educational perspective, Pictory provides significant advantages. It enables instructors to turn lesson summaries, articles, or scripts into visual learning materials within minutes, eliminating the need for advanced video-editing skills. Automated features such as script-to-video conversion, automatic captioning, and AI voice narration make content creation faster and more accessible. These tools support diverse learners by offering multimodal instruction, combining text, audio, and visuals. Teachers can use Pictory to create engaging explainer videos, while students can transform written reports into creative multimedia presentations, promoting active learning and digital literacy.
However, there are also limitations to consider. Because Pictory relies on AI automation, users have limited control over the precise alignment of visuals and narration, and the generated clips may occasionally feel generic or repetitive. While the tool simplifies production, it may reduce opportunities for learners to practice authentic video editing and storytelling skills. Educators need to balance AI efficiency with opportunities for creativity and critical thinking.
Overall, this project helps me understand how AI tools such as Pictory can bridge the gap between technical barriers and creative communication. It highlights how artificial intelligence can make video-based education more inclusive, time-efficient, and visually appealing, while still requiring thoughtful human input to ensure authenticity and pedagogical depth.