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

Spread the loveLine graphs are a powerful tool for visualizing data trends over time. They are commonly used in business, science, and academia to display changes in data sets over a period of time.

The Pointy Haired Dilbert blog runs down the details of this nifty Excel trickery, which uses a formula and an image to conditionally show or hide the chart —neat stuff sure to impress the boss.

Having covered all the basics of how to make tabular data tell a story using custom cell formatting and conditional formatting for both static tables and pivot tables, we’re now going to jump ...

How to Make a Graph in Excel With Word and Number Variables. Microsoft Excel can perform numerous statistical functions, as well as create charts from statistical data. Statistical data includes ...

Using Excel's conditional formatting, I was able to identify duplicate values by highlighting the cells. Using Excel's SUMIF function, I summed up all the values for each productline, months, and ...

Here are 5 useful Excel features to use to make your work simpler. Adding spark lines, adding splicers to charts and removing duplicates, etc.

By converting an image to an Excel format, users can easily pull out the information they need and store it in a spreadsheet. This makes it easier to analyze, compare, and manipulate the data in ...