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 ...

Have you ever opened an Excel spreadsheet and felt instantly overwhelmed by cluttered data, mismatched fonts, or confusing layouts? It’s a common frustration, yet so many of us accept it as the norm.

Have you ever stared at a massive spreadsheet, feeling overwhelmed by rows and columns of data that all seem to blur together? You’re not alone. Whether you’re tracking project deadlines, analyzing ...

Once you’ve built a Pivot Table, turning it into a chart is almost too easy. Simply click anywhere inside the table, go to Insert > PivotChart, and select your preferred chart type. You’d even get a ...

Software engineer Chandoo shares some Excel conditional formatting tricks that make for good-looking and useful spreadsheets, like a Gantt chart. Conditional formatting makes a cell look a certain way ...

A giant grid of numbers can be mind-numbing. Once I discovered the magic of color-coded rules, spotting shifts and irregularities got a whole lot easier. A vivid spreadsheet quickly calls attention ...

When working with a spreadsheet, shortcuts and tips that help you complete tasks faster or better are invaluable. Similar to ways to improve your workflow in Microsoft Word, Excel has its own set of ...

A: It wasn’t really clear to me from your question whether the formatting options that you’re trying to use are unavailable to you (grayed-out) or if you are able to activate them but they’re just not ...

Please note, there is a new version of this article, with more up-to-date information: 13 quick time-saving Excel tips and shortcuts. The one thing marketers agree on ...

Duplicate values aren't wrong, but you might not want to display them. Use this simple technique to hide duplicate values in Excel. Duplicate values aren’t wrong or bad, but they can be distracting.