Excel Tips and Tricks

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

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