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.
Audience
Business professionals, office staff, small business owners, and Excel users seeking to create structured, user-friendly order forms without requiring advanced Excel knowledge.
Business Challenge
This tutorial was inspired by a real solution I developed while working in the amusement park products division at Baden Sports. Sales representatives frequently needed to build shipping container orders that maximized available space while accounting for varying product weights, box dimensions, pricing, and product configurations. The manual process required significant back-and-forth between Sales and Operations to adjust quantities and ensure orders fit within container constraints.
To streamline the process, I designed an Excel-based ordering system that allowed users to select products, quantities, and options from drop-down menus while automatically referencing product information stored in supporting worksheets. The workbook significantly reduced manual calculations, improved order accuracy, and was reused and updated for future purchasing seasons.
Learning Objective
This tutorial adapts those concepts into an approachable learning experience. By the end of the lesson, learners are able to:
- Create professional order forms in Microsoft Excel.
- Build drop-down menus using named ranges and Data Validation.
- Organize lookup data for easier workbook maintenance.
- Apply appropriate formatting for business data such as ZIP codes and credit card numbers.
- Design spreadsheets that improve consistency, reduce manual entry, and minimize errors.
My Role
Independently managed the complete instructional development process:
- Selected a real-world business scenario as the instructional foundation.
- Simplified a complex enterprise solution into an accessible learning exercise.
- Designed the curriculum and lesson flow to progressively build learner confidence.
- Wrote the instructional script.
- Recorded screen demonstrations and narration.
- Edited and published the final instructional video.
- Managed audience engagement and incorporated learner feedback into future content planning.
Results
- More than 264,300 views
- Over 20,900 hours of watch time
- One of the highest-performing instructional videos on the channel.
- Frequently recommended by viewers as a clearer and more approachable alternative to other Excel tutorials.
Representative Learner Feedback
“AMAZING!! Easiest tutorial ever.”
“Very helpful, concise, to the point, and filled with useful information.”
“For the first time it sank in!”
“One of the best Excel tutorials.”
“The way you explain the processes involved is very understandable and not patronising.”
“Your video solved my two hours of frustration.”
Skills Demonstrated
- Instructional design
- Adult learning principles
- Scenario-based learning
- Technical communication
- Microsoft Excel expertise
- Business process improvement
- Workflow automation
- Video production
- Script writing
- Educational content development
- User-centered design
Sally Scott 