Excel Tips and Tricks
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...
How to import XML files into Excel
XML is a common file type for storing and transferring data. In this article, we are going to show you how to import XML files into Excel using two methods: First is a more "direct method" and the other is the Power Query approach. [button...
How to find the last day of a month in Excel
In this article, we are going to show you how to find the last day of a month in Excel. We...
How to find the position of the minimum value in Excel
You can find the minimum value in a range or array using the MIN, MINA and MINIFS functions. If you need to find the position of the minimum value instead, you will need a combination of these functions. In this article, we are going to show you how to find the...
How to find the position of the maximum value in Excel
Excel has the MAX, MAXA and MAXIFS functions that can find the maximum value in a range or array. If you need to the position of the maximum value, however, you need to combine these formulas with others. In this article, we are going to show you how to find the...