Select Page

Data Sciencing Blog
Our Latest Posts

Format Painter – Let’s Have Data Fun with Excel

Let’s pretend you’re working in your Excel spreadsheet and you want to change the formatting of the cells in a column. You might experiment first with one cell. To see what it looks like, before you spend time copying to all your cells. Let’s first change the font of...

Survivorship Bias in Business

What is your company doing to not get duped by the survivorship bias trap? I’ll give you a classic example of survivorship bias. You might recognize this picture if you’ve studied survivorship bias, statistics, or data visualization. In World War 2 the U.S. Military...

Paste Transpose – Let’s Have Data Fun with Excel

Let’s say you want cells that are currently vertically in a column, horizontally in a row - let's learn how to use "paste transpose" to prepare the data in the desired format. One thing you can do is, select the relevant cells. Then copy them. Next select the cell you...

Data Sciencing Blog
All Posts

Format Painter – Let’s Have Data Fun with Excel

Format Painter – Let’s Have Data Fun with Excel

Let’s pretend you’re working in your Excel spreadsheet and you want to change the formatting of the cells in a column. You might experiment first with one cell. To see what it looks like, before you spend time copying to all your cells. Let’s first change the font of...

Survivorship Bias in Business

Survivorship Bias in Business

What is your company doing to not get duped by the survivorship bias trap? I’ll give you a classic example of survivorship bias. You might recognize this picture if you’ve studied survivorship bias, statistics, or data visualization. In World War 2 the U.S. Military...

Paste Transpose – Let’s Have Data Fun with Excel

Paste Transpose – Let’s Have Data Fun with Excel

Let’s say you want cells that are currently vertically in a column, horizontally in a row - let's learn how to use "paste transpose" to prepare the data in the desired format. One thing you can do is, select the relevant cells. Then copy them. Next select the cell you...

Let’s Have Data Fun with Excel: Auto Total

Let’s Have Data Fun with Excel: Auto Total

Let’s imagine you have a column of values in your spreadsheet and you need to easily calculate the total of all those values, aka figure out the sum. What you can do is, select all your values in the column and add an extra cell at the bottom. Next, on your keyboard...

Let’s Have Data Fun with Excel: Column and Row Width

Let’s Have Data Fun with Excel: Column and Row Width

Has it ever happened to you, where you open an excel file and you notice the column names are cut off and you can’t see all the information you want to look at?  One thing you can do, to widen the column width is select the column. Then go on the menu, under...

Let’s Have Data Fun with Excel: Freeze Panes

Let’s Have Data Fun with Excel: Freeze Panes

Imagine you’re working in your Excel spreadsheet and you scroll down the rows and notice your column names are missing. One way to prevent that from happening is to go into the menus and under ‘View’ select ‘Freeze Top Row’. Now the top row will be frozen, so you will...

Let’s Have Data Fun: the Monty Hall Problem

Let’s Have Data Fun: the Monty Hall Problem

The Monty Hall problem is named after the original host of the game show Let's Make a Deal, Monty Hall. The problem is this: Let's pretend you're on a game show, and you're given the choice to pick one of three doors. Behind one door is a car (a winning prize)...

Let's Start Something new
Say Hello!

Complete the form below and we'll be in touch.