Excel 2019 Advanced Topics: Leverage More Powerful Tools to Enhance Your Productivity (Excel 2019 Mastery) by George Nathan

Author:George, Nathan
Language: eng
Format: epub
Published: 2019-07-03T16:00:00+00:00

Formula explanation

=PMT(A2/12,B2,C2)

The rate argument is a reference to cell A2 divided by 12, to represent the interest rate in monthly terms as nper (cell B2) is also specified in monthly terms. The pv argument takes in C2, which is the present value of the loan $10,000.

Answer: ($869.88)

=PMT(A3/12,B3,C3)

This formula is also for a loan of $10,000, however, the nper is 60 and the rate is 4.9 percent.

Answer: ($188.25)

Installing the Analysis ToolPak

The Excel Analysis ToolPak is an add-on that you can install that enables you to carry out complex statistical or engineering analyses. You can save a lot of time as you simply provide the data and parameters, and the tool uses the appropriate engineering or statistical functions to calculate and display the results in output tables. Some of the tools even generate charts in addition to output tables.

You can only use the data analysis functions on one worksheet at a time. When you carry out data analysis on a group of worksheets at the same time, results will appear on the first worksheet and empty tables will appear on the remaining worksheets. To carry out the data analysis on the rest of the worksheets, you’ll need to recalculate the analysis tool for each worksheet.

Follow these steps to install the Analysis ToolPak:

Click on File > Excel Options (or press Alt+FT to directly open the Excel Options dialog box), and then click on Add-Ins.

The Add-Ins tab lists all the names, locations, and types of the add-ins currently available to you in Excel.

In the Manage box (at the bottom of the Add-ins tab), select Excel Add-ins and then click Go.

If you're on a Mac, in the file menu go to Tools > Excel Add-ins.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.