Go to Master Data Analysis Yes, you read the title of this post correctly, you can calculate the median and lots of other functions in Excel PivotTables besides the regular options. If you’re a...

Go to Master Data Analysis 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...

Go to Master Data Analysis 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...

Go to Master Data Analysis 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...

Go to Master Data Analysis This is the second post of a series that covers everything about importing all files in a folder. Click here to see the series of post. In this scenario I’ll show you...

Go to Master Data Analysis Let’s say you have 50 CSV files in a folder and you need to import them into a single worksheet in Excel. How do you do that? Well, it turns out this is the simplest...

Go to Master Data Analysis I know what you’re thinking: “Another blog post about importing all excel files in a folder”, but this couldn’t be farther from the truth. As the title says, this is the...

Go to Master Data Analysis A common myth I hear very frequently is that you can’t work with more than 1 million records in Excel. Actually, the right myth should be that you can’t use more...

Go to Master Data Analysis With PivotTables you can process thousands (or millions) of rows extremely fast and show the results in dynamic charts called PivotCharts. During the week (June 13 – 19...