by Peter Koebel | Jul 28, 2022 | Uncategorized
Have you ever been in a situation, where you need to easily select all cells in a direction? One way to easily do this, is in the top right of your keyboard press the “End” key. On the bottom left hold down “Shift”. On the bottom right of your keyboard, press the down...
by Peter Koebel | Jul 28, 2022 | Uncategorized
What is your company doing to avoid 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 wanted to...
by Peter Koebel | Apr 8, 2022 | Uncategorized
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...
by Peter Koebel | Nov 24, 2020 | Uncategorized
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....
by Peter Koebel | Nov 5, 2020 | Uncategorized
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. Auto Total is what you need! In order to use Auto Total, what you can do is, select all your values in the column and...
by Peter Koebel | Oct 27, 2020 | Uncategorized
Has you ever opened an Excel file and noticed the column names are cut off and you can’t see all the information you want to look at? Adjusting column and row width is what you need! One thing you can do, to widen the column width is select the column. Then go on the...