When multiple people work on the same Excel spreadsheet, it can be difficult to keep track of changes. As an example, a balance sheet might have been updated to reflect new payments. To draw attention ...

Many Microsoft Excel sheets store date and time values. Sometimes the two values appear in the same cell, and sometimes they do not. If you work with dates and/or times, you need a good understanding ...

One of the most common requests I receive from users is how to identify duplicate and unique values in Microsoft Excel. The easiest way I know is to apply a conditional format. In a nutshell, a ...

Excel displays the original number up to 11 digits. When you enter a number that has more than 11 digits, Excel does not display the original value. Instead, it displays the number in the exponential ...

All the cells of negative numbers will become red, while the positive numbers will remain the same. You can create your own custom format in Excel to highlight negative numbers. Select the range of ...

Most numbers used in business are based on 10 – commonly known as the decimal system. One dollar is $1.00 and a half-dollar is $0.50. Time, of course, is an exception because it's based on 12. The day ...

Excel spreadsheets are a daunting affair for many. And indeed, when you are confronting dozens of rows and columns comprising hundreds if not thousands of cells filled with all sorts of data, it's ...

Microsoft Excel is a powerful spreadsheet program that can be used for a variety of tasks, including basic math. Here's how to use Excel as a calculator to perform basic arithmetic operations such as ...