Practical Excel guidance
Master Excel.
Work smarter.
Straightforward tutorials, formulas, shortcuts, VBA, and Power Query guides that help you solve real spreadsheet problems—without the jargon.
Free: the Excel Speed Pack. A printable shortcuts cheat sheet and 100 formulas with worked examples, plus one short Excel tip a day.
Start with a topic
Find the help you need
From your first formula to advanced automation, jump directly into the area you want to master.
Reader favorites
Popular Excel tutorials
Trusted walkthroughs for the Excel questions people run into most often.
Popular guide
Add text to the beginning or end of cells
Add prefixes or suffixes across a column using formulas, Flash Fill, or VBA.
Read tutorial →
Dates & time
Convert a date to the day of the week
Display weekday names from any date with simple formatting and formulas.
Read tutorial →
Formulas
Use multiple IF statements with AND/OR
Build formulas that test several conditions and return the right result.
Read tutorial →
Data checks
Compare two columns using VLOOKUP and IF
Match values, find differences, and flag missing entries across two lists.
Read tutorial →
Data cleanup
Fill blank cells with the value above
Complete sparse datasets quickly without copying and pasting row by row.
Read tutorial →
Dates & formulas
Use the IF function with dates
Test deadlines, date ranges, and milestones with practical IF examples.
Read tutorial →Get the Excel Speed Pack, free
A printable shortcuts cheat sheet and 100 essential formulas with worked examples. In your inbox in a couple of minutes.
Plus one short Excel tip every day. One idea, one worked example, 30 seconds to read.
Fresh from the library
Latest Excel articles
New tutorials and updated walkthroughs, published regularly.
-
Remove Old Items or Blanks From a Slicer in Excel
If your slicer keeps showing items you deleted from the data, or a (blank) button nobody asked for,…
-
How to Show the Slicer Selection in a Cell in Excel
A slicer makes it easy to see what you’ve filtered while you’re looking at it. But the moment…
-
Slicer Not Working or Greyed Out in Excel (How to Fix It)
A slicer is the easy way to filter a PivotTable or Table in Excel, so it’s annoying when…
-
Slicers vs Filters in Excel (Differences and When to Use Each)
Slicers and filters in Excel do the same basic job. They hide the rows you don’t want so…
-
How to Use a Timeline in a PivotTable in Excel
A Timeline in Excel is a date filter for PivotTables. Instead of ticking dates in a drop-down, you…
-
How to Create an Interactive Dashboard in Excel (With Slicers)
An interactive dashboard in Excel puts your key numbers and charts on one sheet, and lets anyone filter…
Your guide to better spreadsheets
Hi, I’m Steve Scott.
I created Spreadsheet Planet to share the practical Excel techniques I was learning and using every day. What began as a side project has grown into a library that helps thousands of learners solve spreadsheet problems more confidently.
Excel is more than software—it is a career skill. My goal is to make every tutorial clear, useful, and easy to put into practice right away.
Need a quick answer?
Skip the formulas and use a calculator.
Explore ready-to-use finance, investment, business, statistics, and utility calculators.
The Excel Speed Pack, free in your inbox.
The shortcuts cheat sheet, 100 formulas, and one short Excel tip a day.