Best How to Use Excel Resources & Tools

I've watched maybe 200 hours of Excel tutorials over the years and tbh, maybe 20% of them were worth the time. The rest was either too basic — like, yes, I know what a cell is — or too advanced without the context to make it stick.

What I've found works is layering resources. Start with structured courses for foundations. Then switch to problem-specific searches when you hit real roadblocks. Don't do it the other way around or you'll have weird gaps in your knowledge that come back to bite you later.

So here's what I'd point someone to if they asked me tomorrow.

YouTube Channels Worth Subscribing To

Not all Excel YouTube content is created equal. Some channels somehow stretch 3 minutes of useful info into 15-minute videos and you sit there wondering what you just watched. These ones don't do that.

Leila Gharani is who I go to for dashboard design and real-world business examples. Her dynamic arrays stuff alone probably saved me 50 hours of manual work last year. Long-form deep dives, 20 to 40 minutes each. Worth every minute.

ExcelIsFun — Mike Girvin's channel. This guy is intense. Dense lecture-style content with over 100 playlists organized by topic. His Power Query series is absurdly thorough — he'll spend 2 hours on unpivoting data alone. If you want formula fundamentals and array formulas drilled into your brain, this is the place.

MyOnlineTrainingHub does short tactical tips under 10 minutes. Bite-sized, problem-focused. I pull these up when I need to figure out one specific thing and don't want to wade through 30 minutes of preamble.

Chandoo taught me that most people overcomplicate their charts — you can usually delete half the elements and double the clarity. His data visualization and storytelling stuff is genuinely good. Mix of short tips and full case studies.

Kevin Stratvert is the channel for absolute beginners. Step-by-step UI walkthroughs at a slow pace with good production quality. If you've literally never opened Excel, start here.

But here's the thing about YouTube tutorials: watching without applying is basically entertainment. I keep a practice spreadsheet open while watching and pause constantly to replicate what they're doing. Otherwise you wake up a week later and realize you absorbed nothing.

Interactive Practice — Way Better Than Passive Watching

Watching someone else do VLOOKUP creates the illusion of learning. Your brain goes "yeah, I got this" and then you open a blank sheet and stare at it. You need to actually type the formula yourself. With your own fingers. On your own keyboard.

Excel Exercises at excelexercises.com is free, browser-based, no account needed. They give you a dataset and specific tasks — like "use INDEX-MATCH to find the employee with the highest sales in Q3" — and immediately tell you whether your formula returned the right answer. I send new hires here before they touch our actual spreadsheets. Saves me from having to untangle their mess later.

W3Schools Excel Tutorial — yes, the same W3Schools everyone dunked on for web dev. Honestly their Excel section is surprisingly solid for quick reference. Each function has a live editor where you can modify parameters and see results instantly. Good for looking up syntax when you're mid-formula and forgot whether COUNTIFS takes the criteria_range first or the criteria. Happens to me at least twice a week.

Excel-Practice-Online.com gives you a simulated Excel interface right in your browser. Full workbook-style problems with instructions in a sidebar. Things like "create a pivot table showing average sales by region, filter to only show regions over $10k." It mirrors the actual Excel UI which helps build muscle memory. Kinda clever tbh.

So the pattern I recommend — and I wish someone told me this five years earlier — watch a 10-minute concept video, immediately do 3-5 practice exercises on that exact topic, then try to apply it to your own real data the same day. If you skip step 3, the knowledge decays within about 72 hours. At least that's been my experience. I'm not a neuroscientist or anything.

Keyboard Shortcut References

People who say "just use the mouse" are costing themselves hours per week and they don't even realize it. Here's the stuff that actually matters.

For navigation: Ctrl+Arrow keys to jump around large datasets without scrolling, Ctrl+Home and Ctrl+End to get to the edges of your data instantly. For selection: Ctrl+Shift+Arrow to select ranges, Ctrl+Space for columns, Shift+Space for rows — way faster than dragging. Formula entry: F2 to edit a cell without double-clicking, F4 to toggle between relative and absolute references, Ctrl+Enter to fill a selected range all at once. Formatting: Ctrl+1 opens Format Cells (use this daily), Ctrl+Shift+~ strips formatting to General, Alt+Enter adds a new line inside a cell. For pivot tables: Alt+N+V creates one, Alt+J+T+I refreshes it.

Download a printable shortcut PDF from ShortcutWorld.com or ExcelJet — both have clean one-page reference sheets organized by function. Print it. Tape it next to your monitor. Force yourself to use one new shortcut each day. After about two weeks you'll stop reaching for the mouse entirely for common operations and you'll feel physically pained watching coworkers drag-scroll through 50,000 rows.

Templates That Don't Suck

Most Excel templates are overdesigned garbage. Fourteen merged cells, conditional formatting that breaks the moment you add a row, colors that make your eyes bleed. Here are sources of templates actually designed by people who use spreadsheets daily.

Vertex42 — Jon Wittwer has been making templates since 2004 and his stuff holds up. Clean layouts. No macros unless actually needed. Well-documented with in-sheet instructions that tell you what goes where. His budget and invoice templates are particularly good because they account for edge cases most free templates just ignore. Like what happens when you have biweekly pay periods that don't align with calendar months. That kind of thing.

Microsoft's template gallery at templates.office.com has actually improved a lot in the last 2-3 years. Filter by Excel and look specifically at templates marked Premium — these tend to have better formula integrity. Avoid anything with a stock photo thumbnail. That's usually style over substance and you'll spend more time fixing it than building from scratch.

r/excel's Template Tuesday threads on Reddit. The community occasionally shares templates they've built for their own jobs and these are battle-tested in production — not pretty mockups someone made for a portfolio. Search the subreddit for "template" and sort by top of all time.

And honestly, the best template is the one you modify. I almost never use a template as-is. I strip out the color formatting first, test every formula on edge cases, then add back only the visuals that serve a purpose. Which is usually about 20% of what was there originally.

Where To Ask Questions — And Actually Get Answers

Google searches for Excel problems are getting worse. AI-generated blog posts with wrong syntax are flooding the results and half the time the "solution" doesn't even work in actual Excel. Here's where real humans answer questions.

r/excel on Reddit has 700k+ members and questions typically get answered within 30 minutes. Post a screenshot of your data structure and explain what you're trying to do. The community prefers clear problem statements over vague "I need help with Excel" posts. Mark your post solved with "Solution Verified" and the person who helped gets a point. It's a nice system actually.

MrExcel Forum — older demographic but Bill Jelen (MrExcel himself) and several MVPs actively answer questions here. Better for complex Power Query or VBA problems than Reddit. The search function pulls up 20+ years of archives and there's a good chance your exact problem was solved by someone in 2011. Which is both reassuring and mildly depressing.

Stack Overflow with the [excel] and [excel-formula] tags is best for formula-specific questions. The quality bar is higher than Reddit — you need to show what you've tried and what result you expected vs what you actually got. But the answers tend to be more authoritative when they come.

Microsoft Tech Community Excel section is hit or miss. Microsoft employees sometimes chime in on feature-request threads though, and it's the best place to report bugs or get clarification on undocumented behavior. I've had maybe a 40% success rate there. Your mileage may vary.

Rule of thumb before posting anywhere: try rephrasing your question three different ways. Half the time the act of articulating the problem clearly makes the solution obvious on its own. The other half, you'll find the answer through one of those phrasings before anyone even replies. It's weird how consistently this works.

Books That Are Still Relevant

Excel changes every year but the fundamentals haven't shifted much since dynamic arrays launched in 2019. These are worth the shelf space.

The Excel 2019 Bible by Michael Alexander and Dick Kusleika is a comprehensive reference — not something you read cover to cover. Use it like a dictionary when you encounter a feature you don't understand. The Power Query and Power Pivot sections alone justify the page count. It's a doorstop of a book but I reach for it maybe twice a month.

Ctrl+Shift+Enter: Mastering Excel Array Formulas by Mike Girvin is pre-dynamic-arrays era but the conceptual foundation is still relevant. Understanding how array formulas think is what separates people who write one formula from people who write formulas that spill and cascade properly. Hard to explain why this matters until you've seen someone chain 15 helper columns when 2 array formulas would do it.

Dashboarding and Reporting with Excel by Kasper de Jonge focuses on how to structure data for reporting. Which is honestly more important than the dashboard visuals themselves. Most bad dashboards are actually bad data models with pretty decorations slapped on top. This book gets that.

M Is for (Data) Monkey by Ken Puls and Miguel Escobar is the best introduction to Power Query's M language I've found. It's practically oriented — each chapter solves a specific data-cleaning problem you'll actually encounter in real life. Not academic exercises.

So many Excel books repackage the same basic content with different covers. These four each cover territory that most others skip entirely.

The One Resource Nobody Talks About

Microsoft's own documentation at learn.microsoft.com has improved dramatically and nobody seems to have noticed. Their function reference pages now include real-world examples with downloadable workbooks — not just the dry syntax descriptions they used to have. When I need the exact behavior of something weird like the third argument of INDIRECT or how XLOOKUP handles approximate match with unsorted data, I go straight to the Microsoft docs page for that function. I don't trust tutorial sites for edge cases anymore.

And the Excel Labs add-in — free from Microsoft, installed via Insert > Get Add-ins — contains experimental tools including the Advanced Formula Environment. It gives you a proper code editor for formulas with syntax highlighting, indentation, and the ability to store and reuse named formulas across workbooks. It's the closest thing to "Excel gets a real IDE" and almost nobody knows it exists. I mention it to people and they look at me like I've discovered a secret wing of the office building.

But here's where I'll leave it. The resource list is basically infinite and the real skill isn't knowing every tool that exists. It's knowing which one to reach for when you're stuck on a specific problem at 4pm on a Thursday and you just want to go home. That's the thing nobody teaches you and you kinda have to figure out on your own...