MBA's Guide to Microsoft Excel
Chapter 8
Pivottables and Pivotcharts
his chapter describes how you can use Excel’s PivotTable features to work with data bases in Excel. If you use Excel to list records, you can use the PivotTables feature to sort, filter, and pivot fields so you can better focus on the information you want.
Excel databases are simply worksheets that list information, as shown in Figure 8-1. The first row names the fields of the data. Subsequent rows hold the database. To sort a database, select the worksheet range holding the database and then choose the Data menu's Sort command. To filter a database, select the worksheet range holding the database and then choose the Data menu's Autofilter command or its Filter command.
Chapter Contents:
Need to build a business plan using Microsoft Excel?
Do you need a solid business plan? Perhaps to support a bank loan request or to map out a roadmap for entrepreneurial success? I may be able to help you.
I've updated the business planning workbook and instructions from the MBA's Guide to Excel so it conforms with current generally accepted accounting principles.
CLICK HERE FOR MORE INFO
