## Tutorials

## Excel Statistics - Calculating the Covariance and the CorrelationIn 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. | |

## Excel Statistics - Calculating the VarianceOne 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. | |

## Excel Statistics - Calculating the Standard DeviationOne 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. | |

## Excel Statistics - Calculating the QuartilesIn 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. | |

## Advanced Lookup Functions Combinations: Part 3We 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. | |

## Functions

## The PROPER FunctionIt capitalizes the first letter of each word and converts the rest of the letters to lowercase. | |

## The MID FunctionIt returns a specific amount of characters from a string, starting at a specific position in the string. | |

## The LOWER FunctionIt converts all letters in a string to lowercase. | |

## The LEFT FunctionIt returns a certain amount of characters from the beginning of a string. | |

## The SEARCH FunctionIt finds one text string that exists inside another text string and returns the position within the second string, from which the first one begins. It is NOT case-sensitive and allows wildcard characters. | |

## Shortcuts

## Excel Shortcuts in MacThis is a searchable list of all the shortcuts in Mac. | |

## Categorized Excel Shortcuts in MacThis is a categorized collection of all the shortcuts in Mac. | |

## Excel Shortcuts in WindowsThis is a searchable list of all the shortcuts in Windows. | |

## Categorized Excel Shortcuts in WindowsThis is a categorized collection of all the shortcuts in Windows. | |