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

The Quick Analysis menu won't replace everything you do in Excel, but it handles the repetitive stuff faster than navigating through ribbons. This shortcut eliminates most of the steps for you if you ...

As you probably most already know Excel is a powerful tool for data analysis and presentation. To make your spreadsheets stand out, mastering advanced formatting techniques is essential. This guide ...

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 REPT function is a hidden gem that can transform your bar charts from ordinary to extraordinary. This function allows you to repeat text a specified number of times, allowing you to simulate ...

on a worksheet, but the same values may look awkward in an Excel chart. By default, charts use the same number format as the worksheet’s original data series. The good news is you do not have to ...

Once you create a fantastic looking chart in Microsoft Excel, you may decide that you want to reformat some existing charts to look just like it. Find out how to copy a chart's format to another chart ...

So, you need some eye-popping visuals to show off your top sales numbers for that meeting in 40 minutes but data, not design, is your forte. No problem. With Excel 2013—even if you’ve never used ...

It's time to dump the pie charts and move to donuts or even waterfalls to show off your data in ways people can better grasp. Have you noticed that people groan when you pop open a spreadsheet to ...

Microsoft Excel 2007's conditional formatting feature allows you to format cells based on certain criteria. As an example, you might want the row color to change based upon a credit or debit on a ...