Rounding Functions

In this tutorial I will show how to use the `ROUND`, `ROUNDUP` and `ROUNDDOWN` functions in Excel.  … continue reading »

Statistical Funtions

In this tutorial I will show you how to use some of Excel’s very useful statistical functions. If you’re doing any data analysis work for your job, I’m sure you’re going to use these a lot.

How to use Financial functions in Excel

In this tutorial I will show you how to use some very useful financial functions in Excel by walking you through an example about a mortgage.

Text Functions

Excel offers many text functions that are super helpful if you need to edit or make additions to your text strings. In this tutorial I’ll teach you how to use them. … continue reading »

Date and Time functions

In this tutorial I will show you the different things you can do with Excel’s Date & Time function. … continue reading »

How to compare two columns to find duplicates in Excel

In this tutorial I will show you how to compare two columns in Excel so that the values that appear in both columns become highlighted and you can do something with those duplicate values. … continue reading »

How to find differences in a row or column in Excel

Have you ever had to find the cell whose value did not match those of other cells in the same row? … continue reading »

Logical functions in Excel: IF, AND and OR

In this tutorial I will show you how to use the Excel Logical functions such as IF, AND and OR. They are super useful if you need to calculate some values based on some logical criteria.

For example you only want a field to show you a number when another field is bigger than a specific value. In the following I’ll teach you how to do this:

SUM, COUNT & AVERAGE functions in Excel

Two of the most frequently used tools in Excel are the `Count` and `Sum` functions. These functions let you count and sum cells based on one or multiple different criteria.