Import excel files with a dynamic starting row

This is the 4th post of a series that covers everything about importing all files in a folder into Excel using a tool called Power Query. Click here to see the series. The previous scenario covered how to import all Excel files in a folder getting the data below the 9th row. Therefore, the data on all […]

Import specific cells from Excel files

This is the 5th post of a series that covers everything about importing all files in a folder into Excel using a tool called Power Query. Click here to see the series. In this post, I’ll show you how to import the contents from specific cells of all files in a folder. For example, in the file […]

Import and clean each file from a folder

This is the third post of a series that covers everything about importing all files in a folder into Excel. Click here to see the series. The previous scenario covered how to import all Excel files in a folder, however, for that example we assumed that all files had the right format and were ready to be […]

8 tips to master data validation in Excel

One of the great features that MS Excel has is the capability to restrict (validate) the input into certain cells. The name of this feature in MS Excel is Data Validation. A few examples of this is to restrict the values of cells to be text of a certain length numbers within range a selection from […]

7 tips to deal with duplicates in MS Excel

If you have worked with MS Excel for a while I bet you have had the need to highlight/count unique or duplicate values. In this post I’ll cover all you need to know to deal with duplicate/unique values in MS Excel. After reading this post you’ll be able to: Highlight duplicate values in MS Excel […]

10 great examples to master date functions in Excel (Part 1)

There are many ways of working with dates in Excel. In this first part I’ll cover 5 out of 10 great examples to help you master date functions in Excel. Before getting started we need to understand how Excel deals with dates. If you type any date in Excel, for example 06/12/2015, and change the […]