When you import data into Excel, if Excel determines that one of the values in a column of data contains a string, it might import all values in the column as strings, even though they are really ...

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

Two weeks ago I announced a bad graph contest to try to encourage software vendors to improve their offerings. Readers nominated a number of bad graphs for the contest. This post discusses some of the ...

If you use Microsoft Excel on a daily basis as a data analyst or number cruncher, learning how to use Excel’s advanced spreadsheet tools can significantly boost your productivity and efficiency in ...

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

If it feels like everyone in the business world is using Excel, it's because they pretty much are. According to a Forrester Research–based study, 81% of businesses worldwide rely on this software. As ...