Excel has many formatting options to give your spreadsheet the look it’s meant for. A simple number can be formatted to completely change what it represents. From a considerable list of number formats, we have two formats pertaining to money; the Currency format and the Accounting Number Format, and today we will talk about the latter.This … [Read more...]

A watermark is a message or image superimposed on a document. The very name watermark is a big hint at the nature of its transparency; the watermark is not intended to obstruct the contents of the document, only lightly mark them, and that too as a background.If that doesn't ring a bell as to what watermarks are, maybe seeing "Confidential", or … [Read more...]

This tutorial details deleting every other row in Excel. The requirement of the time may be some systematic sampling or selection, keeping data of even-numbered weeks/months, or maybe just slashing out one-half of too much information.In this guide, we demonstrate deleting alternate rows using functions & filtering and VBA. We use the results … [Read more...]

What happens when you copy-paste, let’s say a column of information, in Excel? You get the values and the font and cell formatting; an exact duplicate. Today’s tutorial is about copying the format of one or more cells to other cells in the same worksheet, workbook, or even to other workbooks.That brings us to the next question. What happens when … [Read more...]

Let’s learn how to count the number of characters in Excel. The count could be performed on a single cell and even a range of cells. While learning that, let’s also shed some light on counting specific characters too. This tutorial will teach you all that is mentioned above using the LEN function with different combos of the SUBSTITUTE, SUMPRODUCT, … [Read more...]

A checkmark or a tickmark can be used in Excel and this is the face of it - ✓Why do you need a checkmark in Excel? Most commonly, a checkmark says "Done". A more representable way of having "Done" and "Not Done" or "Yes" and "No" on the worksheets can be ticks and crosses. If that reminds you so much of a teacher's red ink on your work, let's … [Read more...]