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

The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...

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 Microsoft Excel spreadsheet is among the most versatile business tools. Here’s a full guide on how to create a simple and effective Gantt chart in Excel.

Each cell in an Excel spreadsheet has a unique address, called a cell reference. This reference combines the letter that represents the cell's column with the number that represents its row. Cells in ...