How to extract data from a website in Excel

How to extract data from a website in Excel

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...
How to convert European date to US date in Excel

How to convert European date to US date in Excel

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...
How to split text with Power Query in Excel

How to split text with Power Query in Excel

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...
How to unpivot data in Excel with Power Query

How to unpivot data in Excel with Power Query

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...
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...
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...