-
Continue reading →: CALCULATED COLUMNSCalculated columns in Excel are very useful for entering formulas. Instead of typing ranges or fill commands, we can enter a single formula in one cell. Our main goal is to calculate the total amount of all the fruits in the picture below. Follow the steps below. We use the…
-
Continue reading →: COUNT VISIBLE ROWS IN A LISTWe often works with lists or tables, that are filtered. Sometimes it is convenient to show the total number of rows that are visible. First we need to enter some data. Now for the formula, we can enter it in cell C2: =SUBTOTAL(3;B6:B12)
-
Continue reading →: EXCEL – SEARCH AND GET VALUESExcel is a great tool to search for and if exists, return those values. In column A and B we have a list of fruits, and a column of empty prices. In column D and E we have fruits and it’s price. Our goal is to locate the fruits and…
-
Continue reading →: SEARCH IF VALUE EXIST – #N/AIn the last post we used look-up functions to find a fruit and its amount. That formula did not take into account miss-spellings or items that dit not exist in the list. In the search field in C13, we have spelled APPLE wrong. Instead of getting #N/A, we now return…
-
Continue reading →: SEARCH IF VALUE EXISTIn this post, we will enter some values in multiple columns. Then, we will create a cell where we search for that value. Below is our final result, we have a bunch of fruits, and their amount. In cell C13 we enter the fruit that we want to search for.…
-
Continue reading →: EXCEL TRICK – MULTIPLICATION TABLEIt is pretty simple to make an multiplication table. We need a mixed reference to achieve this. This is the final result Below is our starting point. In cell C5, enter the following formula
-
Continue reading →: EXCEL TRICK – GET VALUE FROM ANOTHER SHEETIn Excel there is often need to get values from another sheet. Here I will show you how you can do that in the most simple way possible. Follow the steps below.
-
Continue reading →: EXCEL TRICK – SCOREBOARDIn this post, we are going to make a scoreboard with images. Rather, we will make use of conditional formatting and icon-sets. Below we enter some fruits, and their monthly sales. Depending on the number, we can choose to represent the score with an arrow. Good numbers are represented with…
-
Continue reading →: EXCEL TRICK – SCORE BOARDWe can use Excel as a tool to keep track of high-score or a leading-board. Below we have three columns of data: Our aim is to sort the SCORE from highest to lowest value. In the picture above, the score is sorted according to that criteria. However, we want to…
-
Continue reading →: EXCEL TRICK – TALLY SCOREA tally score or graph present the frequency of something, like scores. Unfortunately Excel does not include a tally graph, here we will create our own. The final result will look like this: We need some helper-columns – which we later can hide. In D1 enter the following: In E1…
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Excel tutorials 