One of the more useful features in Microsoft Excel is Insert Charts. You can create a wide variety of charts: bar, line, pie and others. While many charts only involve one variable, you can create ...

Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.

A cluster chart is like a bar chart except that it clusters several bars into a category and displays each cluster separately from the rest. For example, you could categorize quarterly sales data by ...

Placing spreadsheet data into a table quickly formats it and makes it easy to work with and analyze. Here’s how to use this basic yet powerful Excel tool. Tables are one of the fundamental tools in ...