When you use Microsoft Excel to analyze your company's data, you want to spot trends, successes and problems at a glance. Before you dive into an in-depth examination of specific sales results, ...

Build a fast Excel money tracker with SUMIFS totals, color coding, and charts, so you see monthly savings and trends without manual work.

How to force a consistent phone number format in Microsoft Excel Your email has been sent Combine an Excel custom format with data validation and remove the pressure ...

How to add a conditional format that highlights groups in Excel Your email has been sent The article, How to use a border to discern groups more easily in Microsoft Excel, shows you how to use a ...

Have you ever spent hours perfecting your Excel spreadsheet, only to watch your carefully crafted formatting fall apart the moment you insert a new row? It’s a maddeningly common issue for Excel users ...

Dennis O'Reilly began writing about workplace technology as an editor for Ziff-Davis' Computer Select, back when CDs were new-fangled, and IBM's PC XT was wowing the crowds at Comdex. He spent more ...

Sync your drop-down menus with table headers using this robust, auto-expanding Named Range trick.

Copying a chart from a Microsoft Excel workbook document into your PowerPoint presentation can save you the time and effort of creating a new chart in a PowerPoint slide. By default, the copied chart ...

Excel's Format Painter button is seductive. It promises speed and efficiency, and for a quick fix on a handful of cells, it delivers. But once your workbook grows, the tool becomes frustrating, ...