Reading a chart of numbers can be made more difficult if you have long column headers that expand the width of the cells. Long column headers can even cause the dreaded horizontal scroll that everyone hates so much.Abbreviating headers can

Deciphering a spreadsheet is easier with Excel conditional icons, which visually communicate changes and differences in numbers with directional arrows, stop light colors, flags, and bars. In the example above, a simple sales report has been dressed up with Excel

A common problem in processing data in Excel is handling duplicates or double entries. Excel has a few convenient tools for quickly making these changes. Simply eliminating duplicate entries in Excel After highlighting your chart of data, click on the

Excel automatically converts numbers with 15 or more digits into scientific notation. In fact, when it simplifies the number it loses the rounded digits. They aren’t recoverable.As long as you don’t use numbers larger than a quadrillion, this isn’t a

How many days until the end of the year? How many days until the big meeting? Use this simple Excel countdown formula to find out.The DATEVALUE formula converts a date into a number in Microsoft Excel date-time code. This allows

There a couple of ways to add page numbers to a Microsoft Excel worksheet.In the Page Layout tab, click on the Page Setup Additional Options button. Bring up the Header /Footer tab, and use the drop down menus to add

If you have a large spreadsheet of information, you may often want to sort the information by more than one column. For example, what if you want to sort by date, but then sort by name within those dates?