by Ilker | Jan 12, 2021 | Excel Tips & Tricks
In this article, we are going to show you the differences between XLOOKUP and VLOOKUP functions. Download Workbook Please note that the XLOOKUP function is currently only accessible for Microsoft 365 subscribers. XLOOKUP(lookup_value, lookup_array, return_array,...
by Ilker | Jan 6, 2021 | Excel Tips & Tricks
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. Download Workbook If you need to prevent numbers from changing into dates when entering data,...
by Ilker | Jan 5, 2021 | Excel Tips & Tricks
In this article, we are going to show you how to consolidate text with Pivot Table in Excel 2013 or newer. Download Workbook If you are using Office 365, also see our alternative approach for consolidating text in Excel. Thanks to the dynamic array functions like...
by Ilker | Jan 5, 2021 | Excel Tips & Tricks
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...
by Ilker | Dec 29, 2020 | Excel Tips & Tricks
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...
by Ilker | Dec 24, 2020 | Excel Tips & Tricks
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...
by Ilker | Dec 22, 2020 | Excel Tips & Tricks
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...
by Ilker | Dec 21, 2020 | Excel Tips & Tricks
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...
by Ilker | Dec 18, 2020 | Excel Tips & Tricks
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...