Data and Excel Skills
FreeMediumPragmatic Works
Played through YouTube’s official embed player. Prefer the full site? Watch Window Functions in SQL on YouTube · Pragmatic Works
Window functions in SQL: ranking, running totals, and comparisons across rows without collapsing the table. The single largest step up from basic SELECT fluency, and the one data screens love.
Watching is the first half. The second half is doing it yourself while the patterns are still in your head.
Member comments open here with the Community launch. Until then, take your questions about this video to Richard on the home page, or bring them to your next practice session.
Free
EasyData and Excel Skills
Pragmatic Works · on YouTube
PivotTable fundamentals taught on a real dataset: what a clean source table looks like, and how rows, columns, values, and filters turn it into answers. The first data skill every analyst job quietly assumes.
Free
EasyData and Excel Skills
Kevin Stratvert · on YouTube
A compact start-to-finish pivot table build that ends with charts and slicers you can actually present. Good as a same-day refresher before an Excel test or a superday data exercise.
Free
MediumData and Excel Skills
Learn Skills Daily · on YouTube
The long version: pivot tables from the first insert through calculated fields, Power Pivot, and DAX expressions, in a single tutorial of over two hours. Treat it as a weekend build-along, not a preview.
Free
EasyData and Excel Skills
Mohammad Mirshafiei · on YouTube
SQL introduced through the pivot table you already understand: SELECT, GROUP BY, and ORDER BY, with every number checked against the same table in Excel. The gentlest on-ramp to the next language on this shelf.
Free
MediumData and Excel Skills
Kenji Explains · on YouTube
An interactive Excel dashboard built from scratch, start to finish: data, calculations, and the presentation layer in one sitting. Dashboards are how analyst work gets seen, and this is a complete build to imitate.
Free
MediumData and Excel Skills
Kenji Explains · on YouTube
Five methods for forecasting revenue in Excel, compared honestly: when each is defensible and when each misleads. Forecasting judgment is a graded interview skill, and this is its toolkit.
Free
MediumData and Excel Skills
Kenji Explains · on YouTube
An actuals versus budget report automated in Excel, the recurring deliverable of every finance team's month end. Build it once here and you will recognize the pattern in every FP&A interview.
Free
MediumData and Excel Skills
Kenji Explains · on YouTube
Statistics in Excel in fourteen minutes: the functions and the reasoning together, at the level data screens actually reach. A compact bridge between the pivot shelf and real analysis.
Free
EasyData and Excel Skills
Kenji Explains · on YouTube
What to use when XLOOKUP and VLOOKUP start costing you time and errors. Lookup discipline sounds minor until a superday exercise grades your sheet in front of you.
Free
EasyData and Excel Skills
Pragmatic Works · on YouTube
T-SQL tips and tricks for beginners, part one: the small syntax and structure habits that make queries readable and correct. A working companion to the first-query lesson already on this shelf.
Free
EasyData and Excel Skills
Pragmatic Works · on YouTube
Part two of Pragmatic Works' T-SQL beginner series, going further into the errors beginners make and the patterns that prevent them. Watch the pair together before a data exercise.
Free
EasyData and Excel Skills
Leila Gharani · on YouTube
What a pivot table actually is, explained by one of Excel's best teachers in purely conceptual terms. The floor under the whole pivot shelf, and the right place to repair a shaky foundation.
Free
MediumData and Excel Skills
Leila Gharani · on YouTube
Power Query for beginners: automating the cleaning and combining of Excel data so the monthly refresh takes minutes. Analyst interviews increasingly assume this, and few candidates have it.
Free
MediumData and Excel Skills
Leila Gharani · on YouTube
The check every analyst should run on an Excel report before it leaves their desk, demonstrated by Leila Gharani. Error discipline is a graded trait in modeling tests, and this is its habit form.
Free
EasyData and Excel Skills
Leila Gharani · on YouTube
Stop copying data between Excel sheets: the linking and consolidation methods that replace the clipboard. Manual copying is where spreadsheet errors are born, and working interviews can tell.
I am Richard, your interviewer here. I run cases with you, drill your math, and tell you plainly which part of your game needs work. Ask me something, or press Hear it and I will introduce myself out loud in your device voice. The studio voice connects at launch.
He answers from the guide's own content, names the level it lives in, and does not invent firm facts. On member accounts he remembers your year, school, progress, and scores; you can see and clear what he remembers.
