SMS221 Lecture Notes - Lecture 4: Pareto Chart, Pie Chart, Microsoft Excel
Document Summary
Objectives: create a line chart, create a combination chart, format chart elements, modify the chart"s data source, create a histogram and pareto chart, add sparklines to a worksheet, format cells with data bars. Introduction to financial functions: cost of a loan to the borrower is largely based on three factors, principal: amount of money being loaned, interest: amount added to the principal by the lender, time required to repay the loan. Introduction to financial functions: using the pmt function, to calculate the costs associated with a loan, you must have the following information: The number of payment periods per year. The length of the loan in terms of the total number of payment periods. Introduction to financial functions: the syntax of the pmt function is: Getting started with excel charts: exploring chart types and subtypes of your reports and projects. Each slice represents a single value from a data series. Larger data values are represented with bigger pie slices.
