Microsoft Excel is a powerful database management tool with all sorts of in-depth problem-solving functions and dynamic formatting. To make the most of it, though, you need to know the basics. Using ...

Excel considers dates and times as numbers in cells, making calculation difficult. Excel processes 6 AM as "0.25," because it is one quarter of the way through the day. If you need to add a number of ...

Columns organize data in Excel, and are often used as categories with headers to sort cells. You can simply right-click on an existing column to add another column immediately before it. To add ...

Many of them are backward- and forward-compatible, but check the system requirements before you download anything. Note that newer isn’t always better: Many of the ...

The legend on an Excel scatter plot is simply a list of the names for each of the series on the chart. The legend is color coordinated, so you can quickly determine which data points belong to which ...