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 Create a Dynamic Top 10 List in Excel
-
How to Trim Spaces with Excel VBA
-
How to Get a Cell Address with Excel VBA
-
How to Import the Current Workbook into Power Query
-
How to Use SUMIFS With Arrays in Excel
-
How to Append Queries in Excel Power Query
-
How to Organize Excel Tabs Under a Master Sheet
-
How to Build an Amortization Schedule with Irregular Payments in Excel
-
How to Refresh Excel Queries Automatically
-
How to Convert Text into a Formula in Excel
-
How to Calculate Percentiles with Criteria in Excel
-
How to Calculate Distance Between Coordinates in Excel
-
How to Analyze Time-Series Data in Excel
-
Horizontal Scrolling Not Working in Excel: How to Fix It
-
How to Calculate Years of Service in Excel
-
How to Smooth Data in Excel
-
How to Convert Seconds, Minutes, and Decimal Hours to Time in Excel
-
How to Highlight Cells That Contain Text from a List in Excel
-
How to Calculate Pro Rata Amounts in Excel
-
How to Calculate Credit Card Interest in Excel
-
How to Build a SlopeGraph in Excel
-
How to Calculate Area Under a Curve in Excel
-
How to Calculate Payback Period in Excel
-
How to Hide Notes in Excel (One Cell or All Notes)
-
How to Make a Dot Plot in Excel
-
Rows to Repeat at Top Greyed Out in Excel? How to Fix It
-
How to Turn Off Sheet View in Excel
-
How to Graph an Equation in Excel
-
Why Is Show Changes Greyed Out in Excel?
-
Excel Not Highlighting Selected Cells? How to Fix It
-
How to Find and Replace Tab Characters in Excel
-
How to Create a Step Chart in Excel
-
Filter by Color Not Working in Excel? How to Fix It
-
How to Trace Precedents and Dependents in Excel
-
How to Create Custom Keyboard Shortcuts in Excel
-
How to Calculate MAPE in Excel
-
How to Calculate Cronbach’s Alpha in Excel
-
How to Calculate Median in an Excel Pivot Table
-
How to Create a Gauge Chart in Excel
-
How to Create a Break-Even Chart in Excel
Looking for something specific? Use the search icon in the main navigation or visit the site search page.