How to copy Macros Between Workbooks
In this lecture we will show how we can copy macros from one workbook to another
2607, 2019
Category Archives: Tutorials
2607, 2019
How to use the Financial Functions DURATION, MDURATION
The Macaulay duration (named after Frederick Macaulay) and its modified version, is a measure of a bond’s sensitivity to interest rate changes.
2305, 2019
How to use the Financial Functions PRICE, PRICEDISC, PRICEMAT
In order to be able to calculate the price per $100 face value we pay for an investment, Excel provides us with 3 tools.
The functions PRICE, PRICEMAT, PRICEDISC.
2305, 2019
How to use the Financial Functions YIELD, YIELDDISC, YIELDMAT
Excel provides us with numerous functions to calculate and manage securities.
Let’s start with the functions that calculate the Yield of a security. These are YIELD, YIELDMAT and YIELDDISC
2305, 2019
How to use the Financial Functions ACCRINT, ACCRINTM
Excel provides us with 2 functions for calculating accrued interest. ACCRINT, ACCRINTM.
But what exactly is accrued interest?
1704, 2019
Excel Statistics – Calculating the Covariance and the Correlation
In statistics, covariance and correlation are measures of how much two random variables change together. A positive number would indicate a positive linear relationship between the variables and a negative number would indicate the opposite.
1704, 2019
Excel Statistics – Calculating the Variance
One of the most useful measures in statistics is that of variance. It is a measure that is used to quantify the amount of variation or dispersion of a set of data values. I’ll try to explain what this means with an example, but there are plenty of other online sources if you want to explore the math behind it.
1704, 2019
Excel Statistics – Calculating the Standard Deviation
One of the most useful measures in statistics is that of standard deviation. It is a measure that is used to quantify the amount of variation or dispersion of a set of data values. I’ll try to explain what this means with an example, but there plenty of other online sources if you want to explore the math behind it.
1704, 2019
Excel Statistics – Calculating the Quartiles
In statistics, the quartiles, of a ranked set of data values, are the three points that divide the set into four equal groups. Each group constitutes a quarter of the data.
1704, 2019
Advanced Lookup Functions Combinations: Part 3
We have reached the end of our quest for the best lookup function, where we will talk about the combination of INDEX and MATCH. In the current lesson, we will use INDEX with dual MATCH functions, to achieve a matrix lookup functionality. But you can easily skip one of the two MATCH functions, and replace it with a static value if you are not interested in a matrix lookup.
