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
Using Excel
Using the Standard Financial Functions in 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
EasyRefresher: Applying Time Value of Money Concepts
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
Excel Data Analysis Tools
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
Statistical Formulas in 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
Easy Refresher: Basic Business Statistics
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