Dollar signs ($) in Excel are great for quickly identifying cells that contain monetary values. There are times, however, that it would be better to remove them. In this article, I’ll show you four different ways to do this. Each approach has its pros and cons, so choose whichever fits your needs. The first two … Read more
Timestamps in Excel typically contain both the date and the time. We often, however, disregard the time and only use the dates in timestamps. In this tutorial, I will show you varying ways you can do to remove the time – both temporarily and permanently. Before I give a breakdown of the various methods to … Read more
Splitting a worksheet into panes or sections is great for keeping certain contents within the sheet (like the headers) to be always on display even when we scroll to other areas in the sheet. Excel allows us to split the worksheet into two or four panes. Once a worksheet is split, you can scroll through … Read more
An IF statement is a function in Excel that enables us to determine whether a particular condition is met. For every condition, there are only two possible answers: It uses the following syntax: =IF(logical_test, [value_if_true], [value_if_false]) LOGICAL OPERATOR MEANING = Equal to <> Not equal to > Greater than < Less than >= Greater than … Read more
Have you ever tried writing a formula that worked well on one cell, but when you copied and pasted it to other cells, it no longer worked as expected? That could be a sign that you need to anchor at least one of the cells referenced in your formula. In this tutorial, I will show … Read more