Import all CSV files in a folder into Excel

9 years ago

Go to Master Data Analysis Let's say you have 50 CSV files in a folder and you need to import…

Ultimate guide to import all files from a folder into Excel

9 years ago

Go to Master Data Analysis I know what you’re thinking: “Another blog post about importing all excel files in a…

Analyzing 50 million records in Excel

10 years ago

Go to Master Data Analysis A common myth I hear very frequently is that you can't work with more than…

Attend the R User Conference 2016 – Online

10 years ago

The R User Conference is one of the biggest R conferences around the world. It will be held at Stanford…

PivotTable Week – Learn all about PivotTables

10 years ago

Go to Master Data Analysis With PivotTables you can process thousands (or millions) of rows extremely fast and show the…

Minitab Shortcuts Cheat Sheet

10 years ago

Ok, I admit it, I’m a shortcuts lover… As soon as I put my hands into a computer program I…

8 tips to master data validation in Excel

10 years ago

Go to Master Data Analysis One of the great features that MS Excel has is the capability to restrict (validate)…

7 tips to deal with duplicates in MS Excel

10 years ago

Go to Master Data Analysis If you have worked with MS Excel for a while I bet you have had…

2 easy ways to import files from a folder into Minitab

10 years ago

Let me ask you a question: Let’s say you have 15 excel files (or .csv) in a folder. How do…

16 courses to learn R in 2016

10 years ago

Do you want to learn or get better at R programming?  If yes, you will love the list below. I…