Excel — Long vs. wide formats
This clip discusses the two basic conceptual principles of representing and/or entering data. In data analysis we follow the principle of "one observation, one row", but the devil is in the detail. For a complete list of my Excel clips, watch https://sfla.ch/tutorials/excel The Excel tutorial playlist: • Linguistic data in Excel Leave problems with the clip contents or suggestions for new clips in the columns below.
▶︎
Excel — Shortcuts
▶︎
Long vs wide data formats, plus unit of analysis
▶︎
How to use Power Pivot in Excel | Full Tutorial
▶︎
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
▶︎
Data Management: Long vs Wide Data
▶︎
How to Use Excel - A 3-Hour Path to Confidence and Skills
▶︎
How to reshape wide panel data to long panel data in excel
▶︎
You Don't Need VLOOKUP & XLOOKUP, You Need This | Excel
▶︎
5 Hour Timer
▶︎
Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)
▶︎
Rowan Atkinson's Brilliant Humor Leaves Celebrities in Tears!
▶︎
40Hz Binaural Gamma Waves - Ultra Deep Concentration
▶︎
Power Query for Beginners: Transform Excel Data in Minutes (2025 Tutorial Part I)
▶︎
Excel — Introduction
▶︎
What to teach when AI writes the code | Rainer Stropek | TEDxLinz
▶︎
Billionaire's WARNING: I'm SELLING. The Crash Is Already Here!
▶︎
Stop Wasting Time! 3 Easy Ways to Remove Blank Rows in Excel
▶︎
Build a Dynamic Excel Report from Scratch (Even If You're a Beginner)
▶︎
How to use Copilot in Excel - The Complete Beginners Course
▶︎