Tutorials Archives | How To Excel

3 Ways to Calculate a Pearson’s Correlation Coefficient in Excel

by John | Aug 23, 2020 | Statistics, Tutorials | 2 |

Learn 3 easy ways to calculate the Pearson’s Correlation Coefficient statistic in Excel.

by John | May 14, 2020 | Tutorials | 0 |

Learn 9 ways to add or keep leading zeros for your numbers in Microsoft Excel.

by John | Apr 19, 2020 | Tutorials | 0 |

Learn 5 ways to convert your Excel files to PDF documents.

Learn 5 different ways to add the current date or time into Excel with keyboard shortcuts, functions, power query, power pivot and power automate.

by John | Dec 24, 2019 | Tutorials | 0 |

Data entry can sometimes be a big part of using Excel. With near endless cells, it can be hard for...

by John | Dec 20, 2019 | Tutorials | 2 |

Blank rows of data can be a big annoyance. They’ll make certain things like navigating...

by John | Nov 13, 2019 | Tutorials | 3 |

In this post we’re going to take a look at 5 ways to find the weekday name from a date in Excel.