Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 29 of 60 · 540 articles
How to unpivot data in Excel with Power Query
A proper data layout is must for data analysis. In this guide, we're going to show you how to unpivot data in Excel with Power Query.
How to calculate the volume of a sphere in Excel
Learn how to calculate the volume of a sphere in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to do an image lookup in Excel
In this guide, we're going to show you how to make image lookup in Excel with XLOOKUP and INDEX-MATCH formulas.
What is the difference between XLOOKUP and VLOOKUP?
Learn about what is the difference between XLOOKUP and VLOOKUP in Excel, including the relevant formula or feature, setup steps, and practical usage.
How to avoid formatting change in CSV files in Excel
In this article, we are going to show you how to avoid formatting change in CSV files in Microsoft 365, Excel 2019, 2016, 2013 and 2010.
How to consolidate text with Pivot Table in Excel
Learn how to consolidate text with Pivot Table in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to consolidate text by a condition in Excel
Learn how to consolidate text by a condition in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to create a 3D Map in Excel
Learn how to create a 3D Map in Excel. This practical guide covers the required setup, step-by-step process, and useful Excel options.
Excel Mouse Tips & Tricks
In this article, we are going to show you 12 awesome mouse tips and tricks that will level up your productivity in Excel.