by Ilker | Nov 28, 2022 | Excel Tips & Tricks
Excel's extracting data capability is not a new thing. However, it has become more flexible with Power Query. In this guide, we're going to show you how to extract data from a website in Excel. Download Workbook Extracting data from a website in Excel by using Power...
by Ilker | Nov 1, 2022 | Excel Tips & Tricks
Date formats vary between countries. If you need to work with external source reports from a different country, you may see that Excel doesn't recognize the dates or recognize them wrongly. The most common case happens between US and European countries because of the...
by Ilker | Apr 30, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to find all combinations of two lists in Excel by using Power Query. Download Workbook In our example, we have two lists that contain Pokémon names and we want to see the combinations of matched Pokémon. We can join...
by Ilker | Apr 26, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to compare two tables using Get & Transform Data in Excel. Download Workbook In our example, there are two identical tables with the same column names. Although both tables contain the same data under the Name...
by Ilker | Mar 2, 2021 | Excel Tips & Tricks
Power Query is a data management tool in Excel. In this guide, we’re going to show you how to split text with Power Query in Excel. Download Workbook What is Power Query Power Query is a feature of Excel that makes access to data easier and manageable. If you...
by Ilker | Jan 20, 2021 | Excel Tips & Tricks
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. Download Workbook...
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 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...