Designed and maintained a self-service software learning platform consisting of instructional videos, supporting documentation, downloadable resources, and searchable written content to help users learn Microsoft Office tools independently.
Project Snapshot
| Organization | YouTube learning channel: Simple Software Tutorials |
| Role | Content Creator, Instructional Designer, Technical Writer, Video Producer, Website Manager |
| Timeframe | 2013 – present |
| Primary Focus | Creating accessible, practical software training content that helps users solve real-world productivity challenges using Microsoft Office tools. |
| Audience | Individuals learning Microsoft Office and other software skills, including students, professionals, and self-directed learners looking for practical solutions. |
| Deliverables | * 240+ software tutorial videos * Supporting blog articles for each video * Embedded video lessons with written summaries * Downloadable templates and example files * Copy/paste formulas, instructions, and reference materials * Searchable online knowledge base * Ongoing content updates based on user needs and questions |
| Tools | * Microsoft Office Suite (Excel, Word, PowerPoint, Outlook) * YouTube Studio * Website/blog platform * Screen recording and video editing tools * SEO and analytics tools * Adobe Creative Suite |
The Challenge
Many software users struggle to find clear, practical answers when they encounter problems in their daily workflows. Traditional documentation often explains features but does not always address the specific “how do I actually use this?” questions people encounter.
The challenge was creating learning content that was approachable, searchable, and immediately useful while supporting different learning preferences. Some users prefer watching a demonstration, while others need written steps, formulas, examples, or files they can adapt for their own work.
Without a structured learning resource, users would spend significant time searching through disconnected tutorials, troubleshooting information, or incomplete explanations. The goal was to reduce friction by creating a reliable resource where learners could quickly find, understand, and apply solutions.
My Approach
I treated each tutorial as more than a standalone video. I approached the channel as a learning ecosystem where video, written documentation, and downloadable resources worked together to support different learning styles.
I evaluated what users were struggling with by looking at common software challenges, search behavior, viewer questions, and recurring themes in comments. These observations influenced the creation of practical tutorials focused on real-world scenarios rather than simply explaining software features.
The guiding principles behind my approach were clarity, accessibility, and reducing the effort required for someone to go from “I don’t know how to do this” to “I can complete this task.”
What I Created
- Step-by-step Microsoft Office tutorial videos
- Written companion articles summarizing each lesson
- Searchable knowledge base of software solutions
- Embedded video and written learning experiences
- Downloadable templates and example files
- Excel formulas and reusable resources
- Practical workflow demonstrations
- Beginner-friendly explanations of complex features
- Content optimized around common user questions and learning needs
Results & Impact
- Built a library of 240+ instructional videos reaching thousands of learners
- Grew an audience of 6,600+ subscribers and generated more than 2 million views
- Created an evergreen learning resource that continues helping users years after publication
- Improved accessibility by offering both visual demonstrations and written reference materials
- Reduced the need for users to repeatedly search for answers by consolidating solutions into one searchable platform
- Developed a repeatable content creation process for turning user needs into educational resources
My Process
Observe
I identified common software pain points and questions users encountered when trying to complete everyday tasks. Viewer feedback, search trends, and recurring problems helped guide content topics.
Understand the Goal
The goal was not just to explain software features, but to help people accomplish real tasks faster and with less frustration.
Remove the Friction
I combined multiple learning formats – video, written instructions, examples, and downloadable files – so users could choose the format that best matched their needs.
Design for People
I focused on clear explanations, realistic scenarios, and beginner-friendly instruction rather than assuming users already understood technical terminology.
Measure Adoption
I monitored engagement through views, subscribers, comments, and ongoing audience feedback to understand which topics provided the most value.
Refine & Improve
I continued updating content, creating new tutorials, and improving resources based on changing software versions and evolving user needs.
Work Samples
- Microsoft Excel tutorial videos (link)
- Excel templates and downloadable practice files
- Written tutorial articles accompanying videos (link)
- Formula explanations and examples
- Word, PowerPoint, and Outlook training content (link)
- Website-based learning resources
Key Takeaways
- Effective learning experiences require more than delivering information; they require understanding the learner’s goal and removing barriers to success.
- Combining video, documentation, and hands-on resources creates a more accessible and effective learning experience.
- Building evergreen educational content requires ongoing refinement based on user behavior, feedback, and changing needs.
Featured Instructional Video Examples
-
How to Create Mailing Labels in Word From an Excel List
This example is about analyzing where users get stuck, breaking a confusing multi-application workflow into manageable steps, and designing instruction for people with no prior knowledge. It also demonstrates a concrete learning outcome beyond YouTube metrics: someone learned a skill well enough to pass a hiring assessment and secure a job.
-
How to Create an Order Form With Drop-Down Menus in Excel
This concept originated from a real-world business solution I designed and demonstrates how I solved a business problem first, then taught others how to solve similar problems. I have a consistent track record of understanding problems, designing practical solutions, and helping others adopt them.
-
How to Auto-Populate Fields in Excel Using a Drop-Down and VLookup
This example demonstrates how I listened to a learner’s need, identified the knowledge gap (combining Data Validation with VLOOKUP in a practical way), and designed a solution around a real-world task, rather than teaching features in isolation. As a result, this became my most viewed video.
Sally Scott 