How to work with drop down lists in MS Excel

11 years ago
Orlando Mezquita

Go to Master Data Analysis Have you ever wanted to create a drop down list in Excel to avoid data…

18 courses to learn R in 2018

9 years ago

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

Calculating the median in Excel PivotTables

9 years ago

Go to Master Data Analysis Yes, you read the title of this post correctly, you can calculate the median and…

Using R to predict if a customer will buy

9 years ago

In this post, I’ll show how to create a simple model to predict if a customer will buy a product…

Data Science for Beginners

9 years ago

Are you wondering what's all this buzz about data science? The following videos will give you a good introduction to…

Import excel files with a dynamic starting row

10 years ago

Go to Master Data Analysis This is the 4th post of a series that covers everything about importing all files…

Import specific cells from Excel files

10 years ago

Go to Master Data Analysis This is the 5th post of a series that covers everything about importing all files…

Import and clean each file from a folder

10 years ago

Go to Master Data Analysis This is the third post of a series that covers everything about importing all files…

Creating animations from ggplot2 plots

10 years ago

Note: This post was published on February 14th (Valentine's day) First things first, Marioly, thanks for being a loving wife…

How to plot individual values with a mean line in Minitab

10 years ago

One of the most useful charts in Minitab is the Individual Values Plot since it allows you to see the…

Import all sheets from all files in a folder into Excel

10 years ago

Go to Master Data Analysis This is the second post of a series that covers everything about importing all files…