Explore Spreadsheet Planet

Find any tutorial.

Browse by topic or scan the complete article archive below. Use the pagination to move through every published guide.

Browse popular topics

All tutorials

The newest articles appear first. This list updates automatically whenever a new tutorial is published.

View XML sitemap

How to Find the Last Row With Data in Excel
How to Convert Date to Fiscal Year in Excel
How to Filter Horizontally in Excel (Filter Across Columns)
How to Make a Slicer Drop-Down List in Excel
How to Add a Search Box to a Slicer in Excel
How to Limit a Slicer to One Selection in Excel
How to Change Slicer Font Size, Color and Style in Excel
How to Protect a Sheet but Allow Slicers in Excel (and Lock Their Position)
How to Get the Start and End Date of a Week in Excel
How to Make a Pie Chart in Excel (With Percentages)
How to Custom Sort Slicer Items in Excel (Months and Custom Order)
Convert Inches to Feet and Inches in Excel (Without the 5′ 12″ Bug)
Calculate Income Tax in Excel Using Tax Brackets
Highlight Entire Row Based on Cell Value in Excel
Remove Old Items or Blanks From a Slicer in Excel
How to Show the Slicer Selection in a Cell in Excel
Slicer Not Working or Greyed Out in Excel (How to Fix It)
Slicers vs Filters in Excel (Differences and When to Use Each)
How to Use a Timeline in a PivotTable in Excel
How to Create an Interactive Dashboard in Excel (With Slicers)
How to Extract a Word Containing Specific Text in Excel
How to Calculate Age in Excel From Date of Birth
How to Calculate an Annuity in Excel (Payment, Present Value, Future Value)
How to Calculate BMI in Excel
How to Create a Gantt Chart in Excel
How to Create an Attendance Tracker in Excel
How to VLOOKUP From Another Sheet in Excel
How to Count Words in Excel (in a Cell or Range)
How to Create a Dynamic Named Range in Excel
How to Use Structured References in Excel
How to Calculate Simple Interest in Excel
How to Create a Timesheet in Excel (Hours Worked, Breaks & Overtime)
How to Calculate a Running Count of Occurrences in Excel
How to Calculate Percentage in Excel (Percentage Formula)
How to Convert a Unix Timestamp to a Date in Excel
Data Validation in Excel: How to Add, Use, and Remove It
How to Calculate Pass or Fail in Excel (Multiple Subjects)
How to Use Slicers in Excel (Beginner to Advanced Guide)
Status Bar in Excel: Where It Is, What It Shows, and How to Customize It
New Excel Functions in Microsoft 365 (With Examples)

Looking for something specific? Use the search icon in the main navigation or visit the site search page.