How to consolidate text by a condition in Excel

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. Download Workbook Please note that we will be using the new dynamic array functions UNIQUE and FILTER in this post. These functions currently are only available to Office 365...
How to create a 3D Map 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. Download Workbook What is a 3D Map? 3D Maps were first introduced as part of Power Maps as an add-in for Excel 2013. Along with Power Query. Power Maps can be useful for reporting purposes. In...
Excel Mouse Tips & Tricks

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. For keyboard shortcuts please see: 10 Most Useful Shortcuts in Excel Mouse tips and tricks for Excel window and structure Close All Click on the...
Hidden commands in Excel

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

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. Download Workbook We...
How to import XML files into Excel

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. Download Workbook Let...