We all know that Excel can make some gorgeous charts and graphs, but if you are like 30 Rock's Liz Lemon and don't know your scatter plot from your triangle graph ("I don't know. It sounded real!"), ...

Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know.

If you have an Excel spreadsheet that contains empty data, such as empty rows or columns, and plot a graph from the spreadsheet, Excel plots all empty data. Microsoft Excel 2010 does not plot hidden ...