• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Stephen L. Nelson

Author. Accountant. Aspiring Apiarist.

  • Articles
  • e-Books
    • Maximizing Section 199A Deduction
    • Setting a a Reasonable S Corporation Salary
    • Small Business Tax Deduction Secrets
    • Real Estate Tax Loopholes & Secrets
    • DIY LLC Formation and Incorporation Kits
    • Sample LLC Operating Agreements
    • Sample Corporation By-Laws
  • Contact

Using Excel

Installing the Small Business Financial Manager in Excel

May 18, 2015 By Stephen L. Nelson Leave a Comment

Cover to MBA's Guide to Microsoft Excel

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

Filed Under: Using Excel Tagged With: small business financial manager

Creating PivotCharts in Excel

May 18, 2015 By Stephen L. Nelson Leave a Comment

Cover to MBA's Guide to Microsoft 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

Filed Under: Using Excel Tagged With: pivotcharts, pivottables

Editing PivotTables in Excel

May 18, 2015 By Stephen L. Nelson Leave a Comment

Cover to MBA's Guide to Microsoft 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

Filed Under: Using Excel Tagged With: pivottables

Using Excel’s PivotTable Wizard

May 18, 2015 By Stephen L. Nelson Leave a Comment

Cover to MBA's Guide to Microsoft Excel

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

Filed Under: Using Excel Tagged With: pivottables

Retrieving External Data with Excel

May 18, 2015 By Stephen L. Nelson Leave a Comment

Cover to MBA's Guide to Microsoft 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

Filed Under: Using Excel Tagged With: sharing workbooks

Sharing Excel Data Over the Web

May 18, 2015 By Stephen L. Nelson Leave a Comment

Cover to MBA's Guide to Microsoft Excel

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

Filed Under: Using Excel Tagged With: sharing workbooks

  • « Go to Previous Page
  • Go to page 1
  • Interim pages omitted …
  • Go to page 4
  • Go to page 5
  • Go to page 6
  • Go to page 7
  • Go to page 8
  • Interim pages omitted …
  • Go to page 10
  • Go to Next Page »

Primary Sidebar

Article Categories

  • Accounting
  • Business Planning
  • Finance
  • Real Estate
  • Statistics
  • Taxes
  • Using Excel

Copyright © 2025 Stephen L. Nelson, Inc. · Contact · Steve’s Bio · Publications · Glossary