Import all CSV files in a folder into Excel

8 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

8 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

9 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

9 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

9 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

9 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

9 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

9 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

9 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

9 years ago

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