Resources
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://www.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...
Hidden commands in Excel
Some quick access features are not enabled by default in Excel, and needed to be added manually. In this article, we are going to show you some of hidden commands in Excel. How to add hidden commands We will focus on using the Quick Access Toolbar (QAT) because you...
How to get a list of file names in Excel
Tracking and managing data across multiple files can be challenging. With Power Query, you can get the file names from a specific folder and all its sub-folders. In this article, we are going to show you how to get a list of file names in Excel. [button...
How to use the "Pick from drop-down list" feature in Excel
Dropdown lists are a common example of data validation used in organizing data input. In this article, we are going to show you how to use pick from drop-down list feature in Excel. [button...