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

When you create a graph that includes dates, Excel 2013 automatically spaces the data in chronological order. This behavior potentially creates irregular spacing with unpredictable formatting. If the ...

Microsoft Excel can present two series of data points together on the horizontal axis, but if the number scale for each series dramatically differs, the data will not be readable. Using a two-sided ...

Learn how to build an interactive Excel dashboard from scratch using pivot tables in this video. We'll create a sales ...

In this article, we explain how to create Gantt Chart in Microsoft Excel. Project management is the foundation for achieving any business goals within the given time constraints. It ensures there is a ...

Whether presenting a project at school, delivering a critical report at work, or simply trying to make sense of your budget, graphs are efficient and visually appealing means of conveying complex ...

How to make the default area chart in Microsoft Excel more attractive Your email has been sent Microsoft Excel produces great charts, but sometimes they’re not visually pleasing. Learn how to change a ...

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

Tired of erasing holes in your graph paper or having to start over from scratch? Here's an easy way to create your own custom graph paper in Excel. This past week, I started mapping out new flowerbeds ...