The Small Business Tools, which include Small Business Financial Manager, that come with the Office 2000 aren’t automatically installed when you install the rest of Office 2000. These extra programs come on Disk 2 of the Office 2000 CD set. You may therefore need to in- stall these tools. To … [Read more...] about Installing the Small Business Financial Manager in Excel
Using Excel
Creating PivotCharts in Excel
Excel provides two ways of creating PivotCharts. If you’ve already created a PivotTable and want to chart the information on which it focuses, you can save time and space by creating a PivotChart directly from the PivotTable. If you haven’t created a PivotTable and are in- stead more interested in … [Read more...] about Creating PivotCharts in Excel
Editing PivotTables in Excel
PivotTables got their name because you can easily rearrange, or “pivot,” them. For example, you can move row headings to become column headings, or vice versa, or you can change the hierarchy of fields within a row or column heading. You can also separate PivotTable data among pages. You can … [Read more...] about Editing PivotTables in Excel
Using Excel’s PivotTable Wizard
Figure 8-1 shows three years of sales data for a microbrewery that sells six types of beer on the West coast. The company recorded sales for each type of beer by state and by season. You can see that with the large amounts of information in the database, it’s difficult to spot trends. Creating a … [Read more...] about Using Excel’s PivotTable Wizard
Retrieving External Data with Excel
Most of the earlier sections of this chapter presuppose you use Excel to create data you then pass along to other programs and people. While many people are very likely to use Excel in this way, you may use Excel to retrieve data created or stored by some other program. In the final pages of this … [Read more...] about Retrieving External Data with Excel
Sharing Excel Data Over the Web
Excel 2000 provides a special command—the File menu’s Save As Web Page command— for creating a web page version of an Excel workbook. You can also use the Save As Web Page command for creating interactive spreadsheet components for web pages. The paragraphs that follow describe how you do both of … [Read more...] about Sharing Excel Data Over the Web