How to Create a New Workbook in Excel. In Microsoft Excel, a program packaged with Microsoft Office, you can create databases of information and then make calculations, graphs and charts based on ...

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

Often we need to carry out manipulations in Excel documents and apply them to multiple rows, columns and sheets. To do this manually takes too much time and allows for errors to creep in, so Excel ...

A complex Excel 2007 workbook could require multiple sheets. By default, Microsoft provides three sheets on each workbook, but you can add as many as you need.