• 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

Using the Add-In Financial Functions in Excel

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

Cover to MBA's Guide to Microsoft Excel

In addition to Excel’s 16 standard financial functions, Excel users also have access to another 42 add-in financial functions. Most business users of Excel won’t need these add-in functions, but if you perform much financial analysis with Excel—especially financial analysis of investments—you’ll … [Read more...] about Using the Add-In Financial Functions in Excel

Filed Under: Finance, Using Excel Tagged With: financial calculations

Using the Standard Financial Functions in Excel

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

Cover to MBA's Guide to Microsoft Excel

Excel provides 16 standard financial functions for making depreciation, loan payment, present value, future value, and rate of return calculations. To see which financial functions Excel provides or to see which arguments a function requires, choose the Insert menu’s Function command and then select … [Read more...] about Using the Standard Financial Functions in Excel

Filed Under: Finance, Using Excel Tagged With: financial calculations

EasyRefresher: Applying Time Value of Money Concepts

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

Cover to MBA's Guide to Microsoft Excel

The phrase “time value of money” must surely be one of the most used terms that people don’t really understand. Almost invariably, people who don’t know a discount rate from Adam use the term to explain or question any financial complexity. The irony—and most business school students and graduates … [Read more...] about EasyRefresher: Applying Time Value of Money Concepts

Filed Under: Finance, Using Excel Tagged With: financial calculations

Excel Data Analysis Tools

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

Cover to MBA's Guide to Microsoft Excel

This section describes the statistical data analysis tools that come with the Analysis ToolPak. To install the Analysis ToolPak, choose the Tools menu’s Add-Ins command, select the Analysis ToolPak check box, and click OK. Excel may prompt you to insert the Microsoft Office 2000 or Excel 2000 CD if … [Read more...] about Excel Data Analysis Tools

Filed Under: Statistics, Using Excel Tagged With: statistical analysis

Statistical Formulas in Excel

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

Cover to MBA's Guide to Microsoft Excel

This section describes the basic statistical functions that come with Excel. To see which functions Excel provides or to see which arguments a function requires, click the Paste Function toolbar button and then select Statistical from the Function Category list box (see Figure 4-1). Once … [Read more...] about Statistical Formulas in Excel

Filed Under: Statistics, Using Excel Tagged With: statistical analysis

Easy Refresher: Basic Business Statistics

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

Cover to MBA's Guide to Microsoft Excel

To determine which function to use and to insert the correct variables in the correct places, you need to know some key statistical terms. This section describes these terms. The science of statistics makes a fundamental distinction between two types of data sets, population data and sample data. … [Read more...] about Easy Refresher: Basic Business Statistics

Filed Under: Statistics, Using Excel Tagged With: statistical analysis

  • « Go to Previous Page
  • Go to page 1
  • Interim pages omitted …
  • Go to page 6
  • Go to page 7
  • Go to page 8
  • Go to page 9
  • 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