How to work with drop down lists in MS Excel

10 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

7 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

7 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

8 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

8 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

8 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

8 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

8 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

8 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

8 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

8 years ago

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