Excel Tips and Tricks
How to unpivot data in Excel with Power Query
How to unpivot data in Excel with Power Query Power Query is a data management tool that helps change the layout or other properties of data easily. In this guide, we're going to show you how to unpivot data in Excel with Power Query. [button...
How to calculate the volume of a sphere in Excel
In this guide, we're going to show you how to calculate the volume of a sphere in Excel. The...
How to do an image lookup in Excel
Excel's lookup functions recently welcomed the addition of XLOOKUP and XMATCH. However, neither these new functions or the existing ones don’t support image lookup. In this guide, we're going to show you how to make image lookup in Excel. [button...
What is the difference between XLOOKUP and VLOOKUP?
In this article, we are going to show you the differences between XLOOKUP and VLOOKUP functions. Download...
How to avoid formatting change in CSV files in Excel
Data formatting can get mixed up when you open a data file with CSV format. In this article, we are going to show you how to avoid formatting change in CSV files in Excel. [button link="https://spreadsheetweb.com/wp-content/uploads/2021/01/Data.csv" type="big"...
How to consolidate text with Pivot Table in Excel
In this article, we are going to show you how to consolidate text with Pivot Table in Excel 2013 or newer. Download...
How to consolidate text by a condition in Excel
In this article, we are going to show you how to consolidate text by a condition in Excel. ...
How to create a 3D Map in Excel
In this article, we are going to show you how to create a 3D Map in Excel. What is a 3D Map? 3D Maps were...
Excel Mouse Tips & Tricks
In this article, we are going to show you some mouse shortcut tips and tricks that will enhance your Excel productivity. Mouse tips and tricks for Excel window and structure...