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 … 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 … 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 … 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], … 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 … Read more
When we print a document in Word, we don’t usually pay much attention to the page setup. The printed output would nearly always match how we see it on the computer screen. With Excel, however, … Read more
Gridlines, by default, are not shown when you print a worksheet in Excel. There is, however, a way for you to be able to print them too. In this tutorial, I will teach you how … Read more
When working with a data set, there will be times when you need to rearrange the columns. These can occur whenever you need to compare similar fields side by side. In this article, I’ll show … Read more
The #NUM error in Excel practically means there’s something wrong with the numeric values in your Excel formula. This error, however, can mean different things depending on the context of the Excel function used. In … Read more
If you are currently working on a long list of numbers in your Excel file and are looking for ways to move the decimal places in them, either to the left or right, then you’ve … Read more