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.
-
How to Calculate Safety Stock in Excel
-
How to Export Excel to a Pipe-Delimited Text File
-
How to Add and Rename a Chart Legend in Excel
-
How to Import HTML Tables into Excel
-
How to Insert and Edit Equations in Excel
-
How to Create a Broken Axis Chart in Excel
-
How to List All Permutations in Excel
-
How to Insert and Link an Excel File in PowerPoint
-
How to Add and Customize Data Bars in Excel
-
External Data Connections Have Been Disabled in Excel: How to Fix?
-
How to Calculate Autocorrelation in Excel
-
How to Create a Stopwatch in Excel
-
Excel Not Saving Formatting: Causes and Fixes
-
How to Create Automatic Rolling Months in Excel
-
How to Sum Multiple Matching Rows in Excel
-
How to Create and Customize a Treemap Chart in Excel
-
How to Create, Use, and Remove XML Maps in Excel
-
How to Use COUNTIF with VLOOKUP in Excel
-
How to Sum Every N Rows in Excel
-
How to Add a Calculated Item to a Pivot Table in Excel
-
How to Use Criteria in Excel Formulas (With Examples)
-
How to Convert Currency in Excel
-
How to Work With Complex Numbers in Excel
-
How to Show Percentage of Total in an Excel Pivot Table
-
Margin Formula in Excel (Profit Margin and Markup)
-
How to Group Data in a Pivot Table (inc. Custom Groups)
-
Order of Operations in Excel
-
How to Calculate Working Days in a Month or Year in Excel
-
How to Filter by Date in Excel (Including Date Ranges)
-
How to Make a Stacked Bar Chart in Excel (Including 100% Stacked)
-
How to Categorize Text Based on Keywords in Excel
-
How to Add Double Quotes in an Excel Formula
-
How to Reference Another Sheet Dynamically in Excel
-
How to Use SUMIF Across Multiple Sheets in Excel
-
How to Calculate a Running Total in Excel
-
How to Round to Significant Figures in Excel
-
How to Calculate Monthly Averages in Excel
-
How to Repeat Rows in Excel
-
How to Calculate Employee Retirement Dates in Excel
-
How to Name a Range in Excel
Looking for something specific? Use the search icon in the main navigation or visit the site search page.